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_TASK_DISPATCH_ENGINE dependencies on WMS_ORDERED_TASKS

Line 4172: INSERT INTO wms_ordered_tasks

4168: END IF;
4169:
4170: l_progress := '72';
4171:
4172: INSERT INTO wms_ordered_tasks
4173: (task_id,
4174: wms_task_type,
4175: task_sequence_id,
4176: subinventory_code,

Line 4276: FROM wms_ordered_tasks

4272: effective_end_date,
4273: person_resource_id,
4274: machine_resource_id,
4275: move_order_line_id
4276: FROM wms_ordered_tasks
4277: ORDER BY task_sequence_id;
4278:
4279: l_progress := '120';
4280: EXCEPTION

Line 6954: INSERT INTO wms_ordered_tasks

6950: END IF;
6951:
6952: l_progress := '72';
6953:
6954: INSERT INTO wms_ordered_tasks
6955: (
6956: task_id
6957: , wms_task_type
6958: , task_sequence_id

Line 7018: INSERT INTO wms_ordered_tasks

7014: END IF;
7015:
7016: l_progress := '74';
7017:
7018: INSERT INTO wms_ordered_tasks
7019: (
7020: task_id
7021: , wms_task_type
7022: , task_sequence_id

Line 7097: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

7093: , mmtt.transaction_quantity transaction_quantity
7094: , '' lot_number
7095: , mmtt.wms_task_type wms_task_type_id
7096: , mmtt.task_priority task_priority
7097: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
7098: WHERE mmtt.wms_task_type IS NOT NULL
7099: AND mmtt.transaction_status = 2
7100: AND mmtt.transaction_temp_id = wot.task_id
7101: AND mmtt.transaction_temp_id > 0

Line 7114: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot

7110: , TO_NUMBER(NULL) transaction_quantity
7111: , MIN(mcce.lot_number) lot_number
7112: , 3 wms_task_type_id
7113: , MIN(mcce.task_priority) task_priority
7114: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot
7115: WHERE mcce.entry_status_code IN(1, 3)
7116: AND NVL(mcce.export_flag, 2) = 2
7117: -- bug 3972076
7118: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 10418: INSERT INTO wms_ordered_tasks

10414: IF G_CURRENT_RELEASE_LEVEL >= G_J_RELEASE_LEVEL THEN
10415: IF (l_debug = 1) THEN
10416: print_debug('Insert task '||t_opt_task_id(idx)||' Effective start date'||t_effective_start_date(idx),4);
10417: END IF;
10418: INSERT INTO wms_ordered_tasks
10419: (
10420: task_id
10421: , wms_task_type
10422: , task_sequence_id

Line 10438: INSERT INTO wms_ordered_tasks

10434: , t_person_resource_id(idx)
10435: , t_machine_resource_id(idx)
10436: );
10437: ELSE -- before patchset J
10438: INSERT INTO wms_ordered_tasks
10439: (
10440: task_id
10441: , wms_task_type
10442: , task_sequence_id

Line 10494: INSERT INTO wms_ordered_tasks

10490: IF (l_debug = 1) THEN
10491: print_debug('Insert task '||t_opt_task_id(idx)||' Effective start date'||
10492: t_effective_start_date(idx),4);
10493: END IF;
10494: INSERT INTO wms_ordered_tasks
10495: (
10496: task_id
10497: , wms_task_type
10498: , task_sequence_id

Line 10514: INSERT INTO wms_ordered_tasks

10510: , t_person_resource_id(idx)
10511: , t_machine_resource_id(idx)
10512: );
10513: ELSE -- before patchset J
10514: INSERT INTO wms_ordered_tasks
10515: (
10516: task_id
10517: , wms_task_type
10518: , task_sequence_id

Line 10665: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot

10661: wot.effective_end_date,
10662: wot.person_resource_id,
10663: wot.machine_resource_id,
10664: mmtt.move_order_line_id
10665: FROM mtl_material_transactions_temp mmtt, wms_ordered_tasks wot
10666: WHERE mmtt.wms_task_type IS NOT NULL
10667: AND mmtt.transaction_status = 2
10668: AND mmtt.transaction_temp_id = wot.task_id
10669: AND mmtt.transaction_temp_id > 0