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 2234: mtl_material_transactions_temp

2230: ,transaction_uom
2231: ,secondary_transaction_quantity
2232: ,secondary_uom_code
2233: FROM
2234: mtl_material_transactions_temp
2235: WHERE
2236: ( move_order_line_id = l_mo_splt_tb(1).line_id AND
2237: ( ( transaction_source_type_id = 1 AND
2238: transaction_action_id = 27) OR

Line 2500: FROM mtl_material_transactions_temp mmtt,

2496: SELECT 1
2497: INTO l_xfer_lpn_loaded
2498: FROM dual
2499: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_N2) */ 'LOADED'
2500: FROM mtl_material_transactions_temp mmtt,
2501: wms_dispatched_tasks wdt
2502: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2503: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2504: AND wdt.organization_id = l_tmp_mmtt_rec.organization_id

Line 2792: mtl_material_transactions_temp

2788: ,transaction_uom
2789: ,secondary_transaction_quantity
2790: ,secondary_uom_code
2791: FROM
2792: mtl_material_transactions_temp
2793: WHERE
2794: ( move_order_line_id = l_mo_splt_tb(1).line_id AND
2795: ( ( transaction_source_type_id = 1 AND
2796: transaction_action_id = 27) OR

Line 3050: DELETE FROM mtl_material_transactions_temp

3046: END;
3047:
3048: BEGIN
3049: forall i IN 1 .. l_mmtts_count
3050: DELETE FROM mtl_material_transactions_temp
3051: WHERE transaction_temp_id = l_mmtt_ids(i);
3052: IF (l_debug = 1) THEN
3053: print_debug('# OF MMTT DELETED: ' || SQL%rowcount);
3054: END IF;