APPS.WSH_IB_TXN_MATCH_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 9639: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

9635: SELECT rsl.shipment_header_id,
9636: WSH_INBOUND_TXN_HISTORY_PKG.C_ASN txn_type,
9637: sum(nvl(DECODE(rsh.asn_type,'ASN',quantity_shipped,'ASBN',quantity_shipped,0),0)) shp_rcv_qty,
9638: 1 max_rcv_txn_id
9639: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
9640: WHERE po_header_id = p_po_header_id
9641: AND po_release_id = nvl(p_po_release_id,po_release_id) -- bug 5639624
9642: AND rsl.shipment_header_id = rsh.shipment_header_id
9643: GROUP BY rsl.shipment_header_id

Line 9699: FROM rcv_shipment_headers rsh

9695: --IB-Phase-2
9696: CURSOR get_hz_location_csr(p_rcv_header_id NUMBER)
9697: IS
9698: select rsh.ship_from_location_id
9699: FROM rcv_shipment_headers rsh
9700: WHERE rsh.shipment_header_id = p_rcv_header_id;
9701: --
9702: l_hzShipFromLocationId NUMBER; --IB-Phase-2
9703: l_po_header_id NUMBER;