DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on RCV_TRANSACTIONS

Line 63: FROM rcv_transactions rt

59: CURSOR rcv_txn_cur IS
60: SELECT rt.transaction_id
61: , rt.unit_of_measure
62: , lt.matching_basis
63: FROM rcv_transactions rt
64: , rcv_shipment_headers sh
65: , po_lines pl
66: , po_line_types lt
67: WHERE sh.receipt_source_code = 'VENDOR'

Line 132: -- WE match here in a cascading manner, we pick up all rcv_transactions in order

128: ---------------------------------------------------------------------------------
129: -- If cascade flag = 'Y' then get the rcv_transaction ids from the cursor,
130: -- For each line fetched , get the unbilled quantity and amount to be matched
131: -- and call the receipt matching pkg to do the match at the shipment level.
132: -- WE match here in a cascading manner, we pick up all rcv_transactions in order
133: -- of the date (earliest - first , most recent -last) and match the p_quantity
134: -- to the unbilled quantity on each rcv transaction
135: -- Bill positive quantities
136: ---------------------------------------------------------------------------------