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

Line 745: FROM hz_contact_points

741: IS
742: CURSOR l_phone_cur (p_party_site_id IN NUMBER) IS
743: SELECT phone_area_code,
744: phone_number
745: FROM hz_contact_points
746: WHERE owner_table_name = 'HZ_PARTY_SITES'
747: AND owner_table_id = p_party_site_id
748: AND contact_point_type = 'PHONE'
749: AND phone_line_type = 'GEN'

Line 756: FROM hz_contact_points

752:
753: CURSOR l_fax_cur (p_party_site_id IN NUMBER) IS
754: SELECT phone_area_code fax_area_code,
755: phone_number fax_number
756: FROM hz_contact_points
757: WHERE owner_table_name = 'HZ_PARTY_SITES'
758: AND owner_table_id = p_party_site_id
759: AND contact_point_type = 'PHONE'
760: AND phone_line_type = 'FAX'

Line 765: FROM hz_contact_points

761: AND status = 'A' ;
762:
763: CURSOR l_email_cur (p_party_site_id IN NUMBER) IS
764: SELECT email_address
765: FROM hz_contact_points
766: WHERE owner_table_name = 'HZ_PARTY_SITES'
767: AND owner_table_id = p_party_site_id
768: AND contact_point_type = 'EMAIL'
769: AND primary_flag = 'Y'