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 714: FROM hz_contact_points

710: IS
711: CURSOR l_phone_cur (p_party_site_id IN NUMBER) IS
712: SELECT phone_area_code,
713: phone_number
714: FROM hz_contact_points
715: WHERE owner_table_name = 'HZ_PARTY_SITES'
716: AND owner_table_id = p_party_site_id
717: AND contact_point_type = 'PHONE'
718: AND phone_line_type = 'GEN'

Line 725: FROM hz_contact_points

721:
722: CURSOR l_fax_cur (p_party_site_id IN NUMBER) IS
723: SELECT phone_area_code fax_area_code,
724: phone_number fax_number
725: FROM hz_contact_points
726: WHERE owner_table_name = 'HZ_PARTY_SITES'
727: AND owner_table_id = p_party_site_id
728: AND contact_point_type = 'PHONE'
729: AND phone_line_type = 'FAX'

Line 734: FROM hz_contact_points

730: AND status = 'A' ;
731:
732: CURSOR l_email_cur (p_party_site_id IN NUMBER) IS
733: SELECT email_address
734: FROM hz_contact_points
735: WHERE owner_table_name = 'HZ_PARTY_SITES'
736: AND owner_table_id = p_party_site_id
737: AND contact_point_type = 'EMAIL'
738: AND primary_flag = 'Y'