APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_CHANNEL_SUM_DTL

Line 651: ams_tcop_channel_sum_dtl sum_dtl,

647: SELECT /*+ leading(party_list) +*/
648: list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
649: FROM ams_tcop_channel_summary summary,
650: ams_list_entries list,
651: ams_tcop_channel_sum_dtl sum_dtl,
652: (SELECT column_value party_id
653: FROM TABLE(CAST(p_ftg_party_list as JTF_NUMBER_TABLE))
654: ) party_list
655: WHERE summary.CHANNEL_SUMMARY_ID = sum_dtl.CHANNEL_SUMMARY_ID