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 10442: UPDATE wms_dispatched_tasks

10438: IF (l_debug = 1) THEN
10439: mydebug('multiple_pick: Plain item. Update WMSDT as loaded');
10440: END IF;
10441:
10442: UPDATE wms_dispatched_tasks
10443: SET status = 4
10444: , loaded_time = SYSDATE
10445: , --to_date(to_char(sysdate,'DD-MON-YYYY HH:MI:SS'),'DD-MON-YYYY HH:MI:SS'),
10446: last_update_date = SYSDATE

Line 12518: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t

12514: IF l_mmtt_rowcnt > 0 THEN
12515: -- There are MMTT tasks for this LPN
12516: SELECT COUNT(*)
12517: INTO l_wdt_rowcnt
12518: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t
12519: WHERE m.cartonization_id = l_lpn_id
12520: AND t.transaction_temp_id = m.transaction_temp_id
12521: AND t.status = 4;
12522:

Line 12637: -- Insert into WMS_DISPATCHED_TASKS for this user

12633: UPDATE mtl_material_transactions_temp
12634: SET transaction_header_id = l_txn_hdr_id
12635: WHERE transaction_temp_id = task_rec.task_id;
12636:
12637: -- Insert into WMS_DISPATCHED_TASKS for this user
12638:
12639: --Get value from sequence for next task id
12640: SELECT wms_dispatched_tasks_s.NEXTVAL
12641: INTO l_next_task_id

Line 12640: SELECT wms_dispatched_tasks_s.NEXTVAL

12636:
12637: -- Insert into WMS_DISPATCHED_TASKS for this user
12638:
12639: --Get value from sequence for next task id
12640: SELECT wms_dispatched_tasks_s.NEXTVAL
12641: INTO l_next_task_id
12642: FROM DUAL;
12643:
12644: --mydebug('pick_by_label: Before Insert into WMSDT');

Line 12647: INSERT INTO wms_dispatched_tasks

12643:
12644: --mydebug('pick_by_label: Before Insert into WMSDT');
12645:
12646:
12647: INSERT INTO wms_dispatched_tasks
12648: (
12649: task_id
12650: , transaction_temp_id
12651: , organization_id

Line 12909: FROM wms_dispatched_tasks t

12905: SELECT 1
12906: INTO l_wdt_rowcnt
12907: FROM DUAL
12908: WHERE EXISTS(SELECT 1
12909: FROM wms_dispatched_tasks t
12910: WHERE t.transaction_temp_id = l_pick_slip_id);
12911: EXCEPTION
12912: WHEN NO_DATA_FOUND THEN
12913: l_wdt_rowcnt := 0;

Line 12994: -- Insert into WMS_DISPATCHED_TASKS for this user

12990: RAISE fnd_api.g_exc_error;
12991: END;
12992: END IF;
12993:
12994: -- Insert into WMS_DISPATCHED_TASKS for this user
12995:
12996: --Get value from sequence for next task id
12997: SELECT wms_dispatched_tasks_s.NEXTVAL
12998: INTO l_next_task_id

Line 12997: SELECT wms_dispatched_tasks_s.NEXTVAL

12993:
12994: -- Insert into WMS_DISPATCHED_TASKS for this user
12995:
12996: --Get value from sequence for next task id
12997: SELECT wms_dispatched_tasks_s.NEXTVAL
12998: INTO l_next_task_id
12999: FROM DUAL;
13000:
13001: --mydebug('manual_pick: Before Insert into WMSDT');

Line 13084: INSERT INTO wms_dispatched_tasks

13080: END ;
13081: END IF;
13082: --Bug6009436.End
13083:
13084: INSERT INTO wms_dispatched_tasks
13085: (
13086: task_id
13087: , transaction_temp_id
13088: , organization_id

Line 13197: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t

13193: IF l_mmtt_rowcnt > 0 THEN
13194: -- There are MMTT tasks for this LPN
13195: SELECT COUNT(*)
13196: INTO l_wdt_rowcnt
13197: FROM mtl_material_transactions_temp m, wms_dispatched_tasks t
13198: WHERE m.cartonization_id = l_lpn_id
13199: AND t.transaction_temp_id = m.transaction_temp_id
13200: AND t.status = 4;
13201:

Line 13451: DELETE FROM wms_dispatched_tasks

13447: BEGIN
13448: DELETE FROM mtl_material_transactions_temp
13449: WHERE transaction_temp_id = p_temp_id;
13450:
13451: DELETE FROM wms_dispatched_tasks
13452: WHERE transaction_temp_id = p_temp_id;
13453:
13454: IF p_lot_control_code > 1 THEN
13455:

Line 13732: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

13728: 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;
13729: CLOSE c_mo_line_info;
13730: */
13731: IF (l_mo_type = INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE) THEN
13732: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
13733:
13734: /*bug3139307 suggest_alternate_location API in wms_txnrsn_actions_pub
13735: would call INV_Replenish_Detail_PUB.Line_Details_PUB . When there is
13736: no quantity to allocate the sales order would be automatically

Line 14916: INSERT INTO wms_dispatched_tasks

14912: mydebug('Dispatching Child Tasks');
14913: END IF;
14914:
14915: -- Dispatching Picked Child Tasks
14916: INSERT INTO wms_dispatched_tasks
14917: (
14918: task_id
14919: , transaction_temp_id
14920: , organization_id

Line 14940: (SELECT wms_dispatched_tasks_s.NEXTVAL

14936: , loaded_time
14937: , operation_plan_id
14938: , move_order_line_id
14939: )
14940: (SELECT wms_dispatched_tasks_s.NEXTVAL
14941: , mmtt.transaction_temp_id
14942: , mmtt.organization_id
14943: , wdt.user_task_type
14944: , wdt.person_id

Line 14961: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

14957: , wdt.task_type
14958: , SYSDATE
14959: , mmtt.operation_plan_id
14960: , mmtt.move_order_line_id
14961: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
14962: WHERE wdt.transaction_temp_id = p_temp_id
14963: AND mmtt.transaction_header_id = x_new_txn_hdr_id);
14964:
14965: DELETE FROM wms_dispatched_tasks wdt

Line 14965: DELETE FROM wms_dispatched_tasks wdt

14961: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
14962: WHERE wdt.transaction_temp_id = p_temp_id
14963: AND mmtt.transaction_header_id = x_new_txn_hdr_id);
14964:
14965: DELETE FROM wms_dispatched_tasks wdt
14966: WHERE wdt.transaction_temp_id IN(SELECT mmtt.transaction_temp_id
14967: FROM mtl_material_transactions_temp mmtt
14968: WHERE mmtt.transaction_header_id = p_txn_hdr_id
14969: AND mmtt.organization_id = p_org_id);