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

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

Line 844: WSH_LOCATIONS WL1

840: HZ_CUST_ACCT_SITES_ALL HCAS,
841: HZ_PARTY_SITES HPS,
842: HZ_CUST_ACCOUNTS HCA,
843: HZ_PARTIES HP,
844: WSH_LOCATIONS WL1
845: WHERE
846: WL1.wsh_location_id = p_loc_id AND
847: HCA.CUST_ACCOUNT_ID = p_cust_id AND --bugfix 3842898
848: (HCAS.ORG_ID IS NULL OR HCAS.ORG_ID = p_org_id) AND