| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020060_CHARGE_INFO.select" desc="炉次信息查询">
- <![CDATA[
- SELECT
- A.PLAN_CHARGE_NO
- ,A.STL_GRD
- ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
- ,A.CC_DEVNO
- ,A.LD_NO
- ,A.LT_ARRV_DTIME
- ,A.RCPT_TAP_QTY
- ,'' CUT_WKSHIFT
- ,'' CUT_WKGROUP
- ,'' CUT_EMP_ID
- FROM TBG02_CHARGE_COMM A
- WHERE CHARGE_NO = :1
- ]]>
- </query>
- <query id="UIG020060_01.select" desc="板坯切割实绩查询">
- <![CDATA[
-
-
- SELECT
- '' CHK
- ,A.PLAN_CHARGE_NO
- ,A.STL_GRD
- ,A.CAST_SEQ
- ,A.CC_DEVNO
- ,A.LD_NO
- ,A.LT_ARRV_DTIME
- ,A.RCPT_TAP_QTY
- ,B.CUT_WKSHIFT
- ,B.PLAN_SLAB_NO
- ,B.CUT_WKGROUP
- ,B.SLAB_NO_SEQ SLAB_NO
- ,B.SLAB_THK
- ,B.SLAB_WTH
- ,B.SLAB_LEN
- ,B.SLAB_WGT
- ,B.SLAB_TEMP
- ,B.HCR_CLF
- ,B.SLAB_RT
- ,B.SLAB_CUT_DTIME
- ,B.ORD_FL
- ,B.LAST_SLAB_YN
- ,B.DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- ,SLAB_INGR_DEC_GRD
- ,SLAB_SIZE_DEC_GRD
- -- ,DIFF_STL_GRD_STA_END_YN
- FROM
- (
- SELECT
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
- ,CC_DEVNO
- ,LD_NO
- ,LT_ARRV_DTIME
- ,RCPT_TAP_QTY
-
- FROM TBG02_CHARGE_COMM
- WHERE CHARGE_NO = ?
- ) A ,
- (
- SELECT
- CUT_WKSHIFT
- ,SLAB_NO
- ,PLAN_SLAB_NO
- ,CUT_WKGROUP
- ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ
- ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
- ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
- ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN
- ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
- ,SLAB_TEMP
- ,HCR_CLF
- ,SLAB_RT
- ,SLAB_CUT_DTIME
- ,ORD_FL
- ,LAST_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- ,DECODE(DIFF_STL_GRD_STA_END_YN,'2','Y','N') DIFF_STL_GRD_STA_END_YN
- ,SLAB_INGR_DEC_GRD
- ,SLAB_SIZE_DEC_GRD
- FROM TBG02_SLAB_COMM
- WHERE SLAB_NO LIKE ?||'%'
- ) B
- WHERE B.SLAB_NO(+) LIKE A.CHARGE_NO||'%'
- ORDER BY PLAN_SLAB_NO ASC
- ]]>
- </query>
-
- <query id="UIG020060_SLAB1.select" desc="板坯切割实绩查询">
- <![CDATA[
- SELECT B.SLAB_NO,
- b.CUT_WKSHIFT,
- b.PLAN_SLAB_NO,
- b.CUT_WKGROUP,
- b.SLAB_NO_SEQ SLAB_NO,
- b.SLAB_THK,
- b.SLAB_WTH,
- b.SLAB_LEN,
- b.SLAB_WGT,
- b.SLAB_TEMP,
- b.HCR_CLF,
- b.SLAB_RT,
- b.SLAB_CUT_DTIME,
- b.ORD_FL,
- b.LAST_SLAB_YN,
- b.DIFF_STL_GRD_STA_END_YN,
- SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM (SELECT CUT_WKSHIFT,
- SLAB_NO,
- PLAN_SLAB_NO,
- SUB_SLAB_NO,
- CUT_WKGROUP,
- SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
- DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
- DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
- DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
- DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
- SLAB_TEMP,
- HCR_CLF,
- SLAB_RT,
- SLAB_CUT_DTIME,
- ORD_FL,
- LAST_SLAB_YN,
- DIFF_STL_GRD_STA_END_YN,
- SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,
- TW_SLAB_YN
- FROM tbg02_slab_comm
- WHERE STRAND_NO = '1'
- AND SUB_SLAB_NO like :1|| '%'
- AND slab_stat <> '1') b
- ORDER BY B.SLAB_NO
-
- ]]>
- </query>
-
- <query id="UIG020060_SLAB1.select_BAK" desc="板坯切割实绩查询">
- <![CDATA[
-
- SELECT
- a.PLAN_CHARGE_NO
- ,B.SLAB_NO
- ,a.STL_GRD
- ,a.CAST_SEQ
- ,a.CC_DEVNO
- ,a.LD_NO
- ,a.LT_ARRV_DTIME
- ,a.RCPT_TAP_QTY
- ,b.CUT_WKSHIFT
- ,b.PLAN_SLAB_NO
- ,b.CUT_WKGROUP
- ,b.SLAB_NO_SEQ SLAB_NO
- ,b.SLAB_THK
- ,b.SLAB_WTH
- ,b.SLAB_LEN
- ,b.SLAB_WGT
- ,b.SLAB_TEMP
- ,b.HCR_CLF
- ,b.SLAB_RT
- ,b.SLAB_CUT_DTIME
- ,b.ORD_FL
- ,b.LAST_SLAB_YN
- ,b.DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM
- (
- SELECT
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
- ,CC_DEVNO
- ,LD_NO
- ,LT_ARRV_DTIME
- ,RCPT_TAP_QTY
-
- FROM TBG02_CHARGE_COMM
- where CHARGE_NO = ?
- ) a ,
- (
- SELECT
- CUT_WKSHIFT
- ,SLAB_NO
- ,PLAN_SLAB_NO
- ,SUB_SLAB_NO
- ,CUT_WKGROUP
- ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ
- ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
- ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
- ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN
- ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
- ,SLAB_TEMP
- ,HCR_CLF
- ,SLAB_RT
- ,SLAB_CUT_DTIME
- ,ORD_FL
- ,LAST_SLAB_YN
- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM tbg02_slab_comm
- WHERE STRAND_NO = '1'
- AND SUB_SLAB_NO like ?||'%'
- AND slab_stat <> '1'
- ) b
- WHERE b.SUB_SLAB_NO(+) like a.CHARGE_NO||'%'
- ORDER BY B.SLAB_NO
-
- ]]>
- </query>
-
- <query id="UIG020060_SLAB2.select" desc="板坯切割实绩查询">
- <![CDATA[
- SELECT B.SLAB_NO,
- b.CUT_WKSHIFT,
- b.PLAN_SLAB_NO,
- b.CUT_WKGROUP,
- b.SLAB_NO_SEQ SLAB_NO,
- b.SLAB_THK,
- b.SLAB_WTH,
- b.SLAB_LEN,
- b.SLAB_WGT,
- b.SLAB_TEMP,
- b.HCR_CLF,
- b.SLAB_RT,
- b.SLAB_CUT_DTIME,
- b.ORD_FL,
- b.LAST_SLAB_YN,
- b.DIFF_STL_GRD_STA_END_YN,
- SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM (SELECT CUT_WKSHIFT,
- SLAB_NO,
- PLAN_SLAB_NO,
- SUB_SLAB_NO,
- CUT_WKGROUP,
- SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
- DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
- DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
- DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
- DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
- SLAB_TEMP,
- HCR_CLF,
- SLAB_RT,
- SLAB_CUT_DTIME,
- ORD_FL,
- LAST_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- STRAND_NO,
- DIFF_STL_GRD_STA_END_YN,
- TW_SLAB_YN
- FROM tbg02_slab_comm
- WHERE STRAND_NO = '2'
- AND SUB_SLAB_NO like :1|| '%'
- AND slab_stat <> '1') b
- ORDER BY B.SLAB_NO
-
- ]]>
- </query>
-
- <query id="UIG020060_SLAB2.select_BAK" desc="板坯切割实绩查询">
- <![CDATA[
-
- SELECT
- a.PLAN_CHARGE_NO
- ,B.SLAB_NO
- ,a.STL_GRD
- ,a.CAST_SEQ
- ,a.CC_DEVNO
- ,a.LD_NO
- ,a.LT_ARRV_DTIME
- ,a.RCPT_TAP_QTY
- ,b.CUT_WKSHIFT
- ,b.PLAN_SLAB_NO
- ,b.CUT_WKGROUP
- ,b.SLAB_NO_SEQ SLAB_NO
- ,b.SLAB_THK
- ,b.SLAB_WTH
- ,b.SLAB_LEN
- ,b.SLAB_WGT
- ,b.SLAB_TEMP
- ,b.HCR_CLF
- ,b.SLAB_RT
- ,b.SLAB_CUT_DTIME
- ,b.ORD_FL
- ,b.LAST_SLAB_YN
- ,b.DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- -- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM
- (
- SELECT
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
- ,CC_DEVNO
- ,LD_NO
- ,LT_ARRV_DTIME
- ,RCPT_TAP_QTY
-
- FROM TBG02_CHARGE_COMM
- where CHARGE_NO = ?
- ) a ,
- (
- SELECT
- CUT_WKSHIFT
- ,SLAB_NO
- ,PLAN_SLAB_NO
- ,SUB_SLAB_NO
- ,CUT_WKGROUP
- ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ
- ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
- ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
- ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN
- ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
- ,SLAB_TEMP
- ,HCR_CLF
- ,SLAB_RT
- ,SLAB_CUT_DTIME
- ,ORD_FL
- ,LAST_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- ,DIFF_STL_GRD_STA_END_YN
- ,TW_SLAB_YN
- FROM tbg02_slab_comm
- WHERE STRAND_NO = '2'
- AND SUB_SLAB_NO like ?||'%'
- AND slab_stat <> '1'
- ) b
- WHERE b.SUB_SLAB_NO(+) like a.CHARGE_NO||'%'
- ORDER BY B.SLAB_NO
-
- ]]>
- </query>
-
- <query id="UIG020060_SLAB0.select" desc="板坯切割实绩查询">
- <![CDATA[
- SELECT '' CHK
-
- ,
- B.CUT_WKSHIFT,
- B.PLAN_SLAB_NO,
- B.CUT_WKGROUP,
- B.SLAB_NO_SEQ SLAB_NO,
- B.SLAB_NO_SEQ2 SUB_SLAB_NO,
- B.SLAB_THK,
- B.SLAB_WTH,
- B.SLAB_LEN,
- B.SLAB_WGT,
- B.SLAB_TEMP,
- B.HCR_CLF,
- B.SLAB_RT,
- B.SLAB_CUT_DTIME,
- B.ORD_FL,
- B.LAST_SLAB_YN,
- B.DIFF_STL_GRD_STA_END_YN,
- SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- decode(STRAND_NO, 1, 'Y', 'N') STRAND_NO1,
- decode(STRAND_NO, 2, 'Y', 'N') STRAND_NO2,
- TW_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,
- SLAB_INGR_DEC_GRD,
- SLAB_SIZE_DEC_GRD,
- C.MILL_FL,
- C.ORD_NO || '-' || C.ORD_SEQ INS_ORD_NO,
- C.SLAB_THK || '*' || C.SLAB_WTH || '*' || C.SLAB_LEN INS_SLAB_SIZE
- FROM (SELECT CUT_WKSHIFT,
- SLAB_NO,
- SUB_SLAB_NO,
- PLAN_SLAB_NO,
- CUT_WKGROUP,
- SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
- SUBSTR(SUB_SLAB_NO, 11, 12) SLAB_NO_SEQ2,
- DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
- DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
- DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
- DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
- SLAB_TEMP,
- HCR_CLF,
- SLAB_RT,
- SLAB_CUT_DTIME,
- ORD_FL,
- LAST_SLAB_YN,
- TW_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,
- SLAB_STAT,
- CUT_EMP_ID,
- SURPLMATL_YN,
- STRAND_NO,
- DECODE(DIFF_STL_GRD_STA_END_YN, '2', 'Y', 'N') DIFF_STL_GRD_STA_END_YN,
- SLAB_INGR_DEC_GRD,
- SLAB_SIZE_DEC_GRD
- FROM TBG02_SLAB_COMM
- WHERE SUB_SLAB_NO LIKE :1|| '%') B,
- TBF01_SPEC_SLAB C
- WHERE '1' = '1'
- AND B.PLAN_SLAB_NO = C.SLAB_MANA_NO
- ORDER BY SUB_SLAB_NO
- ]]>
- </query>
- <query id="UIG020060_SLAB0.select_BAK" desc="板坯切割实绩查询">
- <![CDATA[
- SELECT
- '' CHK
- ,A.PLAN_CHARGE_NO
- ,A.STL_GRD
- ,A.CAST_SEQ
- ,A.CC_DEVNO
- ,A.LD_NO
- ,A.LT_ARRV_DTIME
- ,A.RCPT_TAP_QTY
- ,B.CUT_WKSHIFT
- ,B.PLAN_SLAB_NO
- ,B.CUT_WKGROUP
- ,B.SLAB_NO_SEQ SLAB_NO
- ,B.SLAB_NO_SEQ2 SUB_SLAB_NO
- ,B.SLAB_THK
- ,B.SLAB_WTH
- ,B.SLAB_LEN
- ,B.SLAB_WGT
- ,B.SLAB_TEMP
- ,B.HCR_CLF
- ,B.SLAB_RT
- ,B.SLAB_CUT_DTIME
- ,B.ORD_FL
- ,B.LAST_SLAB_YN
- ,B.DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,decode(STRAND_NO,1,'Y','N') STRAND_NO1
- ,decode(STRAND_NO,2,'Y','N') STRAND_NO2
- ,TW_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_INGR_DEC_GRD
- ,SLAB_SIZE_DEC_GRD
- ,C.MILL_FL
- ,C.ORD_NO||'-'||C.ORD_SEQ INS_ORD_NO
- ,C.SLAB_THK||'*'||C.SLAB_WTH||'*'||C.SLAB_LEN INS_SLAB_SIZE
- FROM
- (
- SELECT
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
- ,CC_DEVNO
- ,LD_NO
- ,LT_ARRV_DTIME
- ,RCPT_TAP_QTY
-
- FROM TBG02_CHARGE_COMM
- WHERE CHARGE_NO = ?
- ) A ,
- (
- SELECT
- CUT_WKSHIFT
- ,SLAB_NO
- ,SUB_SLAB_NO
- ,PLAN_SLAB_NO
- ,CUT_WKGROUP
- ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ
- ,SUBSTR(SUB_SLAB_NO,11,12) SLAB_NO_SEQ2
- ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
- ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
- ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN
- ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
- ,SLAB_TEMP
- ,HCR_CLF
- ,SLAB_RT
- ,SLAB_CUT_DTIME
- ,ORD_FL
- ,LAST_SLAB_YN
- ,TW_SLAB_YN
- -- ,DIFF_STL_GRD_STA_END_YN
- ,SLAB_STAT
- ,CUT_EMP_ID
- ,SURPLMATL_YN
- ,STRAND_NO
- ,DECODE(DIFF_STL_GRD_STA_END_YN,'2','Y','N') DIFF_STL_GRD_STA_END_YN
- ,SLAB_INGR_DEC_GRD
- ,SLAB_SIZE_DEC_GRD
- FROM TBG02_SLAB_COMM
- WHERE SUB_SLAB_NO LIKE ?||'%'
- ) B,
- TBF01_SPEC_SLAB C
- WHERE B.SUB_SLAB_NO(+) LIKE A.CHARGE_NO||'%'
- AND B.PLAN_SLAB_NO = C.SLAB_MANA_NO
- ORDER BY SUB_SLAB_NO
- ]]>
- </query>
-
- <query id="UIG020060_02.select" desc="板坯切割实绩查询">
- <![CDATA[
-
- SELECT PLAN_CHARGE_NO,STL_GRD
- FROM TBG02_CHARGE_COMM
- WHERE CHARGE_NO = ?
-
- ]]>
- </query>
- <query id="UIG020060_01.update" desc="This step query is update query to TBG03_STLMAKE_PROG ">
- <![CDATA[
- update TBG02_SLAB_COMM set(
- SLAB_STAT
- ,STL_GRD
- ,CUR_PROG_CD
- ,CUR_PROG_CD_PGM
- ,CUR_PROG_CD_DTIME
- ,BEF_PROG_CD
- ,BEF_PROG_CD_PGM
- ,BEF_PROG_CD_DTIME
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_FL
- ,PRODNM_CD
- ,INSTR_SLAB_THK
- ,INSTR_SLAB_WTH
- ,INSTR_SLAB_LEN
- ,INSTR_SLAB_WGT
- ,INSTR_COIL_THK
- ,INSTR_COIL_WTH
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,SLAB_WGT
- ,HCR_CLF
- ,SLAB_WAY
- ,SLAB_RT
- ,LAST_SLAB_YN
- ,SLAB_CUT_DTIME
- ,CUT_WKSHIFT
- ,CUT_WKGROUP
- ,CUT_EMP_ID
- ,CUST_CD
- ,ORD_USE_CD
- ,SPEC_ABBSYM
- ,ORDCUST_CD
- ,SIZE_UPDT_BEF_THK
- ,SIZE_UPDT_BEF_WTH
- ,SIZE_UPDT_BEF_LEN
- ,SIZE_UPDT_BEF_WGT
- ,SURPLMATL_YN
- ,ORG_ORD_NO
- ,ORG_ORD_SEQ
- ,CUR_LOAD_LOC
- ,MILL_SCH_STAT
- ,SLAB_SIZE_DEC_GRD
- ,DIFF_STL_GRD_STA_END_YN
- ,CAST_NO
- ,CUR_LOAD_LOC_DTIME
- ,PROC_CD
- ,STRAND_NO
- /*,EXTSHAPE_GRD*/
- ,NONORD_CAUSE_CD
- ,NONORD_OCR_DTIME
- ,MATRL_END_DTIME
- ,MATRL_END_CAUSE_CD
- ,TW_SLAB_YN
- ,DSN_SLAB_NO
- ,LG_STL_GRD
- )=(SELECT '2' SLAB_STAT
- ,a.STL_GRD
- ,? CUR_PROG_CD
- ,? CUR_PROG_CD_PGM
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') CUR_PROG_CD_DTIME
- ,A.CUR_PROG_CD BEF_PROG_CD
- ,DECODE(A.CUR_PROG_CD_PGM,'',?,A.CUR_PROG_CD_PGM)BEF_PROG_CD_PGM
- ,A.CUR_PROG_CD_DTIME BEF_PROG_CD_DTIME
- ,? ORD_NO
- ,? ORD_SEQ
-
- ,? ORD_FL
- ,a.PRODNM_CD
- ,B.SLAB_THK INSTR_SLAB_THK
- ,B.SLAB_WTH INSTR_SLAB_WTH
- ,B.SLAB_LEN INSTR_SLAB_LEN
- ,B.SLAB_WGT INSTR_SLAB_WGT
- ,B.ORD_THK INSTR_COIL_THK
- ,B.ORD_WTH INSTR_COIL_WTH
- ,? SLAB_THK
- ,? SLAB_WTH
- ,? SLAB_LEN
- ,? SLAB_WGT
-
- ,? HCR_CLF
- ,? SLAB_WAY
- ,? SLAB_RT
- ,? LAST_SLAB_YN
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') SLAB_CUT_DTIME
- ,? CUT_WKSHIFT
-
- ,? CUT_WKGROUP
- ,? CUT_EMP_ID
- ,B.CUST_CD CUST_CD --
- ,B.ORD_USEAGE_CD ORD_USE_CD --
- ,B.SPEC_ABBSYM SPEC_ABBSYM --
- ,B.ORDCUST_CD ORDCUST_CD --
- ,A.SLAB_THK SIZE_UPDT_BEF_THK
- ,A.SLAB_WTH SIZE_UPDT_BEF_WTH
- ,A.SLAB_LEN SIZE_UPDT_BEF_LEN
- ,A.SLAB_WGT SIZE_UPDT_BEF_WGT
- ,? SURPLMATL_YN
- ,A.ORD_NO ORG_ORD_NO
- ,A.ORD_SEQ ORG_ORD_SEQ
- ,? CUR_LOAD_LOC
- ,'' MILL_SCH_STAT
- ,? SLAB_SIZE_DEC_GRD
-
- ,? DIFF_STL_GRD_STA_END_YN
- ,B.CAST_MANA_NO CAST_NO --
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') CUR_LOAD_LOC_DTIME
- ,? PROC_CD
- ,? STRAND_NO
- /*,DECODE(B.HOT_ROLL_REQ_DATE,'JH','','1') EXTSHAPE_GRD*/
- ,? NONORD_CAUSE_CD
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') NONORD_OCR_DTIME
- ,'' MATRL_END_DTIME
- ,'' MATRL_END_CAUSE_CD
- ,? TW_SLAB_YN
- ,'' DSN_SLAB_NO
- ,A.STL_GRD LG_STL_GRD
- FROM TBG02_SLAB_COMM A
- ,TBF01_SPEC_SLAB B
- WHERE '1' = '1'
- AND A.PLAN_SLAB_NO = B.SLAB_MANA_NO
- AND A.SLAB_NO = ?)
- WHERE SLAB_NO = ?
- ]]>
- </query>
-
- <query id="UIG020060_01.insert" desc="This step query is update query to TBG03_STLMAKE_PROG ">
- <![CDATA[
- insert into TBG02_SLAB_COMM
- ( SLAB_NO
- ,PLAN_SLAB_NO
- ,SLAB_STAT
- ,STL_GRD
- ,CUR_PROG_CD
- ,CUR_PROG_CD_PGM
- ,CUR_PROG_CD_DTIME
- ,BEF_PROG_CD
- ,BEF_PROG_CD_PGM
- ,BEF_PROG_CD_DTIME
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_FL
- ,PRODNM_CD
- ,INSTR_SLAB_THK
- ,INSTR_SLAB_WTH
- ,INSTR_SLAB_LEN
- ,INSTR_SLAB_WGT
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,SLAB_WGT
- ,HCR_CLF
- ,SLAB_WAY
- ,SLAB_RT
- ,LAST_SLAB_YN
- ,SLAB_CUT_DTIME
- ,DIFF_STL_GRD_STA_END_YN
- ,CUT_WKSHIFT
- ,CUT_WKGROUP
- ,CUT_EMP_ID
- ,CUST_CD
- ,ORD_USE_CD
- ,SPEC_ABBSYM
- ,ORDCUST_CD
- ,SIZE_UPDT_BEF_THK
- ,SIZE_UPDT_BEF_WTH
- ,SIZE_UPDT_BEF_LEN
- ,SIZE_UPDT_BEF_WGT
- ,SURPLMATL_YN
- ,CUR_LOAD_LOC
- ,CUR_LOAD_LOC_DTIME
- ,MILL_SCH_STAT
- ,SLAB_SIZE_DEC_GRD
- ,CAST_NO
- ,EXTSHAPE_GRD
- ,PROC_CD
- ,STRAND_NO
- ,NONORD_CAUSE_CD
- ,NONORD_OCR_DTIME
- ,ORG_ORD_NO
- ,ORG_ORD_SEQ
- ,SLAB_INGR_DEC_GRD
- ,SLAB_INGR_DEC_KIND
- ,TW_SLAB_YN
- )
- values
- (
-
- ?
- ,?
- ,'2'
- ,?
- ,?
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
- ,''
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
- ,?
- ,?
- ,?
- ,'1'
- ,?
- ,?
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
- ,?
- ,?
- ,?
- ,?
- ,?
- )
- ]]>
- </query>
-
- <query id="UIG020060_report.insert" desc="This step query is update query to TBG03_STLMAKE_PROG ">
- <![CDATA[
- insert into TBG02_SLAB_REPORT(
- SLAB_STAT
- ,STL_GRD
- ,CUR_PROG_CD
- ,CUR_PROG_CD_PGM
- ,CUR_PROG_CD_DTIME
- ,BEF_PROG_CD
- ,BEF_PROG_CD_PGM
- ,BEF_PROG_CD_DTIME
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_FL
- ,PRODNM_CD
- ,INSTR_SLAB_THK
- ,INSTR_SLAB_WTH
- ,INSTR_SLAB_LEN
- ,INSTR_SLAB_WGT
- ,INSTR_COIL_THK
- ,INSTR_COIL_WTH
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,SLAB_WGT
- ,HCR_CLF
- ,SLAB_WAY
- ,SLAB_RT
- ,LAST_SLAB_YN
- ,SLAB_CUT_DTIME
- ,CUT_WKSHIFT
- ,CUT_WKGROUP
- ,CUT_EMP_ID
- ,CUST_CD
- ,ORD_USE_CD
- ,SPEC_ABBSYM
- ,ORDCUST_CD
- ,SIZE_UPDT_BEF_THK
- ,SIZE_UPDT_BEF_WTH
- ,SIZE_UPDT_BEF_LEN
- ,SIZE_UPDT_BEF_WGT
- ,SURPLMATL_YN
- ,ORG_ORD_NO
- ,ORG_ORD_SEQ
- ,CUR_LOAD_LOC
- ,MILL_SCH_STAT
- ,SLAB_SIZE_DEC_GRD
- ,DIFF_STL_GRD_STA_END_YN
- ,CAST_NO
- ,CUR_LOAD_LOC_DTIME
- ,PROC_CD
- ,STRAND_NO
- ,EXTSHAPE_GRD
- ,NONORD_CAUSE_CD
- ,NONORD_OCR_DTIME
- ,MATRL_END_DTIME
- ,MATRL_END_CAUSE_CD
- ,TW_SLAB_YN
- ,DSN_SLAB_NO
- ,SLAB_NO
- )(SELECT '2' SLAB_STAT
- ,a.STL_GRD
- ,? CUR_PROG_CD
- ,? CUR_PROG_CD_PGM
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') CUR_PROG_CD_DTIME
- ,A.CUR_PROG_CD BEF_PROG_CD
- ,DECODE(A.CUR_PROG_CD_PGM,'',?,A.CUR_PROG_CD_PGM)BEF_PROG_CD_PGM
- ,A.CUR_PROG_CD_DTIME BEF_PROG_CD_DTIME
- ,? ORD_NO
- ,? ORD_SEQ
-
- ,? ORD_FL
- ,a.PRODNM_CD
- ,B.SLAB_THK INSTR_SLAB_THK
- ,B.SLAB_WTH INSTR_SLAB_WTH
- ,B.SLAB_LEN INSTR_SLAB_LEN
- ,B.SLAB_WGT INSTR_SLAB_WGT
- ,B.ORD_THK INSTR_COIL_THK
- ,B.ORD_WTH INSTR_COIL_WTH
- ,? SLAB_THK
- ,? SLAB_WTH
- ,? SLAB_LEN
- ,? SLAB_WGT
-
- ,? HCR_CLF
- ,? SLAB_WAY
- ,? SLAB_RT
- ,? LAST_SLAB_YN
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') SLAB_CUT_DTIME
- ,? CUT_WKSHIFT
-
- ,? CUT_WKGROUP
- ,? CUT_EMP_ID
- ,B.CUST_CD CUST_CD --
- ,B.ORD_USEAGE_CD ORD_USE_CD --
- ,B.SPEC_ABBSYM SPEC_ABBSYM --
- ,B.ORDCUST_CD ORDCUST_CD --
- ,A.SLAB_THK SIZE_UPDT_BEF_THK
- ,A.SLAB_WTH SIZE_UPDT_BEF_WTH
- ,A.SLAB_LEN SIZE_UPDT_BEF_LEN
- ,A.SLAB_WGT SIZE_UPDT_BEF_WGT
- ,? SURPLMATL_YN
- ,A.ORD_NO ORG_ORD_NO
- ,A.ORD_SEQ ORG_ORD_SEQ
- ,? CUR_LOAD_LOC
- ,'' MILL_SCH_STAT
- ,? SLAB_SIZE_DEC_GRD
-
- ,? DIFF_STL_GRD_STA_END_YN
- ,B.CAST_MANA_NO CAST_NO --
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') CUR_LOAD_LOC_DTIME
- ,? PROC_CD
- ,? STRAND_NO
- ,'1' EXTSHAPE_GRD
- ,? NONORD_CAUSE_CD
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') NONORD_OCR_DTIME
- ,'' MATRL_END_DTIME
- ,'' MATRL_END_CAUSE_CD
- ,? TW_SLAB_YN
- ,'' DSN_SLAB_NO
- ,? SLAB_NO
- FROM TBG02_SLAB_COMM A
- ,TBF01_SPEC_SLAB B
- WHERE '1' = '1'
- AND A.PLAN_SLAB_NO = B.SLAB_MANA_NO
- AND A.SLAB_NO = ?)
-
- ]]>
- </query>
- <query id="UIG020060_03.select" desc="it's selected query from TBF01_SPEC_SLAB table " fetchSize="10">
- <![CDATA[
- select
- SLAB_EDT_SEQ
- ,STATUS_CD
- ,STL_GRD
- ,ORD_NO
- ,ORD_SEQ
- ,PRODNM_CD
- ,CUST_CD
- ,ORD_USEAGE_CD
- ,SPEC_ABBSYM
- ,ORDCUST_CD
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,SLAB_WGT
- ,HCR_CLF
- ,SLAB_RT
- ,ORD_FL
- ,SCARPING_PROC_YN
- ,CAST_MANA_NO
- ,MILL_FL
- ,DSN_SLAB_NO
- ,ORD_THK
- ,ORD_WTH
- from TBF01_SPEC_SLAB
- where SLAB_MANA_NO=?
- ]]>
- </query>
- <query id="UIG020060_EMP.select" desc="查询板坯切割作业人信息，这里PROC_CD为JJS " fetchSize="10">
- <![CDATA[
- SELECT EMP_NM label
- ,EMP_NM value
- FROM TBZ01_FAC_EMP_GROUP
- WHERE GROUP_CD = ?
- AND PROC_CD = 'JS'
- AND FAC_CD = 'J'
- ]]>
- </query>
- <query id="UIG020060_CH_COM.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CHARGE_COMM SET
- CC_DEVNO = ?
- ,CCM_PRC_LINE = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020060_slab_comm_d.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM_D
- SET SLAB_THK = ?
- ,SLAB_WTH = ?
- ,SLAB_LEN = ?
- ,ORD_LEN = ?
- ,ORD_WGT = decode('Y','Y',ord_wgt,?)
- ,COIL_OUTDIA = ?
- WHERE SLAB_NO = ?
- ]]>
- </query>
- <query id="UIG020060_SLAB_COMM_D_02.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM_D SET
- ORD_FL = ?
- ,ORD_NO = ?
- ,ORD_SEQ = ?
- WHERE SLAB_NO = (SELECT SUB_SLAB_NO FROM TBG02_SLAB_COMM WHERE SLAB_NO = ?)
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM A
- SET A.STRAND_NO = ''
- ,A.SLAB_STAT = '1'
- ,A.CUR_PROG_CD = 'JJB'
- ,A.CUR_LOAD_LOC = ''
- WHERE A.SLAB_NO LIKE ?||'%'
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT.delete" desc=" " fetchSize="10">
- <![CDATA[
- delete from tbg02_slab_comm where substr(sub_slab_no,1,9) = substr(?,1,9)
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT_02.delete" desc=" " fetchSize="10">
- <![CDATA[
- delete from tbg02_slab_comm_d where substr(slab_no,1,9) = substr(?,1,9)
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT_03.delete" desc=" " fetchSize="10">
- <![CDATA[
- delete from tbg02_charge_comm where charge_no = ?
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT_04.delete" desc=" " fetchSize="10">
- <![CDATA[
- delete from tbg02_charge_comm_d where sub_charge_no = ?
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT A.SLAB_MANA_NO FROM TBF01_SPEC_SLAB A
- ,TBG02_CHARGE_COMM B
- WHERE SUBSTR(A.SLAB_MANA_NO,1,10) = B.PLAN_CHARGE_NO
- AND B.CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020060_SLAB_RECUT_02.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG04_SLAB_YARD A
- SET A.SLAB_NO = ''
- ,A.BEF_STORE_LOC = ''
- ,A.CR_NO = ''
- ,A.REG_ID = ''
- ,A.REG_DTIME = ''
- ,A.ORD_FLAG = ''
- WHERE A.SLAB_NO LIKE ?||'%'
- ]]>
- </query>
- <query id="UIG020060_SUBSLABN0_CREATE" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM T
- SET T.SLAB_NO = DECODE(?,'2',(
- SELECT DECODE(MAX(T.SLAB_NO),'',?||'51'||'0',?||lpad((SUBSTR(MAX(T.SLAB_NO),11,2)+1),2,'0')||'0')
- FROM TBG02_SLAB_COMM T
- WHERE T.STRAND_NO = '2'
- AND T.SUB_SLAB_NO LIKE ?||'%'
- AND T.SLAB_NO <> T.SUB_SLAB_NO
- AND SUBSTR(T.SLAB_NO,11,2) > '50'
- ),'1',(
- SELECT DECODE(MAX(T.SLAB_NO),'',?||'01'||'0',?||lpad((SUBSTR(MAX(T.SLAB_NO),11,2)+1),2,'0')||'0')
- FROM TBG02_SLAB_COMM T
- WHERE T.STRAND_NO = '1'
- AND T.SUB_SLAB_NO LIKE ?||'%'
- --AND T.SUB_SLAB_NO <> T.SLAB_NO
- AND SUBSTR(T.SLAB_NO,11,2) < '50'
- ))
- WHERE T.PLAN_SLAB_NO = ?
- AND T.SLAB_STAT = '1'
- ]]>
- </query>
- <query id="UIG020060_proc_rate.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT PROC_RATE FROM TBE01_PROC_RATE WHERE PROC_CD = 'R'
- ]]>
- </query>
- <query id="UIG020060_SLAB_COMMD_ORD.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT ORD_THK ,ORD_WTH,COIL_INDIA,SLAB_THK,SLAB_WTH FROM TBG02_SLAB_COMM_D WHERE SLAB_NO = ?
- ]]>
- </query>
- <query id="UIG020060_compulsory_end_charge_01.update" desc=" " fetchSize="10">
- <![CDATA[
- update tbf01_spec_charge t set t.STATUS_CD = 'C' where t.CHARGE_MANA_NO like ?
- ]]>
- </query>
- <query id="UIG020060_compulsory_end_charge_02.update" desc=" " fetchSize="10">
- <![CDATA[
- update tbf01_charge_idx t set t.STATUS_CD = 'C' where t.CHARGE_MANA_NO like ?
- ]]>
- </query>
- <query id="UIG020060_compulsory_end_charge_03.update" desc=" " fetchSize="10">
- <![CDATA[
- update tbf01_spec_slab t set t.STATUS_CD = 'C' where t.SLAB_MANA_NO like ?
- ]]>
- </query>
- <query id="UIG020060_compulsory_end_charge_04.update" desc=" " fetchSize="10">
- <![CDATA[
- update tbf01_spec_slab_d t set t.STATUS_CD = 'C' where t.SLAB_EDT_SEQ in
- (select slab_edt_seq from tbf01_spec_slab where slab_mana_no like ?)
- ]]>
- </query>
- <query id="UIG020060_compulsory_end_charge_05.update" desc=" " fetchSize="10">
- <![CDATA[
- update tbg02_charge_comm t set t.CHARGE_STAT = '3' where t.CHARGE_NO like ?
- ]]>
- </query>
-
- <query id="UIG020060_charge_ccdevno_06.update" desc="">
- <![CDATA[
- UPDATE TBG06_L2_CHARGE_DEVNO T
- SET T.MSG_FLAG = 'C'
- WHERE T.MSG_FLAG = 'N'
- AND T.CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="HCR_SLABNO_UPD.CAL" desc="更新热装热送的轧制计划的板坯号" >
- {CALL HCR_SLABNO_UPD(?)}
- </query>
- </queryMap>
|
