#-----------------------------------------------------------
#--通信事業者拠点(TU_M_TUSHIN_JGS_KTN-TU_SELECT_001)
#--通信事業者コードを元に、通信事業者拠点コードを取得する。
#-----------------------------------------------------------

--KEY:TU_SELECT_001

select
  TU0131.TSJGS_KTN_CD
from
  TU_M_TUSHIN_JGS_KTN TU0131
  , TU_M_TUSHIN_JGYOSHA TU0051 
where
  TU0131.MK_FLG = '0' 
  AND TU0051.MK_FLG = '0'
  AND TU0051.TSJGS_CD = TU0131.TSJGS_CD 
  AND TSJGS_KTN_TSTAYMD <= ?
  AND TSJGS_KTN_TENDYMD >= ?
  AND TU0131.TSJGS_CD = ?

#-