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_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 30: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

26: , p_mo_line_id NUMBER
27: ) IS
28: CURSOR c_item_controls IS
29: SELECT msi.lot_control_code, msi.serial_number_control_code
30: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
31: WHERE p_transaction_temp_id IS NOT NULL
32: AND mmtt.transaction_temp_id = p_transaction_temp_id
33: AND msi.inventory_item_id = mmtt.inventory_item_id
34: AND msi.organization_id = mmtt.organization_id

Line 245: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

241: , mmtt.lot_number -- 9758641
242: , msi.tracking_quantity_ind -- 9758641
243: , mmtt.move_order_line_id -- 9896283
244: , msi.secondary_uom_code --INVCONV kkillams
245: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
246: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
247: AND msi.inventory_item_id = mmtt.inventory_item_id
248: AND msi.organization_id = mmtt.organization_id;
249:

Line 292: FROM mtl_material_transactions_temp

288: BEGIN
289: SELECT SUM(ABS(primary_quantity)), SUM(ABS(NVL(secondary_transaction_quantity, 0)))
290: INTO l_mmtt_primary_qty_sum,
291: l_mmtt_secondary_qty_sum
292: FROM mtl_material_transactions_temp
293: WHERE reservation_id= l_mmtt_info.reservation_id;
294: EXCEPTION
295: WHEN OTHERS THEN
296: RAISE fnd_api.g_exc_unexpected_error;

Line 491: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

487:
488: CURSOR c_mmtt_info IS
489: SELECT mmtt.transaction_header_id, mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom, msi.primary_uom_code
490: , msi.secondary_uom_code --INVCONV kkillams
491: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
492: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
493: AND msi.inventory_item_id = mmtt.inventory_item_id
494: AND msi.organization_id = mmtt.organization_id;
495:

Line 1146: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

1142: , mmtt.locator_id
1143: , mmtt.transaction_uom
1144: , msi.primary_uom_code
1145: , msi.secondary_uom_code --INVCONV kkillams
1146: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
1147: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1148: AND msi.inventory_item_id = mmtt.inventory_item_id
1149: AND msi.organization_id = mmtt.organization_id;
1150:

Line 1261: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1257: GROUP BY mtlt.lot_number
1258: UNION ALL
1259: SELECT mmtt.transaction_temp_id, mtlt.lot_number, SUM(mtlt.transaction_quantity), SUM(mtlt.primary_quantity)
1260: ,DECODE(SUM(NVL(mtlt.secondary_quantity,0)),0,NULL,SUM(NVL(mtlt.secondary_quantity,0))) --INVCONV kkillams
1261: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1262: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1263: AND mmtt.move_order_line_id = p_mo_line_id
1264: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1265: GROUP BY mmtt.transaction_temp_id, mtlt.lot_number;

Line 1313: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

1309: WHERE p_transaction_temp_id IS NOT NULL
1310: AND msn.group_mark_id = p_transaction_temp_id
1311: UNION ALL
1312: SELECT mmtt.transaction_temp_id, msn.serial_number
1313: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
1314: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1315: AND mmtt.move_order_line_id = p_mo_line_id
1316: AND msn.group_mark_id = mmtt.transaction_temp_id;
1317:

Line 1355: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1351: AND mtlt.transaction_temp_id = p_transaction_temp_id
1352: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1353: UNION ALL
1354: SELECT mmtt.transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1355: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1356: WHERE p_transaction_temp_id IS NULL and p_mo_line_id IS NOT NULL
1357: AND mmtt.move_order_line_id = p_mo_line_id
1358: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1359: AND msn.group_mark_id = mtlt.serial_transaction_temp_id;

Line 1640: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;

1636: print_debug('Confirmed_quantity = ' || p_confirmed_quantity, l_api_name, g_info);
1637: END IF;
1638:
1639: SELECT inventory_item_id, organization_id INTO l_inventory_item_id,l_organization_id
1640: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;
1641:
1642: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items
1643: WHERE inventory_item_id =l_inventory_item_id
1644: AND organization_id =l_organization_id;

Line 1668: UPDATE mtl_material_transactions_temp SET transaction_quantity =p_confirmed_quantity

1664: ELSE
1665: l_confirmed_quantity_primary:=p_confirmed_quantity;
1666: END IF;
1667:
1668: UPDATE mtl_material_transactions_temp SET transaction_quantity =p_confirmed_quantity
1669: , primary_quantity= l_confirmed_quantity_primary
1670: --INVCONV kkillams
1671: , secondary_uom_code = p_secondary_uom_code
1672: , secondary_transaction_quantity = p_sec_confirmed_quantity