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_CHANNEL_SUMMARY

Line 559: FROM ams_tcop_channel_summary summary,

555: p_media_id number
556: )
557: IS
558: SELECT list.LIST_ENTRY_ID,summary.party_id
559: FROM ams_tcop_channel_summary summary,
560: ams_list_entries list
561: WHERE list.LIST_HEADER_ID = p_list_header_id
562: AND summary.PARTY_ID = list.PARTY_ID
563: AND list.ENABLED_FLAG = 'Y'

Line 578: FROM ams_tcop_channel_summary summary,

574: p_already_fatigued_list JTF_NUMBER_TABLE
575: )
576: IS
577: SELECT list.LIST_ENTRY_ID,summary.party_id
578: FROM ams_tcop_channel_summary summary,
579: ams_list_entries list
580: WHERE list.LIST_HEADER_ID = p_list_header_id
581: AND summary.PARTY_ID = list.PARTY_ID
582: AND list.ENABLED_FLAG = 'Y'

Line 649: FROM ams_tcop_channel_summary summary,

645: )
646: IS
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))