DBA Data[Home] [Help]

APPS.WSH_IB_TXN_MATCH_PKG dependencies on RCV_TRANSACTIONS

Line 9649: FROM rcv_transactions

9645: SELECT shipment_header_id,
9646: WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT txn_type,
9647: sum(nvl(quantity,0)) shp_rcv_qty,
9648: max(transaction_id) max_rcv_txn_id
9649: FROM rcv_transactions
9650: WHERE po_header_id = p_po_header_id
9651: AND po_release_id = nvl(p_po_release_id,po_release_id) -- bug 5639624
9652: AND transaction_type IN ( 'RECEIVE','MATCH')
9653: GROUP BY shipment_header_id

Line 9660: FROM rcv_transactions

9656: --
9657: CURSOR rcv_txns_csr (p_po_header_id NUMBER, p_rcv_header_id NUMBER, p_po_release_id NUMBER)
9658: IS
9659: SELECT 1
9660: FROM rcv_transactions
9661: WHERE po_header_id = p_po_header_id
9662: AND po_release_id = nvl(p_po_release_id,po_release_id) -- bug 5639624
9663: AND shipment_header_id = p_rcv_header_id
9664: AND transaction_type = 'MATCH'