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 242: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

238: , msi.primary_uom_code
239: , msi.replenish_to_order_flag
240: , msi.bom_item_type
241: , msi.secondary_uom_code --INVCONV kkillams
242: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
243: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
244: AND msi.inventory_item_id = mmtt.inventory_item_id
245: AND msi.organization_id = mmtt.organization_id;
246:

Line 271: FROM mtl_material_transactions_temp

267: reservation_id*/
268: BEGIN
269: SELECT SUM(ABS(primary_quantity))
270: INTO l_mmtt_primary_qty_sum
271: FROM mtl_material_transactions_temp
272: WHERE reservation_id= l_mmtt_info.reservation_id;
273: EXCEPTION
274: WHEN OTHERS THEN
275: RAISE fnd_api.g_exc_unexpected_error;

Line 408: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

404:
405: CURSOR c_mmtt_info IS
406: SELECT mmtt.transaction_header_id, mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom, msi.primary_uom_code
407: , msi.secondary_uom_code --INVCONV kkillams
408: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
409: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
410: AND msi.inventory_item_id = mmtt.inventory_item_id
411: AND msi.organization_id = mmtt.organization_id;
412:

Line 999: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

995: , mmtt.locator_id
996: , mmtt.transaction_uom
997: , msi.primary_uom_code
998: , msi.secondary_uom_code --INVCONV kkillams
999: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
1000: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1001: AND msi.inventory_item_id = mmtt.inventory_item_id
1002: AND msi.organization_id = mmtt.organization_id;
1003:

Line 1114: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1110: GROUP BY mtlt.lot_number
1111: UNION ALL
1112: SELECT mmtt.transaction_temp_id, mtlt.lot_number, SUM(mtlt.transaction_quantity), SUM(mtlt.primary_quantity)
1113: ,DECODE(SUM(NVL(mtlt.secondary_quantity,0)),0,NULL,SUM(NVL(mtlt.secondary_quantity,0))) --INVCONV kkillams
1114: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1115: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1116: AND mmtt.move_order_line_id = p_mo_line_id
1117: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1118: GROUP BY mmtt.transaction_temp_id, mtlt.lot_number;

Line 1166: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

1162: WHERE p_transaction_temp_id IS NOT NULL
1163: AND msn.group_mark_id = p_transaction_temp_id
1164: UNION ALL
1165: SELECT mmtt.transaction_temp_id, msn.serial_number
1166: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
1167: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1168: AND mmtt.move_order_line_id = p_mo_line_id
1169: AND msn.group_mark_id = mmtt.transaction_temp_id;
1170:

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

1204: AND mtlt.transaction_temp_id = p_transaction_temp_id
1205: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1206: UNION ALL
1207: SELECT mmtt.transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1208: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1209: WHERE p_transaction_temp_id IS NULL and p_mo_line_id IS NOT NULL
1210: AND mmtt.move_order_line_id = p_mo_line_id
1211: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1212: AND msn.group_mark_id = mtlt.serial_transaction_temp_id;

Line 1493: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;

1489: print_debug('Confirmed_quantity = ' || p_confirmed_quantity, l_api_name, g_info);
1490: END IF;
1491:
1492: SELECT inventory_item_id, organization_id INTO l_inventory_item_id,l_organization_id
1493: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;
1494:
1495: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items
1496: WHERE inventory_item_id =l_inventory_item_id
1497: AND organization_id =l_organization_id;

Line 1521: UPDATE mtl_material_transactions_temp SET transaction_quantity =p_confirmed_quantity

1517: ELSE
1518: l_confirmed_quantity_primary:=p_confirmed_quantity;
1519: END IF;
1520:
1521: UPDATE mtl_material_transactions_temp SET transaction_quantity =p_confirmed_quantity
1522: , primary_quantity= l_confirmed_quantity_primary
1523: --INVCONV kkillams
1524: , secondary_uom_code = p_secondary_uom_code
1525: , secondary_transaction_quantity = p_sec_confirmed_quantity