DBA Data[Home] [Help]

APPS.INV_GENEALOGY_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1407: FROM mtl_material_transactions mmtt, mtl_transaction_lot_numbers mtlt

1403: SELECT mtlt.lot_number
1404: , mmtt.organization_id
1405: , mmtt.inventory_item_id
1406: , mmtt.transaction_id
1407: FROM mtl_material_transactions mmtt, mtl_transaction_lot_numbers mtlt
1408: WHERE mmtt.transaction_id = mtlt.transaction_id
1409: AND mmtt.transaction_source_id = p_transaction_source_id
1410: AND mmtt.completion_transaction_id = p_completion_transaction_id
1411: AND mmtt.transaction_action_id = l_transaction_action_id