{call PKG_UIG.PROD_PLT_SLAB_TRANS(:1,:2)} 'J91-00910A010' AND A.SLAB_RT IN ('P','Z') AND A.PLT_TRS_CAR_NO IS NULL --AND A.ORD_FL = '1' AND A.DSN_SLAB_NO = J.DSN_SLAB_NO ]]> 'J91-00910A010' AND A.SLAB_RT IN ('P','Z') AND A.PLT_TRS_CAR_NO IS NULL AND A.PLAN_SLAB_NO = F.SLAB_MANA_NO AND F.DSN_SLAB_NO = J.DSN_SLAB_NO ]]> SELECT TO_CHAR(SYSDATE , 'YYYY-MM-DD HH24:MI') DATE_ ,T.PRINT_ZH_NO --打印流水号 ,T.PLT_TRS_CAR_NO CAR_NO ,DECODE(T.SLAB_RT , 'Z' , '中板线' , '厚板线') CHAN_XIAN ,DECODE(? , 'Y' , 'Y' , 'N') NEED_CHEM --是否打印成分 ,NVL(XB_PACKAGE.GF_USER_FIND(?) , ' ') REG_NM FROM TBG02_SLAB_COMM T WHERE INSTR(? , T.SLAB_NO ) > 0 AND ROWNUM = 1 0 ORDER BY T1.SLAB_NO ]]> SELECT ROW_NUMBER() OVER (ORDER BY XXX.SLAB_NO ) 序号, XXX.* FROM ( SELECT T2.SLAB_NO ,MAX(DECODE(T1.CHEM_CD , 'C' , CHEM_VAL )) C ,MAX(DECODE(T1.CHEM_CD , 'Mn' , CHEM_VAL )) MN ,MAX(DECODE(T1.CHEM_CD , 'S' , CHEM_VAL )) S ,MAX(DECODE(T1.CHEM_CD , 'P' , CHEM_VAL )) P ,MAX(DECODE(T1.CHEM_CD , 'Si' , CHEM_VAL )) SI ,MAX(DECODE(T1.CHEM_CD , 'Cr' , CHEM_VAL )) CR ,MAX(DECODE(T1.CHEM_CD , 'Ni' , CHEM_VAL )) NI ,MAX(DECODE(T1.CHEM_CD , 'Cu' , CHEM_VAL )) CU ,MAX(DECODE(T1.CHEM_CD , 'Nb' , CHEM_VAL )) NB ,MAX(DECODE(T1.CHEM_CD , 'Mo' , CHEM_VAL )) MO ,MAX(DECODE(T1.CHEM_CD , 'V' , CHEM_VAL )) V ,MAX(DECODE(T1.CHEM_CD , 'Ti' , CHEM_VAL )) TI ,MAX(DECODE(T1.CHEM_CD , 'Alt' , CHEM_VAL )) ALT ,MAX(DECODE(T1.CHEM_CD , 'Als' , CHEM_VAL )) ALS ,MAX(DECODE(T1.CHEM_CD , 'B' , CHEM_VAL )) B ,MAX(DECODE(T1.CHEM_CD , 'N' , CHEM_VAL )) N FROM TBB02_WORK_INGR T1 , TBG02_SLAB_COMM T2 , TBG02_CHARGE_COMM_D T3 WHERE T1.CHARGE_NO = SUBSTR(T2.SLAB_NO , 1,10) AND T1.CHARGE_NO = T3.CHARGE_NO AND T1.PROC_CD||T1.CHEM_SEQ = T3.LST_INGR_CD AND INSTR(? , T2.SLAB_NO ) > 0 GROUP BY T2.SLAB_NO ) XXX ORDER BY XXX.SLAB_NO UPDATE TBG02_SLAB_COMM T SET T.PRINT_ZH_NO = (SELECT 'EG-'||TO_CHAR(SYSDATE , 'YYYYMMDD')||'-'||TO_CHAR( NVL(MAX(SUBSTR(X.PRINT_ZH_NO ,13 ,7)) , 0) +1 , '000') FROM TBG02_SLAB_COMM X WHERE SUBSTR(X.PRINT_ZH_NO , 4,8) = TO_CHAR(SYSDATE , 'YYYYMMDD') ) WHERE INSTR(? , T.SLAB_NO ) > 0