DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 7433: -- with MTL_TRANSACTION_LOT_NUMBERS

7429:
7430: -- Cursor that gets all unit txn
7431: -- for delivery detail id. If the item is lot controlled
7432: -- and serial controlled item then need to join
7433: -- with MTL_TRANSACTION_LOT_NUMBERS
7434: Cursor MTL_UNIT_LOT_TXN ( p_del_line_id in number,p_txn_src_id in number ) is
7435: select
7436: mut.subinventory_code,
7437: mut.locator_id,

Line 7440: from MTL_TRANSACTION_LOT_NUMBERS mln,

7436: mut.subinventory_code,
7437: mut.locator_id,
7438: mut.serial_number,
7439: mtl.transaction_id
7440: from MTL_TRANSACTION_LOT_NUMBERS mln,
7441: mtl_unit_transactions mut,
7442: mtl_material_transactions mtl
7443: WHERE MLN.SERIAL_TRANSACTION_ID = mut.transaction_id
7444: and mln.transaction_id = mtl.transaction_id