SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,A.CUR_PROG_CD,A.SPEC_STL_GRD, A.COIL_THK,A.COIL_WTH,A.COIL_LEN, A.COIL_INDIA,A.COIL_OUTDIA,A.ACT_WGT, DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD, C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(A.CRK_CD1,A.CRK_CD2,A.CRK_CD3,A.CRK_CD4,A.CRK_CD5) BUG, A.CUR_LOAD_LOC, B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX, B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX, B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT ORD_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD, B.PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG, B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE FROM C_TBC02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D WHERE A.COIL_STAT='2' AND A.ORD_NO=B.ORD_NO(+) AND A.ORD_SEQ=B.ORD_SEQ(+) AND A.CUR_LOAD_LOC IS NOT NULL AND A.FAN_XIU = 'Y' AND B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+) SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,F.CUR_PROG_CD,F.SPEC_STL_GRD, F.COIL_THK,F.COIL_WTH,F.COIL_LEN, F.COIL_INDIA,F.COIL_OUTDIA,F.COIL_WGT, DECODE(F.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD, C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(F.CRK_CD1,F.CRK_CD2,F.CRK_CD3,F.CRK_CD4,F.CRK_CD5) BUG, A.CUR_LOAD_LOC, B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX, B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX, B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD, B.PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG, B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE, F.DCL_REASON,F.DCL_MEMO,F.STATUS_CD FROM C_TBC02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D,L_TBF03_CAL_DECLARE F WHERE F.ORD_NO=B.ORD_NO AND F.ORD_SEQ=B.ORD_SEQ AND A.OLD_SAMPL_NO=F.C_COIL_NO AND B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+) SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD='F02001' SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01118' AND CD_DESC = 'C'