| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="NID040010">
- <query id="NID040010.CastSpecResult.Select" desc="">
- <![CDATA[
- SELECT Y.NX_CAST_EDT_SEQ
- , TO_CHAR(Y.NX_CAST_MANA_NO,'FM000000') AS NX_CAST_MANA_NO
- , Y.NX_CAST_MANA_NO AS NX_CHG_CAST_MANA_NO
- , TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') AS CURR_DTIME
- , NVL(X.MOD_ID,'NID040010') AS CURR_ID
- FROM TBD01_MATDN_RST3 X
- ,(SELECT NVL(MAX(CAST_EDT_SEQ) ,0) + 1 AS NX_CAST_EDT_SEQ
- , NVL(MAX(TO_NUMBER(CAST_MANA_NO)),0) + 1 AS NX_CAST_MANA_NO
- FROM TBF01_SPEC_CAST) Y
- WHERE X.MAT_SPEC_SEQ = :1
- ]]>
- </query>
-
- <query id="NID040010.CastSpec.Row.Insert" desc="">
- <![CDATA[
- INSERT INTO TBF01_SPEC_CAST( CAST_EDT_SEQ, CAST_MANA_NO, CHG_CAST_MANA_NO
- , CCM_WRKSTR_DTIME, CCM_WRKEND_DTIME
- , FL
- , REG_DTIME, REG_ID
- , MOD_DTIME, MOD_ID )
- VALUES( ?, ?, ?
- , ?, ?
- , ?
- , ?, ?
- , ?, ? )
- ]]>
- </query>
- <query id="NID040010.ChargeDnResult.Select" desc="">
- <![CDATA[
- SELECT X.MAT_SPEC_SEQ
- , X.PMAT_SPEC_SEQ AS CAST_NO
- , X.WITHIN_SUB_SEQ AS CAST_CHARGE_SEQ
- , COUNT(*) OVER () AS CAST_EDT_CHARGE_CNT
- , Y.MAT_SPEC_SEQ AS SLAB_NO
- --, Y.PMAT_SPEC_SEQ AS CHARGE_NO
- , Y.PRODNM_CD
- , Y.FAC_STL_GRD AS STL_GRD
- , Y.FAC_STL_GRP AS STL_GRP_CD
- , Y.MAT_RT AS CHARGE_RT
- , Y.SPEC_ABBSYM AS SPEC_ABBSYM
- , Z.SM_CD AS TREAT_RT_CD
- , Y.PATH_PROC_CD AS PATH_PROC_CD
- , Y.LANE_PROC_CD
- , Y.MAT_THK AS CCM_THK
- , Y.MAT_WTH AS CCM_WTH
- , Y.SUM_FL_1_CNT AS ORD_SLAB_CNT
- , Y.SUM_FL_2_CNT AS NONORD_SLAB_CNT
- , Y.NONORD_CHARGE_FL
- , Y.SLAB_CNT
- , Y.SUM_MAT_WGT AS PREV_CHARGE_WGT
- , Y.HCR_YN
- , Y.HCR_CLF
- , Y.EMGMTR_NMG_CLF
- , Y.BOF_TEMP_TGT
- , Y.CAS_TEMP_TGT
- , Y.RH_TEMP_TGT
- , Y.LF_TEMP_TGT
- , Y.TD_TEMP_AVG
- , Y.TD_TEMP_MIN
- , Y.TD_TEMP_MAX
- , Y.SOLIDE_TEMP_TGT1
- , Y.SOLIDE_TEMP_TGT2
- , Y.LANE_CD
- FROM TBD01_MATDN_RST3 X
- ,(SELECT A.MAT_SPEC_SEQ
- , A.PMAT_SPEC_SEQ
- ,'AR' AS PRODNM_CD /*C.PRODNM_CD */
- , A.FAC_STL_GRD
- , A.FAC_STL_GRP
- , A.MAT_RT
- , 'SPEC_ABBSYM' AS SPEC_ABBSYM /*C.SPEC_ABBSYM */
- , A.PATH_PROC_CD
- , CASE A.LANE_CD WHEN '1' THEN ''
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 1)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 1) + 1, 1)||'1')
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 3)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 3) + 1, 1)||'1')
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 5)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 5) + 1, 1)||'1')
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 7)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 7) + 1, 1)||'1')
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 9)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 9) + 1, 1)||'1')
- ||DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J',11)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J',11) + 1, 1)||'1')
- WHEN '2' THEN ''
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 1)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 1), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 1) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 1)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 1), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 1) + 1, 1)||'2' END
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 3)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 3), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 3) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 3)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 3), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 3) + 1, 1)||'2' END
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 5)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 5), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 5) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 5)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 5), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 5) + 1, 1)||'2' END
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 7)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 7), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 7) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 7)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 7), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 7) + 1, 1)||'2' END
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 9)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 9), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 9) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J', 9)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 9), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J', 9) + 1, 1)||'2' END
- ||CASE WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J',11)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J',11), 2)) IN ('JR','JL') THEN SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J',11) + 1, 1)||'1' WHEN DECODE(SIGN(INSTRB(A.PATH_PROC_CD, 'J',11)),1,SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J',11), 2)) IS NULL THEN NULL ELSE SUBSTRB(A.PATH_PROC_CD,INSTRB(A.PATH_PROC_CD, 'J',11) + 1, 1)||'2' END
- ELSE '0'
- END AS LANE_PROC_CD
- , NVL(A.MAT_THK ,0) AS MAT_THK
- , NVL(A.MAT_WTH ,0) AS MAT_WTH
- , NVL(A.SUM_FL_1_CNT,0) AS SUM_FL_1_CNT
- , NVL(A.SUM_FL_2_CNT,0) AS SUM_FL_2_CNT
- , DECODE(SIGN(NVL(A.SUM_FL_2_CNT,0)), 1,'Y','N') AS NONORD_CHARGE_FL
- , NVL(A.SUM_FL_1_CNT,0) + NVL(A.SUM_FL_2_CNT,0) AS SLAB_CNT
- , A.SUM_MAT_WGT
- , A.HCR_YN
- , A.HCR_YN AS HCR_CLF
- , NVL(A.EMGMTR_YN,'N') AS EMGMTR_NMG_CLF
- , 0 /*NVL(D.BOF_TGT_TEMP,0)*/ AS BOF_TEMP_TGT
- , 0 /*NVL(D.CAS_TGT_TEMP,0)*/ AS CAS_TEMP_TGT
- , 0 /*NVL(D.RH_TGT_TEMP ,0)*/ AS RH_TEMP_TGT
- , 0 /*NVL(D.LF_TGT_TEMP ,0)*/ AS LF_TEMP_TGT
- , 0 /*NVL(D.TD_TEMP_AVG ,0)*/ AS TD_TEMP_AVG
- , 0 /*NVL(D.TD_TEMP_MIN ,0)*/ AS TD_TEMP_MIN
- , 0 /*NVL(D.TD_TEMP_MAX ,0)*/ AS TD_TEMP_MAX
- , 0 /*NVL(D.SOLIDE_TEMP1,0)*/ AS SOLIDE_TEMP_TGT1
- , 0 /*NVL(D.SOLIDE_TEMP2,0)*/ AS SOLIDE_TEMP_TGT2
- , A.LANE_CD
- FROM (SELECT X.*
- -- , CASE X.MAT_RT WHEN 'P' THEN '2'
- -- WHEN 'H' THEN DECODE(X.HCR_YN,'Y','1','2')
- -- ELSE '0'
- -- END AS LANE_CD
- ,'1' AS LANE_CD
- , SUM(DECODE(X.ORD_FL,'1',1)) OVER (PARTITION BY X.PMAT_SPEC_SEQ) AS SUM_FL_1_CNT
- , SUM(DECODE(X.ORD_FL,'2',1)) OVER (PARTITION BY X.PMAT_SPEC_SEQ) AS SUM_FL_2_CNT
- , SUM(NVL(X.MAT_WGT,0) ) OVER (PARTITION BY X.PMAT_SPEC_SEQ) AS SUM_MAT_WGT
- , ROW_NUMBER() OVER (PARTITION BY X.PMAT_SPEC_SEQ ORDER BY X.ORD_FL, X.WITHIN_SUB_SEQ) AS RN
- FROM TBD01_MATDN_RST3 X
- WHERE X.MAT_TP = '03'
- START WITH X.MAT_SPEC_SEQ = :1
- CONNECT BY PRIOR X.MAT_SPEC_SEQ = X.PMAT_SPEC_SEQ) A
- /*, TBE02_ORD_PRC C */
- /*, TBG01_OPRN_STD D*/
- WHERE A.RN = 1
- /*AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND C.STL_GRD = D.STL_GRD(+)*/) Y
- ,(SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'F01004') Z
- WHERE X.MAT_SPEC_SEQ = Y.PMAT_SPEC_SEQ(+)
- AND Y.LANE_PROC_CD = Z.SM_CFNM(+)
- AND X.MAT_TP||'' = '02'
- AND X.PMAT_SPEC_SEQ = :2
- ORDER BY X.WITHIN_SUB_SEQ
- ]]>
- </query>
- <query id="NID040010.ChargeSpec.LaneMaxSeq.Select" desc="">
- <![CDATA[
- SELECT '3'||SUBSTRB(TO_CHAR(SYSDATE,'YY'),2) AS PRE_FIX
- , NVL(MAX(DECODE(X.LANE,'1',X.N_SEQ)),0) AS MX_LANE1_SEQ
- , NVL(MAX(DECODE(X.LANE,'2',X.N_SEQ)),0) AS MX_LANE2_SEQ
- FROM (SELECT ROW_NUMBER() OVER (PARTITION BY LANE ORDER BY N_SEQ DESC) AS RN
- , X.N_SEQ, X.LANE
- FROM (SELECT TO_NUMBER(SUBSTRB(CHARGE_MANA_NO,5,5)) AS N_SEQ
- , SUBSTRB(CHARGE_MANA_NO,3,1) AS LANE
- FROM TBF01_SPEC_CHARGE
- WHERE CHARGE_MANA_NO LIKE '3'||SUBSTRB(TO_CHAR(SYSDATE,'YY'),2)||'_-%') X
- WHERE 1 = 1) X
- WHERE X.RN = 1
- ]]>
- </query>
- <query id="NID040010.ChargeSpec.MaxPK.Select" desc="">
- <![CDATA[
- SELECT NVL(MAX(CHARGE_EDT_SEQ),0) AS MX_CHARGE_EDT_SEQ
- FROM TBF01_SPEC_CHARGE
- ]]>
- </query>
- <query id="NID040010.SlabSpec.MaxPK.Select" desc="">
- <![CDATA[
- SELECT NVL(MAX(SLAB_EDT_SEQ),0) AS MX_SLAB_EDT_SEQ
- FROM TBF01_SPEC_SLAB
- ]]>
- </query>
- <query id="NID040010.SlabSpec.All.Insert" desc="">
- <![CDATA[
- INSERT INTO TBF01_SPEC_SLAB( SLAB_EDT_SEQ, SLAB_MANA_NO
- , CAST_EDT_SEQ, CAST_MANA_NO
- , CHARGE_EDT_SEQ, CHARGE_MANA_NO, CHARGE_SLAB_SEQ
- , PRODNM_CD
- , STL_GRD, STL_GRP_CD
- , SLAB_RT
- , SLAB_THK, SLAB_WTH, SLAB_LEN, SLAB_LEN_MIN, SLAB_LEN_MAX
- , SLAB_WTH_TOP, SLAB_WTH_BOT, SLAB_WGT
- , CCM_CUT_PRE_TME, CCM_CUT_TME
- , HCR_CLF, EMGMTR_NMG_CLF, OVER_ROLL_YN
- , SAMPLE_CUT, SLAB_CUT_CNT
- , ORD_FL
- , ORD_NO, ORD_SEQ, ORD_THK, ORD_WTH, ORD_LEN, ORD_WGT
- , COIL_INDIA, COIL_OUTDIA
- , ORD_WGT_MIN, ORD_WGT_MAX
- , PACK_METHOD
- , DELV_REQ_DATE
- , ORD_USEAGE_CD
- , CUST_CD, ORDCUST_CD, SPEC_ABBSYM
- , SPM_PROC_YN, SCARPING_PROC_YN, KEEPWARM_YN
- , STATUS_CD, MILL_FL, MILL_SLAB_EDT_SEQ
- , REG_DTIME, REG_ID, MOD_DTIME, MOD_ID
- , DSN_SLAB_NO)
- SELECT --A.MAT_SPEC_SEQ, A.PMAT_SPEC_SEQ,
- P.SLAB_EDT_SEQ + ROW_NUMBER() OVER (ORDER BY A.WITHIN_SUB_SEQ) AS SLAB_EDT_SEQ
- , P.CHARGE_MANA_NO||TO_CHAR(A.WITHIN_SUB_SEQ*10,'FM000') AS SLAB_MANA_NO
- , TO_NUMBER(P.CAST_EDT_SEQ) AS CAST_EDT_SEQ
- , P.CAST_MANA_NO
- , TO_NUMBER(P.CHARGE_EDT_SEQ) AS CHARGE_EDT_SEQ
- , P.CHARGE_MANA_NO
- , A.WITHIN_SUB_SEQ
- ,'AR' AS PRODNM_CD /*B.PRODNM_CD */
- , A.FAC_STL_GRD
- , A.FAC_STL_GRP
- , A.MAT_RT
- , NVL(A.MAT_THK, 0) AS MAT_THK
- , NVL(A.MAT_WTH, 0) AS MAT_WTH
- , NVL(A.MAT_LEN, 0) AS MAT_LEN
- , NVL(A.MAT_LEN_MIN,0) AS MAT_LEN_MIN
- , NVL(A.MAT_LEN_MAX,0) AS MAT_LEN_MAX
- , 0 AS SLAB_WTH_TOP
- , 0 AS SLAB_WTH_BOT
- , NVL(A.MAT_WGT, 0) AS MAT_WGT
- , NULL AS CCM_CUT_PRE_TME
- , CEIL(NVL(C.CCM_TIME,2) * NVL(A.MAT_WTH,0) / 1000) AS CCM_CUT_TME
- , NVL(A.HCR_YN,'C') AS HCR_CLF
- , NVL(A.EMGMTR_YN,'N') AS EMGMTR_YN
- , A.OVER_ROLL_YN
- , A.SAMPLE_CUT
- , DECODE(NVL(A.CMAT_CNT,0),0,1,A.CMAT_CNT) AS CMAT_CNT
- , A.ORD_FL
- , A.ORD_NO
- , A.ORD_SEQ
- , 0 /*NVL(B.ORD_THK ,0)*/ AS ORD_THK
- , 0 /*NVL(B.ORD_WTH ,0)*/ AS ORD_WTH
- , NVL(A.COIL_LEN ,0) AS ORD_LEN
- , NVL(A.COIL_WGT ,0) AS ORD_WGT
- , 0 /*NVL(A.COIL_INDIA ,0)*/ AS COIL_INDIA
- , 0 /*NVL(A.COIL_OUTDIA ,0)*/ AS COIL_OUTDIA
- , 0 /*NVL(B.ORD_UNIT_WGT_MIN,0)*/ AS ORD_WGT_MIN
- , 0 /*NVL(B.ORD_UNIT_WGT_MAX,0)*/ AS ORD_WGT_MAX
- , '*' AS PACK_METHOD /*B.PACK_METHOD */
- , '*' AS DEL_TO_DATE /*B.DEL_TO_DATE */ -- AS DELV_REQ_DATE --A.DELV_REQ_DATE
- , '*' AS ORD_USEAGE_CD /*B.ORD_USEAGE_CD */
- , '*' AS CUST_CD /*B.CUST_CD */
- , '*' AS ORDCUST_CD /*B.ORDCUST_CD */
- , 'SPEC_ABBSYM' AS SPEC_ABBSYM /*B.SPEC_ABBSYM */
- , NVL(A.SPM_PROC_YN,'N') AS SPM_PROC_YN
- , NVL(A.SCARPING_PROC_YN,'N') AS SCARPING_PROC_YN
- , 'N' /*NVL(B.KEEPWARM_YN,'N') */ AS KEEPWARM_YN
- ,'A' AS STATUS_CD
- ,'N' AS MILL_FL
- , 0 AS MILL_SLAB_EDT_SEQ
- , P.REG_DTIME
- , P.REG_ID
- , P.REG_DTIME AS MOD_DTIME
- , P.REG_ID AS MOD_ID
- , A.DSN_SLAB_NO AS DSN_SLAB_NO
- FROM TBD01_MATDN_RST3 A /*, TBE02_ORD_PRC B */
- ,(SELECT *
- FROM TBF01_CCM_TIME
- WHERE PROC_LINE = :1
- AND STL_GRP_CD = :2) C --TBA01_ORD_COMM B, TBA01_ORD_LINE C
- ,(SELECT :3 AS SLAB_EDT_SEQ
- , :4 AS CAST_EDT_SEQ
- , :5 AS CAST_MANA_NO
- , :6 AS CHARGE_EDT_SEQ
- , :7 AS CHARGE_MANA_NO
- , :8 AS REG_DTIME
- , :9 AS REG_ID
- , :10 AS CHARGE_NO
- FROM DUAL) P
- WHERE 1 = 1
- /*AND A.ORD_NO = B.ORD_NO(+) AND A.ORD_SEQ = B.ORD_SEQ(+)*/
- AND A.MAT_TP||'' = '03'
- AND A.PMAT_SPEC_SEQ = P.CHARGE_NO
- AND A.MAT_THK = C.SLAB_THK(+)
- AND A.MAT_WTH >= C.SLAB_WTH_MIN(+) AND A.MAT_WTH < C.SLAB_WTH_MAX(+)
- ]]>
- </query>
- <query id="NID040010.SlabDetailSpec.All.Insert" desc="Testing...">
- <![CDATA[
- INSERT INTO TBF01_SPEC_SLAB_D( SLAB_EDT_SEQ
- , SLAB_CUT_SEQ
- , SLAB_THK, SLAB_WTH, SLAB_LEN, SLAB_WGT
- , ORD_THK, ORD_WTH
- , ORD_LEN, ORD_WGT
- , COIL_INDIA, COIL_OUTDIA
- , ORD_NO, ORD_SEQ, ORD_FL
- , STATUS_CD )
- SELECT X.SLAB_EDT_SEQ + SUM(DECODE(X.SLAB_CUT_SEQ_NUMBER,1,1,0)) OVER (ORDER BY X.RN)
- , TO_CHAR(X.SLAB_CUT_SEQ_NUMBER,'FM00') AS SLAB_CUT_SEQ
- , X.MAT_THK, X.MAT_WTH, X.MAT_LEN, X.MAT_WGT
- , X.ORD_THK, X.ORD_WTH
- , X.COIL_LEN, X.COIL_WGT
- , X.COIL_INDIA, X.COIL_OUTDIA
- , X.ORD_NO, X.ORD_SEQ, X.ORD_FL
- , X.STATUS_CD
- FROM (SELECT P.SLAB_EDT_SEQ
- , DECODE(A.MAT_TP,'03',1,A.WITHIN_SUB_SEQ) AS SLAB_CUT_SEQ_NUMBER
- , NVL(A.MAT_THK ,0) AS MAT_THK
- , NVL(A.MAT_WTH ,0) AS MAT_WTH
- , NVL(A.MAT_LEN ,0) AS MAT_LEN
- , NVL(A.MAT_WGT ,0) AS MAT_WGT
- , 0 /*NVL(B.ORD_THK ,0)*/ AS ORD_THK
- , 0 /*NVL(B.ORD_WTH ,0)*/ AS ORD_WTH
- , NVL(A.COIL_LEN ,0) AS COIL_LEN
- , NVL(A.COIL_WGT ,0) AS COIL_WGT
- , 0 /*NVL(A.COIL_INDIA ,0)*/ AS COIL_INDIA
- , 0 /*NVL(A.COIL_OUTDIA,0)*/ AS COIL_OUTDIA
- , A.ORD_NO
- , A.ORD_SEQ
- , A.ORD_FL
- ,'A' AS STATUS_CD
- , A.MAT_TP
- , A.WITHIN_SUB_SEQ
- , ROWNUM AS RN
- FROM TBD01_MATDN_RST3 A/*, TBA01_ORD_LINE B*/
- ,(SELECT :1 AS SLAB_EDT_SEQ
- , :2 AS CHARGE_NO
- FROM DUAL) P
- WHERE 1 = 1
- -- AND A.ORD_NO = B.ORD_NO(+)
- -- AND A.ORD_SEQ = B.ORD_SEQ(+)
- AND NVL(A.CMAT_CNT,0) = 0
- START WITH A.PMAT_SPEC_SEQ = P.CHARGE_NO AND A.MAT_TP = '03'
- CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
- ORDER SIBLINGS BY A.PMAT_SPEC_SEQ, A.WITHIN_SUB_SEQ) X
- ORDER BY X.RN
- ]]>
- </query>
-
- <query id="Oracle9.Only.NID040010.SlabDetailSpec.All.Insert" desc="Testing...">
- <![CDATA[
- INSERT INTO TBF01_SPEC_SLAB_D( SLAB_EDT_SEQ
- , SLAB_CUT_SEQ
- , SLAB_THK, SLAB_WTH, SLAB_LEN, SLAB_WGT
- , ORD_THK, ORD_WTH
- , ORD_LEN, ORD_WGT
- , COIL_INDIA, COIL_OUTDIA
- , ORD_NO, ORD_SEQ, ORD_FL
- , STATUS_CD )
- SELECT P.SLAB_EDT_SEQ + SUM(DECODE(DECODE(A.MAT_TP,'03',1,A.WITHIN_SUB_SEQ),1,1,0)) OVER (ORDER BY ROWNUM)
- , TO_CHAR(DECODE(A.MAT_TP,'03',1,A.WITHIN_SUB_SEQ),'FM00') AS SLAB_CUT_SEQ
- , NVL(A.MAT_THK,0), NVL(A.MAT_WTH,0), NVL(A.MAT_LEN,0), NVL(A.MAT_WGT,0)
- , 0, 0 /*NVL(B.ORD_THK,0), NVL(B.ORD_WTH,0) */
- , NVL(A.COIL_LEN,0), NVL(A.COIL_WGT,0)
- , 0, 0 /*NVL(A.COIL_INDIA,0), NVL(A.COIL_OUTDIA,0) */
- , A.ORD_NO, A.ORD_SEQ, A.ORD_FL
- ,'A' AS STATUS_CD
- FROM TBD01_MATDN_RST3 A/*, TBA01_ORD_LINE B*/
- ,(SELECT :1 AS SLAB_EDT_SEQ
- , :2 AS CHARGE_NO
- FROM DUAL) P
- WHERE 1 = 1
- /*AND A.ORD_NO = B.ORD_NO(+)
- AND A.ORD_SEQ = B.ORD_SEQ(+)*/
- AND NVL(A.CMAT_CNT,0) = 0
- START WITH A.PMAT_SPEC_SEQ = P.CHARGE_NO AND A.MAT_TP = '03'
- CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
- ORDER SIBLINGS BY A.PMAT_SPEC_SEQ, A.WITHIN_SUB_SEQ
- ]]>
- </query>
- <query id="NID040010.ChargeSpec.Row.Insert" desc="">
- <![CDATA[
- INSERT INTO TBF01_SPEC_CHARGE(CHARGE_EDT_SEQ
- , CHARGE_MANA_NO
- , CAST_EDT_SEQ
- , CAST_MANA_NO
- , CAST_CHARGE_SEQ
- , CAST_EDT_CHARGE_CNT
- , PRODNM_CD
- , STL_GRD
- , STL_GRP_CD
- , CHARGE_RT
- , SPEC_ABBSYM
- , TREAT_RT_CD
- , PATH_PROC_CD
- , PATH_MILL_CD
- , LINE_PROC_CD
- , CCM_THK
- , CCM_WTH
- , CCM_TME
- , WID_CHG_FL
- , ORD_SLAB_CNT
- , NONORD_SLAB_CNT
- , NONORD_CHARGE_FL
- , SLAB_CNT
- , PREV_CHARGE_WGT
- , HCR_CLF
- , EMGMTR_NMG_CLF
- , SMS_DUEDATE
- , PRC_LINE
- , CCM_PRC_LINE
- , TD_NO
- , MD_NO1
- , MD_NO2
- , TD_USE_CNT
- , MD_USE_CNT1
- , MD_USE_CNT2
- , BOF_TEMP_TGT
- , CAS_TEMP_TGT
- , RH_TEMP_TGT
- , LF_TEMP_TGT
- , TD_TEMP_AVG
- , TD_TEMP_MIN
- , TD_TEMP_MAX
- , SOLIDE_TEMP_TGT1
- , SOLIDE_TEMP_TGT2
- , CC_SPEED_AVG1
- , CC_SPEED_MIN1
- , CC_SPEED_MAX1
- , CC_SPEED_AVG2
- , CC_SPEED_MIN2
- , CC_SPEED_MAX2
- , HM_STR_DTIME
- , BLOW_STR_DTIME
- , PRE_BOF_STR_DTIME
- , PRE_BOF_END_DTIME
- , PRE_CAS_STR_DTIME
- , PRE_CAS_END_DTIME
- , PRE_RH_STR_DTIME
- , PRE_RH_END_DTIME
- , PRE_LF_STR_DTIME
- , PRE_LF_END_DTIME
- , PRE_CCM_STR_DTIME
- , PRE_CCM_END_DTIME
- , PROG_CD
- , STATUS_CD
- , MILL_FL
- , FL
- , RESCH_CAUSE_CD, RESCH_DTIME, RESCH_ID
- , REG_DTIME, REG_ID, MOD_DTIME, MOD_ID )
- VALUES( ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?, ?, ?
- , ?, ?, ?, ?)
- ]]>
- </query>
- <query id="NID040010.ChargeIdx.Row.Insert" desc="">
- <![CDATA[
- INSERT INTO TBF01_CHARGE_IDX( ORG_SEQ
- , CHG_SEQ
- , CHARGE_EDT_SEQ
- , CHARGE_MANA_NO
- , CHG_CHARGE_MANA_NO
- , STATUS_CD
- , HCR_CLF
- , REG_DTIME
- , L2_SEND
- , PRC_LINE, CCM_PRC_LINE )
- VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
- ]]>
- </query>
- </queryMap>
|
