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_INSERT_WDTH_PVT dependencies on WMS_DISPATCHED_TASKS

Line 79: INSERT INTO wms_dispatched_tasks_history

75: );
76: END IF;
77:
78: IF (p_orig_transaction_temp_id IS NULL OR p_orig_transaction_temp_id = p_transaction_temp_id) THEN --Bug12812580
79: INSERT INTO wms_dispatched_tasks_history
80: ( task_id
81: , transaction_id
82: , organization_id
83: , transaction_batch_id

Line 171: FROM wms_dispatched_tasks wdt

167: ,mmtt.transaction_quantity --ER13869750
168: ,mmtt.transaction_UOM --ER13869750
169: ,mmtt.secondary_transaction_quantity --ER13869750
170: ,substr(mmtt.secondary_uom_code,1,3) --ER13869750
171: FROM wms_dispatched_tasks wdt
172: , mtl_material_transactions_temp mmtt
173: WHERE wdt.transaction_temp_id = p_transaction_temp_id
174: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
175: );

Line 179: INSERT INTO wms_dispatched_tasks_history

175: );
176:
177: ELSE --Bug12812580
178:
179: INSERT INTO wms_dispatched_tasks_history
180: ( task_id
181: , transaction_id
182: , organization_id
183: , transaction_batch_id

Line 226: (SELECT Nvl(wdt.task_id, wms_dispatched_tasks_s.NEXTVAL)

222: ,transaction_uom_code --ER13869750
223: ,secondary_transaction_quantity --ER13869750
224: ,secondary_transaction_uom_code --ER13869750
225: )
226: (SELECT Nvl(wdt.task_id, wms_dispatched_tasks_s.NEXTVAL)
227: , p_txn_header_id
228: , Nvl(wdt.organization_id, wdt_orig.organization_id)
229: , p_transaction_batch_id
230: , p_transaction_batch_seq

Line 271: FROM wms_dispatched_tasks wdt

267: ,mmtt.transaction_quantity --ER13869750
268: ,mmtt.transaction_UOM --ER13869750
269: ,mmtt.secondary_transaction_quantity --ER13869750
270: ,substr(mmtt.secondary_uom_code,1,3) --ER13869750
271: FROM wms_dispatched_tasks wdt
272: , mtl_material_transactions_temp mmtt
273: , wms_dispatched_tasks wdt_orig
274: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
275: AND mmtt.transaction_temp_id = wdt.transaction_temp_id (+)

Line 273: , wms_dispatched_tasks wdt_orig

269: ,mmtt.secondary_transaction_quantity --ER13869750
270: ,substr(mmtt.secondary_uom_code,1,3) --ER13869750
271: FROM wms_dispatched_tasks wdt
272: , mtl_material_transactions_temp mmtt
273: , wms_dispatched_tasks wdt_orig
274: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
275: AND mmtt.transaction_temp_id = wdt.transaction_temp_id (+)
276: AND wdt_orig.transaction_temp_id = p_orig_transaction_temp_id
277: );