APPS.OE_DS_PVT dependencies on RCV_LOT_TRANSACTIONS

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

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

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

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

Line 449: FROM rcv_lot_transactions rl,

445: ,NVL( rl.quantity, -1)
446: ,rl.secondary_quantity -- OPM
447: -- ,rl.sublot_num -- OPM
448: ,rt.transaction_id
449: FROM rcv_lot_transactions rl,
450: rcv_transactions rt
451: WHERE rt.transaction_id = l_transaction_id
452: AND rl.transaction_id (+) = rt.transaction_id;
453:

Line 804: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there

800: from the main dropshipreceive function, to decrement
801: inventory in the system.
802: This API is called in a loop from the DropShipReceive
803: function. The receiving transactions are stored in
804: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
805: are lot level transactions). This API will be called only
806: once (for the record in RCV_TRANSACTIONS) if not lots are
807: associated. If there are multiple lots in the transaction,
808: it will be called for every lot.