| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
- <query id="UIF071030.Query_PkgPlan" desc='得到包装单元计划的明细信息'>
- <![CDATA[
- SELECT F.PKG_NO,
- F.C_COIL_NO COIL_NO,
- nvl(A.COIL_THK,0) COIL_THK,
- nvl(A.COIL_WTH,0) COIL_WTH,
- A.COIL_LEN,
- A.COIL_INDIA,
- A.COIL_OUTDIA,
- A.ACT_WGT,
- C.C_ORD_THK,
- C.C_ORD_WTH,
- C.C_ORD_LEN,
- C.C_ORD_INDIA,
- C.C_ORD_OUTDIA,
- C.C_EXTSHAPE_REQ,
- B.SM_CSNM CUR_PROG_CD,
- F.STATUS_CD,
- A.CUR_LOAD_LOC,
- C.ACID_PROD_PATH,
- C.ORD_NO,
- C.ORD_SEQ,
- C.C_SPEC_STL_GRD,
- C.C_SPEC_ABBSYM,
- H.SM_CFNM ORD_USEAGE_CD,
- C.DEL_TO_DATE,
- D.CUST_NM ORDCUST_CD,
- E.SM_CFNM DEST_CD,
- C.ORD_UNIT_WGT,
- C.ORD_UNIT_WGT_MIN,
- C.ORD_UNIT_WGT_MAX,
- C.C_PRODNM_CD,
- I.SM_CFNM PACK_METHOD,
- DECODE(C.EDGE_PROC_YN, 'Y', '√', NULL) EDGE_PROC_YN
- FROM C_TBC02_COIL_COMM A,
- TBE02_ORD_PRC C,
- TBZ00_COMMCD B,
- TBZ00_CUSTOMER D,
- TBZ00_COMMCD E,
- L_TBF03_SPEC_PACK F,
- TBZ00_COMMCD H,
- TBZ00_COMMCD I
- WHERE F.ORD_NO = C.ORD_NO(+)
- AND F.ORD_SEQ = C.ORD_SEQ(+)
- AND A.CUR_PROG_CD = B.SM_CD(+)
- AND C.ORDCUST_CD = D.CUST_CD(+)
- AND C.PACK_METHOD = I.SM_CD(+)
- AND C.C_ORD_USEAGE_CD = H.SM_CD(+)
- AND C.DEST_CD = E.SM_CD(+)
- AND A.OLD_SAMPL_NO = F.C_COIL_NO
- AND I.LG_CD(+) = 'A01010'
- AND F.FLAG = 'Y'
- AND (SELECT COUNT(1) FROM L_TBF03_SPEC_PACK T WHERE T.PKG_NO = F.PKG_NO AND T.STATUS_CD NOT IN('D','E')) > 0
- AND F.STATUS_CD IN('A', 'B', 'C', 'D', 'F') ORDER BY F.COIL_EDT_SEQ
- ]]>
- </query>
- <query id="UIF071030.Del_PkgCoil" desc="删除计划钢卷信息" >
- <![CDATA[
- {call C_PKG_UIF_PKG.P_PRD_PACKCOIL_DEL(?,?,?,?)}
- ]]>
- </query>
- </queryMap>
|
