#-----------------------------------------------------------
#--バッチ用宅内機器物流在庫ワーク(DK_T_BAT_TKKBRZK_WK-DK_SELECT_001)
#--バッチ用宅内機器物流在庫ワークを一意照会する
#-----------------------------------------------------------

--KEY:DK_SELECT_001

SELECT DK_TKKBRZK.TAKNKIKI_MODEL_CD AS TAKNKIKI_MODEL_CD,
       DK_TKKBRZK.JZAIKO_CNT AS JZAIKO_CNT,
       DK_TKKBRZK.HAISO_UK_JUCHU_CNT AS HAISO_UK_JUCHU_CNT,
       DK_TKKBRZK.HAISO_SHUKKA_SJI_CNT AS HAISO_SHUKKA_SJI_CNT,
       DK_TKKBRZK.YBKKHAI_SJI_CNT AS YBKKHAI_SJI_CNT,
       DK_TKKBRZK.SHELF_MOVE_SJI_CNT AS SHELF_MOVE_SJI_CNT,
       DK_TKKBRZK.YBKKHAI_CHU_CNT AS YBKKHAI_CHU_CNT,
       DK_TKKBRZK.TJITU_NYUKA_CNT AS TJITU_NYUKA_CNT,
       DK_TKKBRZK.TJITU_HAISO_SHUKKA_CNT AS TJITU_HAISO_SHUKKA_CNT,
       DK_TKKBRZK.TJITU_DSL_TEKKYO_HMPIN_CNT AS TJITU_DSL_TEKKYO_HMPIN_CNT,
       DK_TKKBRZK.TJITU_TRB_KKN_HMPIN_CNT AS TJITU_TRB_KKN_HMPIN_CNT,
       DK_TKKBRZK.SHELF_MOVE_NYUKA_FIN_CNT AS SHELF_MOVE_NYUKA_FIN_CNT,
       DK_TKKBRZK.SHELF_MOVE_SHUKKA_FIN_CNT AS SHELF_MOVE_SHUKKA_FIN_CNT,
       DK_TKKBRZK.YOBI_KKSHKA_FIN_CNT AS YOBI_KKSHKA_FIN_CNT,
       DK_TKKBRZK.PLAN_GAI_NYUKA_CNT AS PLAN_GAI_NYUKA_CNT,
       DK_TKKBRZK.PLAN_GAI_SHUKKA_CNT AS PLAN_GAI_SHUKKA_CNT
FROM   DK_T_BAT_TKKBRZK_WK DK_TKKBRZK
WHERE  DK_TKKBRZK.JOB_ID = ?
AND    DK_TKKBRZK.KANRI_PLACE_SKCD = ?
AND    DK_TKKBRZK.KANRI_PLACE_CD = ?
AND    DK_TKKBRZK.KANRI_PLACE_SHELF_CD = ?
AND    DK_TKKBRZK.TAKNKIKI_MODEL_CD = ?
AND    DK_TKKBRZK.MK_FLG = '0'

#-

#-----------------------------------------------------------
#--バッチ用宅内機器物流在庫ワーク(DK_T_BAT_TKKBRZK_WK-DK_UPDATE_001)
#--宅内機器型式確定処理の先頭で実行する。
#-----------------------------------------------------------

--KEY:DK_UPDATE_001

UPDATE DK_T_BAT_TKKBRZK_WK DK0511
SET DK0511.PLAN_GAI_SHUKKA_CNT = DK0511.HAISO_UK_JUCHU_CNT
   ,DK0511.UPD_DTM = 'UPD_DTM'
   ,DK0511.UPD_OPEACNT = 'UPD_OPE'
   ,DK0511.UPD_UNYO_YMD = 'UPD_UNYO'
   ,DK0511.UPD_TRN_ID = 'UPD_TRN'
WHERE DK0511.JOB_ID = ?

#-