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.WSH_MAPPING_DATA dependencies on WSH_LOCATIONS_HZ_V

Line 653: /* Patchset I: Locations Project. Joining with wsh_locations_hz_v */

649: x_fax OUT NOCOPY VARCHAR2,
650: x_url OUT NOCOPY VARCHAR2,
651: x_return_status OUT NOCOPY VARCHAR2) IS
652:
653: /* Patchset I: Locations Project. Joining with wsh_locations_hz_v */
654: CURSOR phone_fax_cur(l_line_type VARCHAR2) IS
655: SELECT hcp.raw_phone_number,
656: hcp.url
657: FROM hz_party_sites hps,

Line 659: wsh_locations_hz_v wlhz

655: SELECT hcp.raw_phone_number,
656: hcp.url
657: FROM hz_party_sites hps,
658: hz_contact_points hcp,
659: wsh_locations_hz_v wlhz
660: WHERE HCP.CONTACT_POINT_TYPE = 'PHONE'
661: AND HCP.PHONE_LINE_TYPE=l_line_type
662: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
663: AND HPS.PARTY_SITE_ID = HCP.OWNER_TABLE_ID