eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_CONTACT_SUMMARY

Line 525: FROM ams_tcop_contact_summary summary,

521: CURSOR c_Get_Global_Fatigue_list1(p_list_header_id number,
522: p_rule_id number)
523: IS
524: SELECT list.LIST_ENTRY_ID,summary.party_id
525: FROM ams_tcop_contact_summary summary,
526: ams_list_entries list
527: WHERE list.LIST_HEADER_ID = p_list_header_id
528: AND summary.PARTY_ID = list.PARTY_ID
529: AND list.ENABLED_FLAG = 'Y'

Line 540: FROM ams_tcop_contact_summary summary,

536: p_already_fatigued_list JTF_NUMBER_TABLE
537: )
538: IS
539: SELECT list.LIST_ENTRY_ID,summary.party_id
540: FROM ams_tcop_contact_summary summary,
541: ams_list_entries list
542: WHERE list.LIST_HEADER_ID = p_list_header_id
543: AND summary.PARTY_ID = list.PARTY_ID
544: AND list.ENABLED_FLAG = 'Y'

Line 598: FROM ams_tcop_contact_summary summary,

594: CURSOR c_Get_Global_Fatigue_By_List(p_list_header_id number,
595: p_rule_id number)
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

Line 622: FROM ams_tcop_contact_summary summary,

618: ,p_ftg_party_list JTF_NUMBER_TABLE)
619: IS
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))