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.CSC_RESPONSE_CENTER_PKG dependencies on AR_LOOKUPS

Line 280: FROM hz_contact_points ph, ar_lookups lkup

276: INTO l_phone_country_code, l_phone_area_code, l_phone_number,
277: l_phone_line_type, l_phone_line_code,
278: l_phone_id, l_phone_object_version_number, l_phone_extension,
279: l_full_phone
280: FROM hz_contact_points ph, ar_lookups lkup
281: WHERE ph.phone_line_type = lkup.lookup_code
282: AND lkup.lookup_type = 'PHONE_LINE_TYPE'
283: AND lkup.enabled_flag = 'Y'
284: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE))

Line 353: ar_lookups lkup ,

349: l_phone_object_version_number,
350: l_phone_extension ,
351: l_full_phone
352: FROM hz_contact_points ph,
353: ar_lookups lkup ,
354: hz_party_sites ps
355: WHERE ph.phone_line_type = lkup.lookup_code
356: AND lkup.lookup_type = 'PHONE_LINE_TYPE'
357: AND lkup.enabled_flag = 'Y'