#-----------------------------------------------------------
#--料金サービス条件(AC_M_PRC_SVC_JOKEN-AC_SELECT_001)
#--UIA17_ACPRC00101_課金対象サービス契約作成.xlsx　参照
#-----------------------------------------------------------

--KEY:AC_SELECT_001

SELECT
      AC0191.PCRS_CD ,
      AC0191.PRC_SVC_CD ,
      AC0191.PRC_SVC_JOKEN_CD
FROM
      AC_M_PRC_SVC_JOKEN AC0191
WHERE
      AC0191.SYS_CD      = ?
  AND AC0191.REC_SKBT_CD = ?
  AND ? BETWEEN AC0191.PRC_SVC_JOKEN_TSTAYMD
            AND AC0191.PRC_SVC_JOKEN_TENDYMD
  AND AC0191.MK_FLG      = '0'

#-

#-----------------------------------------------------------
#--料金サービス条件(AC_M_PRC_SVC_JOKEN-KK_SELECT_001)
#--KKPRC04604
#--スマートリンク端末系サービス条件レコード取得
#-----------------------------------------------------------

--KEY:KK_SELECT_001

SELECT
    DISTINCT
    AC0191.PRC_SVC_CD
FROM
    AC_M_PRC_SVC_JOKEN AC0191
WHERE
    AC0191.REC_SKBT_CD = ?
    AND AC0191.GENE_ADD_DTM =
    (SELECT 
         MAX(AC0191_GENE.GENE_ADD_DTM) AS AC0191_MAX
     FROM   
         AC_M_PRC_SVC_JOKEN AC0191_GENE
     WHERE  
         AC0191_GENE.SYS_CD = AC0191.SYS_CD AND
         AC0191_GENE.PCRS_CD = AC0191.PCRS_CD AND
         AC0191_GENE.PRC_SVC_CD = AC0191.PRC_SVC_CD AND
         AC0191_GENE.REC_SKBT_CD = AC0191.REC_SKBT_CD AND
         AC0191_GENE.PRC_SVC_JOKEN_TSTAYMD <= ?  AND
         AC0191_GENE.PRC_SVC_JOKEN_TENDYMD >= ?  AND
         AC0191_GENE.MK_FLG = '0')
ORDER BY PRC_SVC_CD

#-