#-----------------------------------------------------------
#--工事会社配送依頼ワーク(KU_T_KOCHAI_REQ_WK-KU_SELECT_001)
#--【工事会社配送依頼登録】
#--抽出フラグが「未抽出」の工事会社配送依頼ワークを抽出する。
#-----------------------------------------------------------

--KEY:KU_SELECT_001

SELECT
    KU0241.KOCHAI_REQ_WK_NO,
    KU0241.CHSHT_FLG,
    KU0241.SVC_KEI_NO,
    KU0241.RENKEI_DTM,
    KU0241.OPMS_RNKI_CD,
    KU0241.KOJIAK_SBT_CD,
    KU0241.OPMS_DATA_SBT_CD,
    KU0241.KOJIAK_NO,
    KU0241.HISOS_BUIOFFC_KOJI_COMP_CD,
    KU0241.KKSHKA_RSVD_SNSTSTD_YMD,
    KU0241.KOJI_RSV_OYA_PON_MAKER_CD,
    KU0241.KOJI_RSV_VA_MAKER_CD,
    KU0241.KOJI_RSV_IP_KOJIAK_SBT_CD,
    KU0241.KOJI_RSV_VONU_MAKER_CD,
    KU0241.KOJI_RSV_TV_KOJIAK_SBT_CD,
    KU0241.KOJI_RSV_DSGN_BUNSHO_NO,
    KU0241.KOJI_RSV_MSKM_FORM_CD
FROM
    KU_T_KOCHAI_REQ_WK KU0241
WHERE
    KU0241.CHSHT_FLG = '0' 
AND
    KU0241.MK_FLG = '0'
ORDER BY
    KOCHAI_REQ_WK_NO

#-