APPS.WSH_IB_TXN_MATCH_PKG dependencies on RCV_SHIPMENT_LINES

Line 6059: FROM rcv_shipment_lines

6055: p_shipment_line_id IN NUMBER
6056: )
6057: IS
6058: SELECT quantity_received
6059: FROM rcv_shipment_lines
6060: WHERE shipment_line_id = p_shipment_line_id;
6061: --
6062: --
6063: --

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 9690: FROM rcv_shipment_lines rsl

9686: --
9687: CURSOR asn_csr (p_rcv_header_id NUMBER)
9688: IS
9689: select 1
9690: FROM rcv_shipment_lines rsl
9691: WHERE rsl.shipment_header_id = p_rcv_header_id
9692: AND rsl.shipment_line_status_code = 'CANCELLED'
9693: AND rownum = 1;
9694: --