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_SUMMARIZATION_PKG dependencies on AMS_TCOP_CONTACTS

Line 159: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry

155: p_no_of_days NUMBER)
156: IS
157: SELECT contact.party_id,
158: contact.schedule_id
159: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry
160: WHERE contact.MEDIA_ID = p_activity_id
161: AND (contact_date between (sysdate - p_no_of_days) and sysdate)
162: AND contact.PARTY_ID = list_entry.PARTY_ID
163: AND list_entry.list_header_id = p_list_header_id

Line 173: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry

169: CURSOR C_GET_GLOBAL_SUMMARY (p_list_header_id NUMBER, p_no_of_days NUMBER)
170: IS
171: SELECT contact.party_id,
172: contact.schedule_id
173: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry
174: WHERE (contact_date between (sysdate - p_no_of_days) and sysdate)
175: AND contact.PARTY_ID = list_entry.PARTY_ID
176: AND list_entry.list_header_id = p_list_header_id
177: AND list_entry.enabled_flag = 'Y'