SELECT T.OLD_SAMPL_NO COIL_NO ,T.PRODNM_CD ,T.SPEC_STL_GRD ,T.SPEC_ABBSYM ,T.COIL_THK ,T.DCS_THK ,T.SMP_NO ,T.SMP_CUT_LOC ,T.EXTSHAPE_QUALITY ,T.MATLQLTY_DEC_GRD ,T.ORD_USE_CD ,ZL_NORM_COMM.FZ00_COMM('A01007' , T.ORD_USE_CD) ORD_USE_NM FROM C_TBC02_COIL_COMM T WHERE T.ORD_FL = '2' AND T.COIL_STAT = '2' AND T.OLD_SAMPL_NO LIKE ?||'%' AND T.MATLQLTY_DEC_GRD = '2' AND T.SMP_STATS IS NULL SELECT T.OLD_SAMPL_NO COIL_NO ,T.PRODNM_CD ,T.SPEC_STL_GRD ,T.SPEC_ABBSYM ,T.COIL_THK ,T.DCS_THK ,T.SMP_NO ,T.SMP_CUT_LOC ,T.EXTSHAPE_QUALITY ,T.MATLQLTY_DEC_GRD ,T.ORD_USE_CD ,ZL_NORM_COMM.FZ00_COMM('A01007' , T.ORD_USE_CD) ORD_USE_NM FROM C_TBC02_COIL_COMM T WHERE T.ORD_FL = '2' AND T.COIL_STAT = '2' AND T.OLD_SAMPL_NO LIKE ?||'%' AND (T.SMP_STATS IS NULL OR T.SMP_STATS='3') ORDER BY T.OLD_SAMPL_NO SELECT T.OLD_SAMPL_NO ,T.PRODNM_CD ,T.SPEC_ABBSYM ,T.SPEC_STL_GRD ,T.ORD_USE_CD ,ZL_NORM_COMM.FZ00_COMM('A01007' , T.ORD_USE_CD) ORD_USE_NM ,T.COIL_THK ,T.COIL_WTH ,T.SMP_NO ,T.SMP_CUT_LOC ,T.SMP_STATS ,LM.PRDNM_CD OLD_PRDNM_CD --原交货状态 ,LM.SPEC_ABBSYM OLD_SPEC_ABBSYM --原标准号 ,LM.SPEC_STL_GRD OLD_SPEC_STL_GRD --原牌号 ,LM.ORD_USE_TP OLD_ORD_USE_CD --原订单用途 ,ZL_NORM_COMM.FZ00_COMM('A01007' , LM.ORD_USE_TP) OLD_ORD_USE_NM ,T.SMP_DIR_PIC_YN ,T.SMP_PICK_YN ,LC.ORD_NO --改判合同号 ,LC.ORD_SEQ --改判订单号 ,LC.ORG_SMP_NO --原试样号 ,LC.ORG_SMP_CUT_LOC --原试样位置 ,LC.REG_ID ---改判人 ,LC.REG_DTIME -- 改判时间 ,T.TOT_DEC_GRD ,T.TOT_DEC_DTIME ,T.EXTSHAPE_QUALITY ,T.MATLQLTY_DEC_GRD ,T.ACT_WGT ,T.COIL_STAT ,TO_CHAR(T.DCS_THK,'FM9999990.00099')||'*'||T.DCS_WTH DCS_GUIGE FROM C_TBC02_COIL_COMM T ,TBB02_LOT_COIL LC ,TBB02_LOT_COM LM WHERE T.ORD_FL = '2' AND T.COIL_STAT = '2' AND T.OLD_SAMPL_NO LIKE ?||'%' AND T.SMP_STATS IS NOT NULL AND T.SMP_STATS != '3' AND T.SMP_NO = LC.SMP_NO AND T.SMP_CUT_LOC = LC.SMP_CUT_LOC AND LC.ORG_SMP_NO = LM.SMP_NO AND LC.ORG_SMP_CUT_LOC = LM.SMP_CUT_LOC ORDER BY T.OLD_SAMPL_NO = ? ORDER BY T.PRDNM_CD , T.SPEC_ABBSYM , T.SPEC_STL_GRD ]]> 'M' AND A.PROD_LINE = 'C' AND ('L' IN (SELECT * FROM TABLE(XB_PACKAGE.GF_TABSTR(A.ORD_PRC_LOCK,'|'))) or A.ORD_PRC_LOCK is null) AND A.ORD_NO LIKE ? || '%' -- 合同号 AND A.OVER_ORD IS NULL ORDER BY A.DEL_TO_DATE, A.ORD_NO, A.ORD_SEQ ]]> = ? AND T.QLTY_CD <> 'SAMP' AND T.QLTY_CD = SQ.QLTY_CD ORDER BY SQ.DISPLAY_SEQ ]]> {call ZL_LIANT_DCS01.DCS_STL_GRD(?,?,?,?,?,?,?)} {call ZL_LIANT_DCS01.YUCAI_DCS_STL_GRD(?,?,?,?,?,?,?,?,?)} {call SX_LIANT_DCS01.YUCAI_DCS_STL_GRD(?,?,?,?,?,?,?,?,?)} {call UIB030230_LTGP_YCGP_ORD(?,?,?,?,?,?,?,?,?,?,?,?)} {call UIB030230_LTGP_SEND_L2INSMP(?,?)} {call UIB030230_LTGP_XMTH(?,?,?,?,?)} {call UIB030230_LTGP_CANCER(?,?,?,?,?,?,?,?,?,?)} {call UIB030230_LTGP_DCS_QLTY(?,?)}