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.WMS_RCV_PUP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 763: mtl_material_transactions_temp

759: transaction_temp_id
760: BULK COLLECT INTO
761: l_txn_tmp_id_tb
762: FROM
763: mtl_material_transactions_temp
764: WHERE
765: ( move_order_line_id = p_move_order_line_id AND
766: ( ( transaction_source_type_id = 1 AND
767: transaction_action_id = 27) OR

Line 799: mtl_material_transactions_temp mmtt,

795: mmtt.transaction_temp_id
796: BULK COLLECT INTO
797: l_txn_tmp_id_tb
798: FROM
799: mtl_material_transactions_temp mmtt,
800: mtl_txn_request_lines mtrl
801: WHERE
802: ( ( mmtt.transaction_source_type_id = 1 AND
803: mmtt.transaction_action_id = 27) OR

Line 992: mtl_material_transactions_temp mmtt,

988: mmtt.secondary_uom_code secondary_uom_code,
989: mmtt.secondary_transaction_quantity secondary_transaction_quantity
990: -- OPM Convergance
991: FROM
992: mtl_material_transactions_temp mmtt,
993: mtl_system_items msi
994: WHERE
995: l_header_id = mmtt.transaction_header_id AND
996: mmtt.inventory_item_id = msi.inventory_item_id (+) AND

Line 1065: mtl_material_transactions_temp mmtt,

1061: mmtt.secondary_uom_code secondary_uom_code,
1062: mmtt.secondary_transaction_quantity secondary_transaction_quantity
1063: -- OPM Convergance
1064: FROM
1065: mtl_material_transactions_temp mmtt,
1066: mtl_system_items msi
1067: WHERE
1068: l_txn_id = mmtt.transaction_temp_id AND
1069: mmtt.inventory_item_id = msi.inventory_item_id (+) AND

Line 2276: mtl_material_transactions_temp

2272: ,transaction_uom
2273: ,secondary_transaction_quantity
2274: ,secondary_uom_code
2275: FROM
2276: mtl_material_transactions_temp
2277: WHERE
2278: ( move_order_line_id = l_mo_splt_tb(1).line_id AND
2279: ( ( transaction_source_type_id = 1 AND
2280: transaction_action_id = 27) OR

Line 2544: FROM mtl_material_transactions_temp mmtt,

2540: SELECT 1
2541: INTO l_xfer_lpn_loaded
2542: FROM dual
2543: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_U2) */ 'LOADED' --Bug#8555935 Changed index WMS_DISPATCHED_TASKS_N2 to WMS_DISPATCHED_TASKS_U2
2544: FROM mtl_material_transactions_temp mmtt,
2545: wms_dispatched_tasks wdt
2546: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2547: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2548: AND wdt.organization_id = l_tmp_mmtt_rec.organization_id

Line 2837: mtl_material_transactions_temp

2833: ,transaction_uom
2834: ,secondary_transaction_quantity
2835: ,secondary_uom_code
2836: FROM
2837: mtl_material_transactions_temp
2838: WHERE
2839: ( move_order_line_id = l_mo_splt_tb(1).line_id AND
2840: ( ( transaction_source_type_id = 1 AND
2841: transaction_action_id = 27) OR

Line 3097: DELETE FROM mtl_material_transactions_temp

3093: END;
3094:
3095: BEGIN
3096: forall i IN 1 .. l_mmtts_count
3097: DELETE FROM mtl_material_transactions_temp
3098: WHERE transaction_temp_id = l_mmtt_ids(i);
3099: IF (l_debug = 1) THEN
3100: print_debug('# OF MMTT DELETED: ' || SQL%rowcount);
3101: END IF;