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_TZ_GET_DETAILS_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 630: FROM hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c

626:
627: -- Cursor to derive time zone for Primary Contact address
628: CURSOR contact_timezone IS
629: SELECT b.timezone_id
630: FROM hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c
631: WHERE a.party_id = c.party_id
632: AND a.identifying_address_flag = 'Y'
633: AND c.primary_flag = 'Y'
634: AND a.location_id = b.location_id

Line 640: FROM hz_contact_points a, cs_hz_sr_contact_points b

636:
637: -- Cursor to derive time zone for Primary Contact phone
638: CURSOR contact_cont_point_tz IS
639: SELECT a.timezone_id
640: FROM hz_contact_points a, cs_hz_sr_contact_points b
641: WHERE a.owner_table_id = b.party_id
642: AND a.contact_point_type = b.contact_point_type
643: AND b.contact_point_type = 'PHONE'
644: AND a.primary_flag = b.primary_flag