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 655: /* Patchset I: Locations Project. Joining with wsh_locations_hz_v */

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

Line 661: wsh_locations_hz_v wlhz

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

Line 846: WSH_LOCATIONS WL1

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