#-----------------------------------------------------------
#--セット品構成(TN_M_SETHN_KOSE-DK_SELECT_001)
#--宅内機器セット品型コードをキーにセット品構成情報を取得する。
#-----------------------------------------------------------

--KEY:DK_SELECT_001

SELECT
    TN_SETHN_KOSE.TAKNKIKI_MODEL_CD AS TAKNKIKI_MODEL_CD,
    TN_SETHN_KOSE.CNT AS CNT
FROM TN_M_SETHN_KOSE TN_SETHN_KOSE
WHERE TN_SETHN_KOSE.TAKNKIKI_SETHIN_MODEL_CD = ?
AND ? BETWEEN TN_SETHN_KOSE.SETHN_KOSE_TSTAYMD AND TN_SETHN_KOSE.SETHN_KOSE_TENDYMD
AND TN_SETHN_KOSE.MK_FLG = '0'
ORDER BY TN_SETHN_KOSE.TAKNKIKI_MODEL_CD

#-

#-----------------------------------------------------------
#--セット品構成(TN_M_SETHN_KOSE-DK_SELECT_002)
#--有効なデータを全件取得
#-----------------------------------------------------------

--KEY:DK_SELECT_002

SELECT
  SETHN_KOSE.TAKNKIKI_SETHIN_MODEL_CD
  , SETHN_KOSE.TAKNKIKI_MODEL_CD
  , SETHN_KOSE.CNT
FROM
  TN_M_SETHN_KOSE SETHN_KOSE
WHERE
  ? BETWEEN SETHN_KOSE.SETHN_KOSE_TSTAYMD AND SETHN_KOSE.SETHN_KOSE_TENDYMD
  AND SETHN_KOSE.MK_FLG = '0'
ORDER BY
  SETHN_KOSE.TAKNKIKI_SETHIN_MODEL_CD
  , SETHN_KOSE.TAKNKIKI_MODEL_CD

#-