DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 7141: -- with MTL_TRANSACTION_LOT_NUMBERS

7137:
7138: -- Cursor that gets all unit txn
7139: -- for delivery detail id. If the item is lot controlled
7140: -- and serial controlled item then need to join
7141: -- with MTL_TRANSACTION_LOT_NUMBERS
7142: Cursor MTL_UNIT_LOT_TXN ( p_del_line_id in number,p_txn_src_id in number ) is
7143: select
7144: mut.subinventory_code,
7145: mut.locator_id,

Line 7148: from MTL_TRANSACTION_LOT_NUMBERS mln,

7144: mut.subinventory_code,
7145: mut.locator_id,
7146: mut.serial_number,
7147: mtl.transaction_id
7148: from MTL_TRANSACTION_LOT_NUMBERS mln,
7149: mtl_unit_transactions mut,
7150: mtl_material_transactions mtl
7151: WHERE MLN.SERIAL_TRANSACTION_ID = mut.transaction_id
7152: and mln.transaction_id = mtl.transaction_id