eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_GENEALOGY_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1395: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1391: CURSOR childlotmmtt(p_transaction_source_id NUMBER, p_completion_transaction_id NUMBER) IS
1392: SELECT mtlt.lot_number
1393: , mmtt.organization_id
1394: , mmtt.inventory_item_id
1395: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1396: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
1397: AND mmtt.transaction_source_id = p_transaction_source_id
1398: AND mmtt.completion_transaction_id = p_completion_transaction_id
1399: AND mmtt.transaction_action_id = l_transaction_action_id

Line 1519: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1515: CLOSE childlotmmtt;
1516:
1517: SELECT COUNT(*)
1518: INTO l_count
1519: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1520: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
1521: AND mmtt.transaction_source_id = p_transaction_source_id
1522: AND mmtt.transaction_action_id = l_transaction_action_id
1523: AND mmtt.transaction_source_type_id = l_transaction_source_type_id