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

Line 529: FROM hz_contact_points

525: END IF;
526:
527: FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
528: PHONE_EXTENSION meaning
529: FROM hz_contact_points
530: WHERE owner_table_name = 'HZ_PARTIES' AND
531: owner_table_id = p_party_id AND
532: contact_point_type = 'PHONE' AND
533: primary_flag = 'Y' AND

Line 661: FROM hz_contact_points,

657: END IF;
658:
659: FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
660: PHONE_EXTENSION meaning
661: FROM hz_contact_points,
662: as_lead_contacts_all aslc
663: WHERE aslc.lead_id = p_lead_id AND
664: aslc.primary_contact_flag = 'Y' AND
665: owner_table_name = 'HZ_PARTIES' AND