APPS.WSH_IB_TXN_MATCH_PKG dependencies on WSH_LOCATIONS

Line 6097: FROM wsh_locations

6093: -- { IB-Phase-2
6094: CURSOR get_wsh_location_csr (p_hz_location_id NUMBER)
6095: IS
6096: SELECT wsh_location_id
6097: FROM wsh_locations
6098: WHERE source_location_id = p_hz_location_id
6099: AND location_source_code = 'HZ' ;
6100: -- } IB-Phase-2
6101: --

Line 9680: wsh_locations wloc

9676: rsh.ORGANIZATION_ID,
9677: rsh.asn_type,
9678: wloc.wsh_location_id -- IB-Phase-2
9679: FROM rcv_fte_headers_v rsh,
9680: wsh_locations wloc
9681: WHERE rsh.shipment_header_id = p_rcv_header_id
9682: AND rsh.ship_from_location_id = wloc.source_location_id(+); -- IB-Phase-2
9683: --
9684: rcv_header_rec rcv_header_csr%ROWTYPE;