XinYu_LZMES/.svn/pristine/d0/d02f12989055baac69cc2dde298ddb9b1deefca2.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="包装作业管理">
	<query id="UIM020020_01.SELECT"  desc="查询待包装钢卷">
		<![CDATA[
        SELECT 'FALSE' CHK,A.OLD_SAMPL_NO,--PACKAGE_LEVEL,
        A.PRINT_TP,NVL(C.BUY_ABBSYM,A.SPEC_ABBSYM) SPEC_ABBSYM,nvl(c.DDC_STL_GRD,a.SPEC_STL_GRD) DDC_STL_GRD,
        A.SPEC_STL_GRD,A.COIL_THK,A.COIL_WTH,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.ACT_WGT,
        DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL,A.ORD_NO,
        A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD,
        DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD,
        DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD,
        DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST,
        DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判') EXTSHAPE_DEC_GRD,
        DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
        ,C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME
        ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG
        ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
        ,DECODE(A.YARD_ENTRY_GROUP,'1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP,
        SUBSTR(B.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T 
        WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP,
        (SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD,
        decode(A.CUR_PROG_CD,'CRC','酸轧卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
        ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
        ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
             ) CUR_PROG_CD
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE
        ,DECODE(c.PAKMTH_TP,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PAKMTH_TP
        --,E.SMP_SEND_DTIME
        --,E.SMP_WORK_DTIME
        --,E.QLTY_DCS_DTIME
        --,E.SMP_INTO_DTIME
        --,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME
        --,to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME
     --   ,to_char(to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') MILL_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
        ,C.XSQY
        --,''||'/'||'' AFFIRMTIME
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA
        ,NVL(C.PRODUCT_LX,PKG_QUALITY_COMM.FZ00_COMM('A01007', T.C_ORD_USE_TP)) C_ORD_USE_TP
        ,(select c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010' and SM_CD = A.PACKAGE_LEVEL) PACKAGE_LEVEL
        FROM C_TBL02_COIL_COMM A,TBG02_SLAB_COMM B,TBA01_ORD_LINE C,TBA01_ORD_COMM D,tbb01_ord_head t,
        TBB02_LOT_COM E WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) 
        AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = T.ORD_NO(+)
   		AND A.ORD_SEQ = T.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.SMP_NO = E.SMP_NO(+) 
        AND A.COIL_STAT = '2' AND A.PACKAGE_FL != '1'/*A.CUR_PROG_CD = 'DCB'*/ 
        AND A.LINE_TP IS NULL
        AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.COIL_NO||'&' LIKE ?||'%'
		 ]]>
	</query>
	<query id="UIM020020_02.SELECT"  desc="查询已包装钢卷">
		<![CDATA[
        SELECT 'FALSE' CHK,A.OLD_SAMPL_NO,--PACKAGE_LEVEL,
        A.PRINT_TP,NVL(C.BUY_ABBSYM,A.SPEC_ABBSYM) SPEC_ABBSYM,nvl(c.DDC_STL_GRD,a.SPEC_STL_GRD) DDC_STL_GRD,
        A.SPEC_STL_GRD,A.COIL_THK,A.COIL_WTH,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.ACT_WGT,
        DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL,A.ORD_NO,
        A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD,
        DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD,
        DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD,
        DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST,
        DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判') EXTSHAPE_DEC_GRD,
        DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
        ,C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME
        ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG
        ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
        ,DECODE(A.YARD_ENTRY_GROUP,'1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP,
        SUBSTR(B.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T 
        WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP,
        (SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD,
        decode(A.CUR_PROG_CD,'CRC','酸轧卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
        ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
        ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
             ) CUR_PROG_CD
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE
        ,DECODE(c.PAKMTH_TP,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PAKMTH_TP
        --,E.SMP_SEND_DTIME
        --,E.SMP_WORK_DTIME
        --,E.QLTY_DCS_DTIME
        --,E.SMP_INTO_DTIME
        --,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME
        --,to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME
     --   ,to_char(to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') MILL_DTIME
    , C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
        ,C.XSQY
        --,''||'/'||'' AFFIRMTIME
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA
        ,NVL(C.PRODUCT_LX,PKG_QUALITY_COMM.FZ00_COMM('A01007', T.C_ORD_USE_TP)) C_ORD_USE_TP
        ,(select c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010' and SM_CD = A.PACKAGE_LEVEL) PACKAGE_LEVEL
        FROM C_TBL02_COIL_COMM A,TBG02_SLAB_COMM B,TBA01_ORD_LINE C,TBA01_ORD_COMM D,tbb01_ord_head t,
        TBB02_LOT_COM E WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) 
        AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = T.ORD_NO(+)
   		AND A.ORD_SEQ = T.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.SMP_NO = E.SMP_NO(+) 
        AND A.COIL_STAT = '2' AND A.CUR_PROG_CD <> 'DCB' AND A.PACKAGE_FL = 1
        AND A.LINE_TP IS NULL
        AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.COIL_NO||'&' LIKE ?||'%'
		 ]]>
	</query>
	
	<query id="UIM020020_03.SELECT"  desc="查询包装钢卷卷数和重量">
		<![CDATA[
		select count(1) packageCount,sum(t.ACT_WGT) packageAct_Wgt from c_tbl02_coil_comm t where t.PACKAGE_DTIME like ? ||'%' and t.PACKAGE_FL = '1'
		]]>
	</query>
	
	<query id="UIM020020_11.SELECT"  desc="查询包装方法">
		<![CDATA[
		select c.SM_CD,c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010'
		]]>
	</query>
	<query id="UIM020020_01.UPDATE"  desc="包装作业">
		<![CDATA[
		UPDATE C_TBL02_COIL_COMM L 
		  SET L.CUR_PROG_CD = decode(L.LINE_TP,'S',L.CUR_PROG_CD,'DFA')
		  ,L.PACKAGE_FL = '1'
		  ,L.PACKAGE_LEVEL = ?
		  ,L.PACKAGE_SHIFT = ?
		  ,L.PACKAGE_GROUP = ?
		  ,L.PACKAGE_REG = ?
		  ,L.PACKAGE_DTIME = TO_CHAR(SYSDATE,'YYYYMMDD')
		  ,L.PACKAGE_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  WHERE L.COIL_NO = ?
		]]>
	</query>
	<query id="UIM020020_02.UPDATE"  desc="修改包装作业">
		<![CDATA[
		UPDATE C_TBL02_COIL_COMM L 
		  SET L.PACKAGE_LEVEL = ?
		  ,L.PACKAGE_SHIFT = ?
		  ,L.PACKAGE_GROUP = ?
		  ,L.PACKAGE_REG = ?
		  ,L.PACKAGE_DTIME = TO_CHAR(SYSDATE,'YYYYMMDD')
		  ,L.PACKAGE_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  WHERE L.COIL_NO = ?
		]]>
	</query>
		<query id="UIM020020_04.SELECT"  desc="查询待包装钢卷">
		<![CDATA[
        SELECT 'FALSE' CHK,A.OLD_SAMPL_NO,--PACKAGE_LEVEL,
        A.PRINT_TP,NVL(C.BUY_ABBSYM,A.SPEC_ABBSYM) SPEC_ABBSYM,nvl(c.DDC_STL_GRD,a.SPEC_STL_GRD) DDC_STL_GRD,
        A.SPEC_STL_GRD,A.COIL_THK,A.COIL_WTH,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.ACT_WGT,
        DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL,A.ORD_NO,
        A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD,
        DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD,
        DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD,
        DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST,
        DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判') EXTSHAPE_DEC_GRD,
        DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
        ,C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME
        ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG
        ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
        ,DECODE(A.YARD_ENTRY_GROUP,'1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP,
        SUBSTR(B.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T 
        WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP,
        (SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD,
        decode(A.CUR_PROG_CD,'CRC','酸轧卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
        ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
        ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
             ) CUR_PROG_CD
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE
        ,C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
        ,C.XSQY
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA
        ,DECODE(c.PAKMTH_TP,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PAKMTH_TP
        ,NVL(C.PRODUCT_LX,PKG_QUALITY_COMM.FZ00_COMM('A01007', T.C_ORD_USE_TP)) C_ORD_USE_TP
        ,(select c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010' and SM_CD = A.PACKAGE_LEVEL) PACKAGE_LEVEL
        FROM C_TBL02_COIL_COMM A,TBG02_SLAB_COMM B,TBA01_ORD_LINE C,TBA01_ORD_COMM D,tbb01_ord_head t,
        TBB02_LOT_COM E WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) 
        AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = T.ORD_NO(+)
   		AND A.ORD_SEQ = T.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.SMP_NO = E.SMP_NO(+) 
   		AND A.LINE_TP='S'
        AND A.COIL_STAT = '2' AND A.PACKAGE_FL != '1'/*A.CUR_PROG_CD = 'DCB'*/ 
        AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.COIL_NO||'&' LIKE ?||'%'
		 ]]>
	</query>
	<query id="UIM020020_05.SELECT"  desc="查询已包装钢卷">
		<![CDATA[
        SELECT 'FALSE' CHK,A.OLD_SAMPL_NO,--PACKAGE_LEVEL,
        A.PRINT_TP,NVL(C.BUY_ABBSYM,A.SPEC_ABBSYM) SPEC_ABBSYM,nvl(c.DDC_STL_GRD,a.SPEC_STL_GRD) DDC_STL_GRD,
        A.SPEC_STL_GRD,A.COIL_THK,A.COIL_WTH,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.ACT_WGT,
        DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL,A.ORD_NO,
        A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD,
        DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD,
        DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD,
        DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST,
        DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判') EXTSHAPE_DEC_GRD,
        DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
        ,C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME
        ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG
        ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
        ,DECODE(A.YARD_ENTRY_GROUP,'1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP,
        SUBSTR(B.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T 
        WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP,
        (SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD,
        decode(A.CUR_PROG_CD,'CRC','酸轧卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
        ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
        ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
             ) CUR_PROG_CD
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE
        ,C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
        ,C.XSQY
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA
        ,DECODE(c.PAKMTH_TP,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PAKMTH_TP
        ,NVL(C.PRODUCT_LX,PKG_QUALITY_COMM.FZ00_COMM('A01007', T.C_ORD_USE_TP)) C_ORD_USE_TP
        ,(select c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010' and SM_CD = A.PACKAGE_LEVEL) PACKAGE_LEVEL
        FROM C_TBL02_COIL_COMM A,TBG02_SLAB_COMM B,TBA01_ORD_LINE C,TBA01_ORD_COMM D,tbb01_ord_head t,
        TBB02_LOT_COM E WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) 
        AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = T.ORD_NO(+)
   		AND A.ORD_SEQ = T.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.SMP_NO = E.SMP_NO(+) 
   		AND A.LINE_TP='S'
        AND A.COIL_STAT = '2' AND A.CUR_PROG_CD <> 'DCB' AND A.PACKAGE_FL = 1
        AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.COIL_NO||'&' LIKE ?||'%'
		 ]]>
	</query>
	<query id="UIM020020_06.SELECT"  desc="查询待包装钢卷">
		<![CDATA[
        SELECT 'FALSE' CHK,A.OLD_SAMPL_NO,--PACKAGE_LEVEL,
        A.PRINT_TP,NVL(C.BUY_ABBSYM,A.SPEC_ABBSYM) SPEC_ABBSYM,nvl(c.DDC_STL_GRD,a.SPEC_STL_GRD) DDC_STL_GRD,
        A.SPEC_STL_GRD,A.COIL_THK,A.COIL_WTH,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.ACT_WGT,
        DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL,A.ORD_NO,
        A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD,
        DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD,
        DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD,
        DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST,
        DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判') EXTSHAPE_DEC_GRD,
        DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
        ,C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME
        ,C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME
        ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG
        ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
        ,DECODE(A.YARD_ENTRY_GROUP,'1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP,
        SUBSTR(B.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T 
        WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP,
        (SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD,
        decode(A.CUR_PROG_CD,'CRC','酸轧卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
        ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
        ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
             ) CUR_PROG_CD
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE
        ,C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
        ,C.XSQY
        ,C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA
        ,DECODE(c.PAKMTH_TP,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PAKMTH_TP
        ,NVL(C.PRODUCT_LX,PKG_QUALITY_COMM.FZ00_COMM('A01007', T.C_ORD_USE_TP)) C_ORD_USE_TP
        ,(select c.SM_CFNM from tbz00_commcd c where c.LG_CD = 'A01010' and SM_CD = A.PACKAGE_LEVEL) PACKAGE_LEVEL
        FROM C_TBL02_COIL_COMM A,TBG02_SLAB_COMM B,TBA01_ORD_LINE C,TBA01_ORD_COMM D,tbb01_ord_head t,
        TBB02_LOT_COM E WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) 
        AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = T.ORD_NO(+)
   		AND A.ORD_SEQ = T.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.SMP_NO = E.SMP_NO(+) 
   		AND A.LINE_TP='S'
        AND A.COIL_STAT = '2' AND A.PACKAGE_FL != '1'/*A.CUR_PROG_CD = 'DCB'*/ AND C.PAKMTH_TP !='1'
        AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.COIL_NO||'&' LIKE ?||'%'
		 ]]>
	</query>
</queryMap>