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.CS_ERES_INT_PKG dependencies on HZ_CONTACT_POINTS

Line 1314: FROM hz_contact_points party_cont,

1310: SELECT ar.meaning PHONE_TYPE,
1311: nvl2(party_cont.phone_country_code, party_cont.phone_country_code || '-',null ) ||
1312: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1313: party_cont.phone_number PHONE_NUMBER
1314: FROM hz_contact_points party_cont,
1315: cs_hz_sr_contact_points sr_cont,
1316: FND_LOOKUP_VALUES ar
1317: WHERE sr_cont.incident_id = v_incident_id
1318: AND sr_cont.contact_point_id = party_cont.contact_point_id

Line 1348: FROM hz_contact_points party_cont,

1344:
1345: --:Contact_Email
1346: CURSOR Get_Contact_Email (v_incident_id NUMBER) IS
1347: SELECT party_cont.email_address EMAIL
1348: FROM hz_contact_points party_cont,
1349: cs_hz_sr_contact_points sr_cont
1350: WHERE sr_cont.incident_id = v_incident_id
1351: AND sr_cont.contact_point_id = party_cont.contact_point_id
1352: AND sr_cont.contact_type <> 'EMPLOYEE'