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 HZ_CONTACT_PREFERENCES

Line 326: FROM HZ_CONTACT_PREFERENCES pref,

322: ,list_entry.list_entry_id
323: ,pref.CONTACT_TYPE
324: ,pref.MAX_NO_OF_INTERACTIONS
325: ,pref.MAX_NO_OF_INTERACT_UOM_CODE
326: FROM HZ_CONTACT_PREFERENCES pref,
327: ams_list_entries list_entry
328: WHERE list_entry.LIST_HEADER_ID = p_list_header_id
329: AND pref.contact_level_table='HZ_PARTIES'
330: AND pref.contact_level_table_id = list_entry.PARTY_ID

Line 350: FROM HZ_CONTACT_PREFERENCES pref,

346: ,list_entry.list_entry_id list_entry_id
347: ,pref.CONTACT_TYPE CONTACT_TYPE
348: ,pref.MAX_NO_OF_INTERACTIONS MAX_NO_OF_INTERACTIONS
349: ,pref.MAX_NO_OF_INTERACT_UOM_CODE MAX_NO_OF_INTERACT_UOM_CODE
350: FROM HZ_CONTACT_PREFERENCES pref,
351: ams_list_entries list_entry
352: WHERE list_entry.LIST_HEADER_ID = p_list_header_id
353: AND pref.contact_level_table='HZ_PARTIES'
354: AND pref.contact_level_table_id = list_entry.PARTY_ID

Line 375: -- within a time frame specified in the HZ_CONTACT_PREFERENCES

371: AND contact_date between sysdate and (sysdate - p_no_of_days);
372:
373:
374: -- This cursor is to select all the contacts made by the fatiguing schedules
375: -- within a time frame specified in the HZ_CONTACT_PREFERENCES
376: CURSOR C_GET_CONTACTED_SCHEDULE(p_party_id NUMBER,
377: p_no_of_days NUMBER
378: )
379: IS