DBA Data[Home] [Help]

APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_CONTACT_SUM_DTL

Line 600: ams_tcop_contact_sum_dtl sum_dtl

596: IS
597: SELECT list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
598: FROM ams_tcop_contact_summary summary,
599: ams_list_entries list,
600: ams_tcop_contact_sum_dtl sum_dtl
601: WHERE list.LIST_HEADER_ID =
602: AND summary.PARTY_ID = list.PARTY_ID
603: AND summary.total_contacts = (SELECT max_contact_allowed
604: FROM ams_tcop_fr_rules_setup

Line 624: ams_tcop_contact_sum_dtl sum_dtl,

620: SELECT /*+ leading(party_list) +*/
621: list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
622: FROM ams_tcop_contact_summary summary,
623: ams_list_entries list,
624: ams_tcop_contact_sum_dtl sum_dtl,
625: (SELECT column_value party_id
626: FROM TABLE(CAST(p_ftg_party_list as JTF_NUMBER_TABLE))
627: ) party_list
628: WHERE summary.CONTACT_SUMMARY_ID = sum_dtl.CONTACT_SUMMARY_ID