DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 315: mtl_transaction_lot_numbers mtln,

311: mmt.transaction_action_id mtl_action_id,
312: mmt.transaction_source_type_id mtl_src_type_id,
313: mmt.ship_to_location_id location_id
314: FROM mtl_unit_transactions mut,
315: mtl_transaction_lot_numbers mtln,
316: mtl_material_transactions mmt
317: WHERE mut.serial_number = p_serial_number
318: AND mut.inventory_item_id = p_item_id
319: AND mtln.organization_id = mut.organization_id

Line 2089: FROM mtl_transaction_lot_numbers mtln,

2085: UNION
2086: SELECT mut.serial_number serial_number,
2087: mtln.lot_number lot_number,
2088: 1 quantity
2089: FROM mtl_transaction_lot_numbers mtln,
2090: mtl_unit_transactions mut
2091: WHERE mtln.transaction_id = p_mtl_txn_id
2092: AND mut.transaction_id = mtln.serial_transaction_id;
2093: