DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 317: mtl_transaction_lot_numbers mtln,

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

Line 2245: FROM mtl_transaction_lot_numbers mtln,

2241: UNION
2242: SELECT mut.serial_number serial_number,
2243: mtln.lot_number lot_number,
2244: 1 quantity
2245: FROM mtl_transaction_lot_numbers mtln,
2246: mtl_unit_transactions mut
2247: WHERE mtln.transaction_id = p_mtl_txn_id
2248: AND mut.transaction_id = mtln.serial_transaction_id;
2249: