--ΕVƒoƒbƒ`‡‚‚ΜŽζ“Ύ [lloadTargetBatch] select 1 as TYP , TO_CHAR( m2.DT_PULPER_DAIRY, 'yyyymmdd' ) as DT_SHIPSLIP , m2.NO_BATCH , m2.NO_PULPER_DAIRY from T_PULPER_DAIRY m2 where m2.TIME_BLOW is null union all select 2 as TYP , TO_CHAR( m1.DT_SHIPSLIP, 'yyyymmdd' ) as DT_SHIPSLIP , m1.NO_BATCH , m2.NO_PULPER_DAIRY from T_SHIP_WP m1 --#24303 2022.06.18 MOD STT -- ,T_PULPER_DAIRY m2 left join T_PULPER_DAIRY m2 on ( m2.DT_PULPER_DAIRY = m1.DT_SHIPSLIP and m2.NO_BATCH = m1.NO_BATCH ) --#24303 2022.06.18 MOD END where m1.FLG_DELETE = 0 and m1.CD_PULPER = &1 --#24303 2022.06.18 MOD STT -- and m2.DT_PULPER_DAIRY (+)= m1.DT_SHIPSLIP -- and m2.NO_BATCH (+)= m1.NO_BATCH --#24303 2022.06.18 MOD END and m2.NO_PULPER_DAIRY is null group by TO_CHAR( m1.DT_SHIPSLIP, 'yyyymmdd' ) , m1.NO_BATCH , m2.NO_PULPER_DAIRY order by TYP, DT_SHIPSLIP desc, NO_BATCH desc /* select TO_CHAR( m1.DT_SHIPSLIP, 'yyyymmdd' ) as DT_SHIPSLIP , m1.NO_BATCH , m2.NO_PULPER_DAIRY from T_SHIP_WP m1 ,T_PULPER_DAIRY m2 where m1.FLG_DELETE = 0 and m1.CD_PULPER = &1 and m2.DT_PULPER_DAIRY (+)= m1.DT_SHIPSLIP and m2.NO_BATCH (+)= m1.NO_BATCH and not exists ( select 1 from T_PULPER_DAIRY m3 where ( ( ( m3.DT_PULPER_DAIRY > m1.DT_SHIPSLIP ) ) or ( ( m3.DT_PULPER_DAIRY = m1.DT_SHIPSLIP ) and ( m3.NO_BATCH >= m1.NO_BATCH ) ) ) and m3.TIME_BLOW is not null ) group by TO_CHAR( m1.DT_SHIPSLIP, 'yyyymmdd' ) , m1.NO_BATCH , m2.NO_PULPER_DAIRY order by DT_SHIPSLIP desc, NO_BATCH desc */ --ŒΜŽ†•₯oξ•ρŽζ“Ύ [lloadShipObjects] select NAME_SHIPMENT,NAME_GRADE,WEIGHT_WP from T_SHIP_WP TSP ,M_SHIPMENT MS , M_WP MP --#24303 2022.06.18 MOD STT -- where TSP.CD_PULPER = '&4' -- and TSP.DT_SHIPSLIP = '&1' -- and TSP.NO_BATCH = '&2' where TSP.CD_PULPER = to_number('&4') and TSP.DT_SHIPSLIP = to_timestamp('&1','YYYYMMDD') and TSP.NO_BATCH = to_number('&2') --#24303 2022.06.18 MOD END -- and TSP.CD_STAFF = '&3' and TSP.FLG_DELETE = 0 and TSP.CD_SHIPMENT = MS.CD_SHIPMENT and TSP.CD_WP = MP.CD_WP --#24303 2022.06.18 MOD STT -- and MS.DT_START <= '&1' -- and MS.DT_END >= '&1' and MS.DT_START <= to_timestamp('&1','YYYYMMDD') and MS.DT_END >= to_timestamp('&1','YYYYMMDD') --#24303 2022.06.18 MOD END and MS.FLG_DELETE = 0 --#24303 2022.06.18 MOD STT -- and MP.DT_START <= '&1' -- and MP.DT_END >= '&1' and MP.DT_START <= to_timestamp('&1','YYYYMMDD') and MP.DT_END >= to_timestamp('&1','YYYYMMDD') --#24303 2022.06.18 MOD END and MP.FLG_DELETE = 0 --ΚίΩΚί°“ϊ•ρ—š—π‰ζ–Κ•\Ž¦—pƒf[ƒ^ŒŸυ [lDBSearchPulper] select to_char(TPD.DT_PULPER_DAIRY,'yyyymmdd') DT_PULPER_DAIRY , TPD.NO_BATCH , TPD.NO_PULPER_DAIRY , MS.CD_STAFF , MS.NAME_STAFF , SUM(TSW.WEIGHT_WP) WEIGHT_WP , MC.CD_CUSTOMER , MC.NAME_CUSTOMER , MD.CD_DERIVERY , MD.NAME_DERIVERY , MP.CD_PRODUCT , MP.NAME_PRODUCT , MG.CD_GRADE , MG.NAME_GREAD from T_PULPER_DAIRY TPD , T_SHIP_WP TSW , M_STAFF MS , M_CUSTOMER MC , M_DERIVERY MD , M_PRODUCT MP , M_GREAD MG where TPD.DTS_YEAR = '&1' and TPD.DTS_MONTH = '&2' and (('&3' IS NULL) OR (TPD.DTS_DAY = '&3')) and TPD.NO_BATCH = TSW.NO_BATCH and TPD.DT_PULPER_DAIRY = TSW.DT_SHIPSLIP and TSW.CD_CUSTOMER = MC.CD_CUSTOMER and TSW.CD_DERIVERY = MD.CD_DERIVERY and TSW.CD_PRODUCT = MP.CD_PRODUCT and TSW.CD_GRADE_PRODUCT = MG.CD_GRADE and TPD.CD_STAFF = MS.CD_STAFF and MC.DT_START <= TPD.DT_PULPER_DAIRY and MC.DT_END >= TPD.DT_PULPER_DAIRY and MD.DT_START <= TPD.DT_PULPER_DAIRY and MD.DT_END >= TPD.DT_PULPER_DAIRY and MP.DT_START <= TPD.DT_PULPER_DAIRY and MP.DT_END >= TPD.DT_PULPER_DAIRY GROUP BY TPD.DT_PULPER_DAIRY , TPD.NO_BATCH , TPD.NO_PULPER_DAIRY , MS.CD_STAFF , MS.NAME_STAFF , MC.CD_CUSTOMER , MC.NAME_CUSTOMER , MD.CD_DERIVERY , MD.NAME_DERIVERY , MP.CD_PRODUCT , MP.NAME_PRODUCT , MG.CD_GRADE , MG.NAME_GREAD ORDER BY TPD.DT_PULPER_DAIRY DESC , TPD.NO_BATCH DESC --ΚίΩΚί°“ϊ•ρƒf[ƒ^Žζ“Ύ [lloadPulper] select NO_PULPER_DAIRY , DT_PULPER_DAIRY , DTS_YEAR , DTS_MONTH , DTS_DAY , NO_BATCH , CD_STAFF , to_char(START_TIME,'yyyy' ) START_TIME_YEAR , to_char(START_TIME,'mm') START_TIME_MONTH , to_char(START_TIME,'dd') START_TIME_DAY , to_char(START_TIME,'hh24' ) START_TIME_H , to_char(START_TIME,'mi') START_TIME_M , to_char(END_TIME,'hh24') END_TIME_H , to_char(END_TIME,'mi') END_TIME_M , to_char(START_TIME, 'yyyymmddhh24miss') as START_TIME , to_char(END_TIME, 'yyyymmddhh24miss') as END_TIME , THERMO , TIME_SHIP_WP, CHEMICALS_SHIP_WP, AMPERE_SHIP_WP, VOLUME_SHIP_WP , TIME_MELT1, CHEMICALS_MELT1, TIME_CHEMICALS_MELT1, AMPERE_MELT1,VOLUME_MELT1 , TIME_NEUTRALIZE, CHEMICALS_NEUTRALIZE , TIME_MELT2, CHEMICALS_MELT2, AMPERE_MELT2, VOLUME_MELT2 , TIME_SEND ,TIME_BLOW , COMMENT1, COMMENT2, COMMENT3 , to_char(TIME_VERIFICATION,'yyyy' ) TIME_VERIFICATION_YEAR , to_char(TIME_VERIFICATION,'mm') TIME_VERIFICATION_MONTH , to_char(TIME_VERIFICATION,'dd') TIME_VERIFICATION_DAY , to_char(TIME_VERIFICATION,'hh24' ) TIME_VERIFICATION_H , to_char(TIME_VERIFICATION,'mi') TIME_VERIFICATION_M , to_char(TIME_VERIFICATION,'hh24:mi') TIME_VERIFICATION , UP_KAIDO, REST_CHEST, PH, CONDITION -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ««««« -- 2010.03.20 KSP@S.Nishimura@šρŽG•¨No’Η‰Α‘Ξ‰ž ««««« , PUREWATER, NO_DUST, DUST_COUNT, WEIGHT_WP -- 2010.03.20 KSP@S.Nishimurai@šρŽG•¨No’Η‰Α‘Ξ‰ž ͺͺͺͺͺ -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ͺͺͺͺͺ from T_PULPER_DAIRY --#24303 2022.06.18 MOD STT -- where DT_PULPER_DAIRY = '&1' -- and NO_BATCH = '&2' -- and NO_PULPER_DAIRY = '&5' where DT_PULPER_DAIRY = to_timestamp('&1','YYYYMMDD') and NO_BATCH = to_number('&2') and NO_PULPER_DAIRY = to_number('&5') --#24303 2022.06.18 MOD END [lsaveRemovePulper] delete from T_PULPER_DAIRY where NO_PULPER_DAIRY = &1 --ΚίΩΚί°“ϊ•ρ [lsaveInsertPulper] insert into T_PULPER_DAIRY( NO_PULPER_DAIRY -- ƒpƒ‹ƒp[“o˜^No ,DT_PULPER_DAIRY -- “Š“ό“ϊ•t ,DTS_YEAR -- “Š“ό”N ,DTS_MONTH -- “Š“όŒŽ ,DTS_DAY -- “Š“ό“ϊ ,NO_BATCH -- ƒoƒbƒ`No ,CD_STAFF -- ŽΠˆυƒR[ƒh ,START_TIME -- ŠJŽnŽž ,END_TIME -- I—ΉŽž ,THERMO -- Ždž…‰·“x ,TIME_SHIP_WP -- Œ΄—Ώ“Š“όŽžŠΤ ,CHEMICALS_SHIP_WP -- Œ΄—Ώ“Š“όŽž–ς•i—Κ ,AMPERE_SHIP_WP -- Œ΄—Ώ“Š“όŽž•‰‰Χ ,VOLUME_SHIP_WP -- Œ΄—Ώ“Š“όŽž—eΟ ,TIME_MELT1 -- ˆκŽŸ—£‰πŽžŠΤ ,CHEMICALS_MELT1 -- ˆκŽŸ—£‰πŽž–ς•i—Κ ,TIME_CHEMICALS_MELT1 -- ˆκŽŸ—£‰πŽž–ς•iŽžŠΤ ,AMPERE_MELT1 -- ˆκŽŸ—£‰πŽž•‰‰Χ ,VOLUME_MELT1 -- ˆκŽŸ—£‰πŽž—eΟ ,TIME_NEUTRALIZE -- ’†˜aŽžŠΤ ,CHEMICALS_NEUTRALIZE -- ’†˜aŽž–ς•i—Κ ,TIME_MELT2 -- “ρŽŸ—£‰πŽžŠΤ ,CHEMICALS_MELT2 -- “ρŽŸ—£‰πŽž–ς•i ,AMPERE_MELT2 -- “ρŽŸ—£‰πŽž•‰‰Χ ,VOLUME_MELT2 -- “ρŽŸ—£‰πŽž—eΟ ,TIME_SEND -- ‘—‚θŽžŠΤ ,TIME_BLOW -- ƒuƒ[ŽžŠΤ ,COMMENT1 -- ƒRƒƒ“ƒg‚P ,COMMENT2 -- ƒRƒƒ“ƒg‚Q ,COMMENT3 -- ƒRƒƒ“ƒg‚R ,TIME_VERIFICATION -- ŒŸΨŽž ,UP_KAIDO -- ‚t‚oŠJ“x ,REST_CHEST -- ƒ`ƒFƒXƒgŽc—Κ ,PH -- ‚o‚g ,CONDITION -- —n‚―‹ο‡ ,ID_REGIST -- “o˜^’[––‚h‚c ,ID_UPDATE -- C³’[––‚h‚c ,ID_DELETE -- νœ’[––‚h‚c ,DT_REGIST -- “o˜^“ϊ ,DT_UPDATE -- C³“ϊ ,DT_DELETE -- νœ“ϊ -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ««««« ,PUREWATER , DUST_COUNT , WEIGHT_WP -- 2010.03.20 KSP@S.Nishimura@šρŽG•¨No’Η‰Α‘Ξ‰ž ««««« , NO_DUST -- 2010.03.20 KSP@S.Nishimurai@šρŽG•¨No’Η‰Α‘Ξ‰ž ͺͺͺͺͺ -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ««««« )values( &1 -- ƒpƒ‹ƒp[“o˜^No , to_date('&2','yyyymmdd') -- “Š“ό“ϊ•t , &3 -- “Š“ό”N , &4 -- “Š“όŒŽ , &5 -- “Š“ό“ϊ , &6 -- ƒoƒbƒ`No , &7 -- ŽΠˆυƒR[ƒh , to_timestamp('&8','yyyymmddHH24MISS') -- ŠJŽnŽž , to_timestamp('&9','yyyymmddHH24MISS') -- I—ΉŽž , &10 -- Ždž…‰·“x , &11 -- Œ΄—Ώ“Š“όŽžŠΤ , &12 -- Œ΄—Ώ“Š“όŽž–ς•i—Κ , &13 -- Œ΄—Ώ“Š“όŽž•‰‰Χ , &14 -- Œ΄—Ώ“Š“όŽž—eΟ , &15 -- ˆκŽŸ—£‰πŽžŠΤ , &16 -- ˆκŽŸ—£‰πŽž–ς•i—Κ , &17 -- ˆκŽŸ—£‰πŽž–ς•iŽžŠΤ , &18 -- ˆκŽŸ—£‰πŽž•‰‰Χ , &19 -- ˆκŽŸ—£‰πŽž—eΟ , &20 -- ’†˜aŽžŠΤ , &21 -- ’†˜aŽž–ς•i—Κ , &22 -- “ρŽŸ—£‰πŽžŠΤ , &23 -- “ρŽŸ—£‰πŽž–ς•i , &24 -- “ρŽŸ—£‰πŽž•‰‰Χ , &25 -- “ρŽŸ—£‰πŽž—eΟ , &26 -- ‘—‚θŽžŠΤ , &27 -- ƒuƒ[ŽžŠΤ , '&28' -- ƒRƒƒ“ƒg‚P , '&29' -- ƒRƒƒ“ƒg‚Q , '&30' -- ƒRƒƒ“ƒg‚R -- #24784 ŒŸΨŽžŠΤ‚ͺ0001”N01ŒŽ01“ϊ‚Ι‚Θ‚ι•”•ͺ‚Μ‘Ξ‰ž , to_timestamp(nullif('&31',''),'yyyymmddHH24MISS') -- ŒŸΨŽž -- , to_timestamp('&31','yyyymmddHH24MISS') -- ŒŸΨŽž , &32 -- ‚t‚oŠJ“x , &33 -- ƒ`ƒFƒXƒgŽc—Κ , &34 -- ‚o‚g , '&35' -- —n‚―‹ο‡ , '&36' -- “o˜^’[––‚h‚c , null -- C³’[––‚h‚c , null -- νœ’[––‚h‚c , to_timestamp(to_char(now(),'yyyymmddHH24MISS'),'yyyymmddHH24MISS') -- “o˜^“ϊ , null -- C³“ϊ , null -- νœ“ϊ -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ««««« , &37 -- ”’…‰·“x , &38 -- šρŽG•¨ , &39 -- ‘d—Κ -- 2010.03.20 KSP@S.Nishimura@šρŽG•¨No’Η‰Α‘Ξ‰ž ««««« , &40 -- šρŽG•¨No -- 2010.03.20 KSP@S.Nishimurai@šρŽG•¨No’Η‰Α‘Ξ‰ž ͺͺͺͺͺ -- 2010.02.23 KSP@K.Takahashi@H’φƒXƒLƒbƒv‘Ξ‰ž ««««« ) [lsaveInsertSkipPulpers] --#24454 2022.06.18 MOD STT --declare begin NSP_PacMain.changePulperDairy( '&36', &1 );end; select changePulperDairy( '&36', &1 ) --#24454 2022.06.18 MOD END