DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on RCV_SHIPMENT_HEADERS

Line 601: rcv_shipment_headers rsh ,

597:
598: CURSOR c_pending_receipts(p_po_header_id IN NUMBER) IS
599: SELECT DISTINCT rsh.receipt_num, rsh.creation_date -- Added for the bug 13617899
600: FROM Rcv_Transactions rcv_txn ,
601: rcv_shipment_headers rsh ,
602: PO_Distributions_all po_dist ,
603: rcv_receiving_sub_ledger rcv_sub1
604: WHERE po_dist.po_header_id =p_po_header_id
605: AND rcv_txn.destination_type_code ='EXPENSE'