APPS.OE_DS_PVT dependencies on RCV_LOT_TRANSACTIONS

Line 86: If there are records in RCV_LOT_TRANSACTIONS, fetch them

82: Procedure Name : DropShipment Receiving
83: Description : This callback function is called from PO receiving function
84: for non-inventory items and INV for inventory items.
85: Fetch the record from RCV_TRANSACTIONS.
86: If there are records in RCV_LOT_TRANSACTIONS, fetch them
87: in a loop.
88: For each record in RCV_LOT_TRANSACTIONS (or for the one
89: record in RCV_TRANSACTIONS):
90: 1. If the application is INV, call decrement inventory

Line 88: For each record in RCV_LOT_TRANSACTIONS (or for the one

84: for non-inventory items and INV for inventory items.
85: Fetch the record from RCV_TRANSACTIONS.
86: If there are records in RCV_LOT_TRANSACTIONS, fetch them
87: in a loop.
88: For each record in RCV_LOT_TRANSACTIONS (or for the one
89: record in RCV_TRANSACTIONS):
90: 1. If the application is INV, call decrement inventory
91: 2. Compute the quantity shipped.
92:

Line 458: FROM rcv_lot_transactions rl,

454: ,rl.secondary_quantity -- OPM
455: -- ,rl.sublot_num -- OPM
456: ,rt.transaction_id
457: ,Nvl(rl.primary_quantity,0) -- 12794393
458: FROM rcv_lot_transactions rl,
459: rcv_transactions rt
460: WHERE rt.transaction_id = l_transaction_id
461: AND rl.transaction_id (+) = rt.transaction_id;
462:

Line 829: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there

825: from the main dropshipreceive function, to decrement
826: inventory in the system.
827: This API is called in a loop from the DropShipReceive
828: function. The receiving transactions are stored in
829: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
830: are lot level transactions). This API will be called only
831: once (for the record in RCV_TRANSACTIONS) if not lots are
832: associated. If there are multiple lots in the transaction,
833: it will be called for every lot.