DBA Data[Home] [Help]

APPS.INV_GENEALOGY_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1387: FROM mtl_material_transactions mmtt, mtl_transaction_lot_numbers mtlt

1383: SELECT mtlt.lot_number
1384: , mmtt.organization_id
1385: , mmtt.inventory_item_id
1386: , mmtt.transaction_id
1387: FROM mtl_material_transactions mmtt, mtl_transaction_lot_numbers mtlt
1388: WHERE mmtt.transaction_id = mtlt.transaction_id
1389: AND mmtt.transaction_source_id = p_transaction_source_id
1390: AND mmtt.completion_transaction_id = p_completion_transaction_id
1391: AND mmtt.transaction_action_id = l_transaction_action_id