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

Line 1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp

1070: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1071: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||
1072: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1073: hcp.phone_number customer_site_tel_number
1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1075: WHERE hps.location_id = hl.location_id
1076: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1077: AND hcp.owner_table_id = hps.party_site_id
1078: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR