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

Line 145: SELECT wms_dispatched_tasks_s.NEXTVAL

141: FROM bom_resource_employees
142: WHERE organization_id=l_org_id
143: AND person_id=l_emp_id;
144: */
145: SELECT wms_dispatched_tasks_s.NEXTVAL
146: INTO l_task_id
147: FROM DUAL;
148:
149: INSERT INTO wms_dispatched_tasks

Line 149: INSERT INTO wms_dispatched_tasks

145: SELECT wms_dispatched_tasks_s.NEXTVAL
146: INTO l_task_id
147: FROM DUAL;
148:
149: INSERT INTO wms_dispatched_tasks
150: (
151: task_id
152: , transaction_temp_id
153: , organization_id

Line 338: FROM wms_dispatched_tasks wdt

334:
335: IF l_task_type = 'EXPPICK' THEN
336: SELECT COUNT(*) tsk
337: INTO l_tsks
338: FROM wms_dispatched_tasks wdt
339: WHERE wdt.person_id = l_user_id
340: AND wdt.organization_id = l_org_id
341: AND wdt.task_type IN(1, 3, 4, 5, 6)
342: AND wms_express_pick_task.is_express_pick_task(task_id) = 'S'

Line 372: FROM wms_dispatched_tasks wdt

368: ELSE
369:
370: SELECT count(*) TSK
371: INTO l_tsks
372: FROM wms_dispatched_tasks wdt
373: WHERE wdt.person_id = l_user_id
374: AND wdt.organization_id = l_org_id
375: AND wdt.task_type IN (1, 3, 4, 5, 6)
376: AND wdt.status <= 3

Line 425: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

421: , wdt.priority
422: , wdt.task_id task_id
423: , sub.picking_order sub_picking_order
424: , loc.picking_order loc_picking_order
425: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
426: WHERE wdt.person_id = l_user_id
427: AND wdt.organization_id = l_org_id
428: AND wdt.status <= 3
429: AND wdt.task_type IN (1, 4, 5, 6)

Line 444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

440: , wdt.task_id task_id
441: , sub.picking_order sub_picking_order
442: , loc.picking_order loc_picking_order
443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
445: ,mtl_cycle_count_headers mcch
446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id
448: AND wdt.status <= 3

Line 472: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

468: , wdt.priority
469: , wdt.task_id task_id
470: , sub.picking_order sub_picking_order
471: , loc.picking_order loc_picking_order
472: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
473: WHERE wdt.person_id = l_user_id
474: AND wdt.organization_id = l_org_id
475: AND wdt.status <= 3
476: AND wdt.task_type IN (1, 4, 5, 6)

Line 490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

486: , wdt.task_id task_id
487: , sub.picking_order sub_picking_order
488: , loc.picking_order loc_picking_order
489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
491: , mtl_cycle_count_headers mcch
492: WHERE wdt.person_id = l_user_id
493: AND wdt.organization_id = l_org_id
494: AND wdt.status <= 3

Line 586: FROM wms_dispatched_tasks

582: , device_invoked
583: INTO l_task_id
584: , l_task_type_n
585: , l_device_invoked
586: FROM wms_dispatched_tasks
587: WHERE person_id = l_user_id
588: AND organization_id = l_org_id
589: AND device_id = l_temp_device_id
590: AND task_type IN(1, 3, 4, 5, 6)

Line 615: UPDATE wms_dispatched_tasks

611:
612: -- always dispatch the task whether invoking device successfully or not
613: -- So update the table always
614:
615: UPDATE wms_dispatched_tasks
616: SET device_invoked = 'Y'
617: , device_request_id = l_request_id
618: WHERE transaction_temp_id = l_task_id;
619:

Line 772: -- Insert into WMS_DISPATCHED_TASKS for this user

768: UPDATE mtl_material_transactions_temp
769: SET transaction_header_id = l_txn_hdr_id
770: WHERE transaction_temp_id = task_rec.task_id;
771:
772: -- Insert into WMS_DISPATCHED_TASKS for this user
773:
774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;

Line 774: SELECT wms_dispatched_tasks_s.NEXTVAL

770: WHERE transaction_temp_id = task_rec.task_id;
771:
772: -- Insert into WMS_DISPATCHED_TASKS for this user
773:
774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;
777:
778: INSERT INTO wms_dispatched_tasks

Line 778: INSERT INTO wms_dispatched_tasks

774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;
777:
778: INSERT INTO wms_dispatched_tasks
779: (
780: task_id
781: , transaction_temp_id
782: , organization_id

Line 850: UPDATE wms_dispatched_tasks

846: IF (l_debug = 1) THEN
847: mydebug('next_task: temp_device_id');
848: END IF;
849:
850: UPDATE wms_dispatched_tasks
851: SET device_id = l_temp_device_id
852: , device_invoked = 'N'
853: WHERE task_id = l_next_task_id;
854:

Line 872: UPDATE wms_dispatched_tasks

868: -- always dispatch the task whether invoking device successfully or not
869: -- So update the table always
870:
871:
872: UPDATE wms_dispatched_tasks
873: SET device_invoked = 'Y'
874: , device_request_id = l_request_id
875: WHERE task_id = l_next_task_id;
876:

Line 941: FROM wms_dispatched_tasks

937: l_c_rows := 1; -- to indicate there are tasks already
938:
939: SELECT task_type
940: INTO x_task_type
941: FROM wms_dispatched_tasks
942: WHERE device_id = x_avail_device_id
943: AND device_invoked = 'Y'
944: AND person_id = l_user_id
945: AND status <= 3

Line 1161: FROM wms_dispatched_tasks

1157: , device_invoked
1158: INTO l_task_id
1159: , l_task_type_n
1160: , l_device_invoked
1161: FROM wms_dispatched_tasks
1162: WHERE person_id = l_user_id
1163: AND organization_id = l_org_id
1164: AND device_id = l_temp_device_id
1165: AND task_type IN(1, 3, 4, 5, 6)

Line 1190: UPDATE wms_dispatched_tasks

1186:
1187: -- always dispatch the task whether invoking device successfully or not
1188: -- So update the table always
1189:
1190: UPDATE wms_dispatched_tasks
1191: SET device_invoked = 'Y'
1192: , device_request_id = l_request_id
1193: WHERE transaction_temp_id = l_task_id;
1194:

Line 1328: -- Insert into WMS_DISPATCHED_TASKS for this user

1324: UPDATE mtl_material_transactions_temp
1325: SET transaction_header_id = l_txn_hdr_id
1326: WHERE transaction_temp_id = task_rec.task_id;
1327:
1328: -- Insert into WMS_DISPATCHED_TASKS for this user
1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:

Line 1329: SELECT wms_dispatched_tasks_s.NEXTVAL

1325: SET transaction_header_id = l_txn_hdr_id
1326: WHERE transaction_temp_id = task_rec.task_id;
1327:
1328: -- Insert into WMS_DISPATCHED_TASKS for this user
1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:
1333: INSERT INTO wms_dispatched_tasks

Line 1333: INSERT INTO wms_dispatched_tasks

1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:
1333: INSERT INTO wms_dispatched_tasks
1334: (
1335: task_id
1336: , transaction_temp_id
1337: , organization_id

Line 1405: UPDATE wms_dispatched_tasks

1401: IF (l_debug = 1) THEN
1402: mydebug('next_CP_task: temp_device_id');
1403: END IF;
1404:
1405: UPDATE wms_dispatched_tasks
1406: SET device_id = l_temp_device_id
1407: , device_invoked = 'N'
1408: WHERE task_id = l_next_task_id;
1409:

Line 1427: UPDATE wms_dispatched_tasks

1423: -- always dispatch the task whether invoking device successfully or not
1424: -- So update the table always
1425:
1426:
1427: UPDATE wms_dispatched_tasks
1428: SET device_invoked = 'Y'
1429: , device_request_id = l_request_id
1430: WHERE task_id = l_next_task_id;
1431:

Line 1496: FROM wms_dispatched_tasks

1492: l_c_rows := 1; -- to indicate there are tasks already
1493:
1494: SELECT task_type
1495: INTO x_task_type
1496: FROM wms_dispatched_tasks
1497: WHERE device_id = x_avail_device_id
1498: AND device_invoked = 'Y'
1499: AND person_id = l_user_id
1500: AND status <= 3

Line 5453: UPDATE wms_dispatched_tasks

5449: WHERE transaction_temp_id = l_tabtype(l_counter);
5450:
5451: -- Also update WDT to loaded status
5452:
5453: UPDATE wms_dispatched_tasks
5454: SET status = 4
5455: , loaded_time = SYSDATE
5456: , --loaded_time=to_date(to_char(sysdate,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH:MI:SS'),
5457: last_update_date = SYSDATE

Line 5824: DELETE FROM wms_dispatched_tasks

5820:
5821: DELETE FROM mtl_material_transactions_temp
5822: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5823:
5824: DELETE FROM wms_dispatched_tasks
5825: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5826: END LOOP;
5827:
5828: CLOSE mmtt_csr;

Line 5941: DELETE FROM wms_dispatched_tasks

5937: where line_id = l_move_order_line_id;
5938:
5939: mydebug('load_pick: after updating move order line detailed
5940: quantity');
5941: DELETE FROM wms_dispatched_tasks
5942: WHERE transaction_temp_id = p_temp_id;
5943:
5944:
5945: ELSE

Line 5978: DELETE FROM wms_dispatched_tasks

5974: IF (l_debug = 1) THEN
5975: mydebug('load_pick: archiving task');
5976: END IF;
5977:
5978: DELETE FROM wms_dispatched_tasks
5979: WHERE transaction_temp_id = p_temp_id;
5980: END IF;
5981: END IF;
5982: IF (l_debug = 1) THEN

Line 7800: SELECT wms_dispatched_tasks_s.NEXTVAL

7796:
7797: -- Insert into tasks table
7798:
7799: --Get value from sequence for next task id
7800: SELECT wms_dispatched_tasks_s.NEXTVAL
7801: INTO l_next_task_id
7802: FROM DUAL;
7803:
7804: IF (l_debug = 1) THEN

Line 7808: INSERT INTO wms_dispatched_tasks

7804: IF (l_debug = 1) THEN
7805: mydebug('multiple_lpn_pick: Before Insert into WMSDT');
7806: END IF;
7807:
7808: INSERT INTO wms_dispatched_tasks
7809: (
7810: task_id
7811: , transaction_temp_id
7812: , organization_id

Line 7854: FROM wms_dispatched_tasks

7850: , SYSDATE
7851: , operation_plan_id
7852: , move_order_line_id
7853: --to_date(to_char(sysdate,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH:MI:SS')
7854: FROM wms_dispatched_tasks
7855: WHERE transaction_temp_id = l_temp_id);
7856:
7857: IF (l_debug = 1) THEN
7858: mydebug('multiple_lpn_pick: Update WMSDT as loaded');

Line 9948: SELECT wms_dispatched_tasks_s.NEXTVAL

9944:
9945: l_progress := '400';
9946:
9947: --Get value from sequence for next task id
9948: SELECT wms_dispatched_tasks_s.NEXTVAL
9949: INTO l_next_task_id
9950: FROM DUAL;
9951:
9952: l_progress := '410';

Line 9958: INSERT INTO wms_dispatched_tasks

9954: IF (l_debug = 1) THEN
9955: mydebug('multiple_pick: Before Insert into WMSDT');
9956: END IF;
9957:
9958: INSERT INTO wms_dispatched_tasks
9959: (
9960: task_id
9961: , transaction_temp_id
9962: , organization_id

Line 10004: FROM wms_dispatched_tasks

10000: , SYSDATE
10001: , operation_plan_id
10002: , move_order_line_id
10003: --to_date(to_char(sysdate,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH:MI:SS')
10004: FROM wms_dispatched_tasks
10005: WHERE transaction_temp_id = l_temp_id);
10006: END IF;
10007:
10008: l_progress := '420';

Line 10468: UPDATE wms_dispatched_tasks

10464: IF (l_debug = 1) THEN
10465: mydebug('multiple_pick: Plain item. Update WMSDT as loaded');
10466: END IF;
10467:
10468: UPDATE wms_dispatched_tasks
10469: SET status = 4
10470: , loaded_time = SYSDATE
10471: , --to_date(to_char(sysdate,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH:MI:SS'),
10472: last_update_date = SYSDATE

Line 12770: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t

12766: IF l_mmtt_rowcnt > 0 THEN
12767: -- There are MMTT tasks for this LPN
12768: SELECT COUNT(*)
12769: INTO l_wdt_rowcnt
12770: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t
12771: WHERE m.cartonization_id = l_lpn_id
12772: AND t.transaction_temp_id = m.transaction_temp_id
12773: AND t.status = 4;
12774:

Line 12889: -- Insert into WMS_DISPATCHED_TASKS for this user

12885: UPDATE mtl_material_transactions_temp
12886: SET transaction_header_id = l_txn_hdr_id
12887: WHERE transaction_temp_id = task_rec.task_id;
12888:
12889: -- Insert into WMS_DISPATCHED_TASKS for this user
12890:
12891: --Get value from sequence for next task id
12892: SELECT wms_dispatched_tasks_s.NEXTVAL
12893: INTO l_next_task_id

Line 12892: SELECT wms_dispatched_tasks_s.NEXTVAL

12888:
12889: -- Insert into WMS_DISPATCHED_TASKS for this user
12890:
12891: --Get value from sequence for next task id
12892: SELECT wms_dispatched_tasks_s.NEXTVAL
12893: INTO l_next_task_id
12894: FROM DUAL;
12895:
12896: --mydebug('pick_by_label: Before Insert into WMSDT');

Line 12899: INSERT INTO wms_dispatched_tasks

12895:
12896: --mydebug('pick_by_label: Before Insert into WMSDT');
12897:
12898:
12899: INSERT INTO wms_dispatched_tasks
12900: (
12901: task_id
12902: , transaction_temp_id
12903: , organization_id

Line 13161: FROM wms_dispatched_tasks t

13157: SELECT 1
13158: INTO l_wdt_rowcnt
13159: FROM DUAL
13160: WHERE EXISTS(SELECT 1
13161: FROM wms_dispatched_tasks t
13162: WHERE t.transaction_temp_id = l_pick_slip_id);
13163: EXCEPTION
13164: WHEN NO_DATA_FOUND THEN
13165: l_wdt_rowcnt := 0;

Line 13246: -- Insert into WMS_DISPATCHED_TASKS for this user

13242: RAISE fnd_api.g_exc_error;
13243: END;
13244: END IF;
13245:
13246: -- Insert into WMS_DISPATCHED_TASKS for this user
13247:
13248: --Get value from sequence for next task id
13249: SELECT wms_dispatched_tasks_s.NEXTVAL
13250: INTO l_next_task_id

Line 13249: SELECT wms_dispatched_tasks_s.NEXTVAL

13245:
13246: -- Insert into WMS_DISPATCHED_TASKS for this user
13247:
13248: --Get value from sequence for next task id
13249: SELECT wms_dispatched_tasks_s.NEXTVAL
13250: INTO l_next_task_id
13251: FROM DUAL;
13252:
13253: --mydebug('manual_pick: Before Insert into WMSDT');

Line 13336: INSERT INTO wms_dispatched_tasks

13332: END ;
13333: END IF;
13334: --Bug6009436.End
13335:
13336: INSERT INTO wms_dispatched_tasks
13337: (
13338: task_id
13339: , transaction_temp_id
13340: , organization_id

Line 13449: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t

13445: IF l_mmtt_rowcnt > 0 THEN
13446: -- There are MMTT tasks for this LPN
13447: SELECT COUNT(*)
13448: INTO l_wdt_rowcnt
13449: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t
13450: WHERE m.cartonization_id = l_lpn_id
13451: AND t.transaction_temp_id = m.transaction_temp_id
13452: AND t.status = 4;
13453:

Line 13704: DELETE FROM wms_dispatched_tasks

13700: BEGIN
13701: DELETE FROM mtl_material_transactions_temp
13702: WHERE transaction_temp_id = p_temp_id;
13703:
13704: DELETE FROM wms_dispatched_tasks
13705: WHERE transaction_temp_id = p_temp_id;
13706:
13707: IF p_lot_control_code > 1 THEN
13708:

Line 13985: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

13981: FETCH c_mo_line_info INTO l_mo_type, l_mol_src_id, l_mol_src_line_id, l_mol_reference_id, l_mol_qty, l_mol_qty_delivered;
13982: CLOSE c_mo_line_info;
13983: */
13984: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN
13985: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
13986:
13987: /*bug3139307 suggest_alternate_location API in wms_txnrsn_actions_pub
13988: would call INV_Replenish_Detail_PUB.Line_Details_PUB . When there is
13989: no quantity to allocate the sales order would be automatically

Line 15316: INSERT INTO wms_dispatched_tasks

15312: mydebug('Dispatching Child Tasks');
15313: END IF;
15314:
15315: -- Dispatching Picked Child Tasks
15316: INSERT INTO wms_dispatched_tasks
15317: (
15318: task_id
15319: , transaction_temp_id
15320: , organization_id

Line 15340: (SELECT wms_dispatched_tasks_s.NEXTVAL

15336: , loaded_time
15337: , operation_plan_id
15338: , move_order_line_id
15339: )
15340: (SELECT wms_dispatched_tasks_s.NEXTVAL
15341: , mmtt.transaction_temp_id
15342: , mmtt.organization_id
15343: , wdt.user_task_type
15344: , wdt.person_id

Line 15361: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

15357: , wdt.task_type
15358: , SYSDATE
15359: , mmtt.operation_plan_id
15360: , mmtt.move_order_line_id
15361: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
15362: WHERE wdt.transaction_temp_id = p_temp_id
15363: AND mmtt.transaction_header_id = x_new_txn_hdr_id);
15364:
15365: DELETE FROM wms_dispatched_tasks wdt

Line 15365: DELETE FROM wms_dispatched_tasks wdt

15361: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
15362: WHERE wdt.transaction_temp_id = p_temp_id
15363: AND mmtt.transaction_header_id = x_new_txn_hdr_id);
15364:
15365: DELETE FROM wms_dispatched_tasks wdt
15366: WHERE wdt.transaction_temp_id IN(SELECT mmtt.transaction_temp_id
15367: FROM mtl_material_transactions_temp mmtt
15368: WHERE mmtt.transaction_header_id = p_txn_hdr_id
15369: AND mmtt.organization_id = p_org_id);