APPS.INV_GENEALOGY_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1375: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1371: CURSOR childlotmmtt(p_transaction_source_id NUMBER, p_completion_transaction_id NUMBER) IS
1372: SELECT mtlt.lot_number
1373: , mmtt.organization_id
1374: , mmtt.inventory_item_id
1375: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1376: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
1377: AND mmtt.transaction_source_id = p_transaction_source_id
1378: AND mmtt.completion_transaction_id = p_completion_transaction_id
1379: AND mmtt.transaction_action_id = l_transaction_action_id

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

Line 1499: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1495: CLOSE childlotmmtt;
1496:
1497: SELECT COUNT(*)
1498: INTO l_count
1499: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1500: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
1501: AND mmtt.transaction_source_id = p_transaction_source_id
1502: AND mmtt.transaction_action_id = l_transaction_action_id
1503: AND mmtt.transaction_source_type_id = l_transaction_source_type_id