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_DISPATCHED_TASKS

Line 297: FROM wms_dispatched_tasks wdt,

293: qt.transaction_type_id,
294: qt.transaction_action_id,
295: qt.transaction_source_id,
296: qt.transaction_source_type_id
297: FROM wms_dispatched_tasks wdt,
298: (SELECT
299: transaction_temp_id task_id,
300: pick_slip_number pick_slip,
301: cartonization_id,

Line 325: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

321: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
322: --7169220: USERS LOCKED
323: AND (mmtt.cartonization_id is null
324: or not exists
325: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
326: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
327: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
328: and wdt1.status = 9
329: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 434: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

430: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
431: --7169220: USERS LOCKED
432: AND (mmtt.cartonization_id is null
433: or not exists
434: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
435: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
436: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
437: and wdt1.status = 9
438: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 563: FROM wms_dispatched_tasks wdt1

559: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
560: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
561: AND NOT EXISTS -- exclude tasks already dispatched and queued
562: (SELECT NULL
563: FROM wms_dispatched_tasks wdt1
564: WHERE wdt1.transaction_temp_id = wdtv.task_id
565: AND wdt1.task_type = wdtv.wms_task_type_id)
566: -- excluded skipped tasks
567: AND wdtv.task_id NOT IN

Line 620: FROM wms_dispatched_tasks wdt,

616: qt.transaction_type_id,
617: qt.transaction_action_id,
618: qt.transaction_source_id,
619: qt.transaction_source_type_id
620: FROM wms_dispatched_tasks wdt,
621: (SELECT
622: transaction_temp_id task_id,
623: pick_slip_number pick_slip,
624: cartonization_id,

Line 648: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

644: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
645: --7169220: USERS LOCKED
646: AND (mmtt.cartonization_id is null
647: or not exists
648: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
649: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
650: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
651: and wdt1.status = 9
652: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 697: FROM wms_dispatched_tasks wdt,

693: qt.transaction_type_id,
694: qt.transaction_action_id,
695: qt.transaction_source_id,
696: qt.transaction_source_type_id
697: FROM wms_dispatched_tasks wdt,
698: (SELECT
699: transaction_temp_id task_id,
700: wms_task_status task_status,--bug 6326482 added to know the previous state of dispatched tasks
701: pick_slip_number pick_slip,

Line 726: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

722: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
723: --7169220: USERS LOCKED
724: AND (mmtt.cartonization_id is null
725: or not exists
726: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
727: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
728: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
729: and wdt1.status = 9
730: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 820: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

816: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
817: --7169220: USERS LOCKED
818: AND (mmtt.cartonization_id is null
819: or not exists
820: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
821: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
822: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
823: and wdt1.status = 9
824: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 912: FROM wms_dispatched_tasks wdt1

908: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
909: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
910: AND NOT EXISTS -- exclude tasks already dispatched and queued
911: (SELECT NULL
912: FROM wms_dispatched_tasks wdt1
913: WHERE wdt1.transaction_temp_id = wdtv.task_id
914: AND wdt1.task_type = wdtv.wms_task_type_id)
915: -- excluded skipped tasks
916: AND wdtv.task_id NOT IN

Line 969: FROM wms_dispatched_tasks wdt,

965: qt.transaction_type_id,
966: qt.transaction_action_id,
967: qt.transaction_source_id,
968: qt.transaction_source_type_id
969: FROM wms_dispatched_tasks wdt,
970: (SELECT
971: MIN(mcce.cycle_count_entry_id) task_id,
972: TO_NUMBER(NULL) pick_slip,
973: To_number(NULL) cartonization_id,

Line 1144: FROM wms_dispatched_tasks wdt1

1140: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1141: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1142: AND NOT EXISTS -- exclude tasks already dispatched and queued
1143: (SELECT NULL
1144: FROM wms_dispatched_tasks wdt1
1145: WHERE wdt1.transaction_temp_id = wdtv.task_id
1146: AND wdt1.task_type = wdtv.wms_task_type_id)
1147: -- excluded skipped tasks
1148: AND wdtv.task_id NOT IN

Line 1200: FROM wms_dispatched_tasks wdt,

1196: qt.transaction_type_id,
1197: qt.transaction_action_id,
1198: qt.transaction_source_id,
1199: qt.transaction_source_type_id
1200: FROM wms_dispatched_tasks wdt,
1201: (SELECT
1202: transaction_temp_id task_id,
1203: pick_slip_number pick_slip,
1204: cartonization_id,

Line 1228: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1224: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1225: --7169220: USERS LOCKED
1226: AND (mmtt.cartonization_id is null
1227: or not exists
1228: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1229: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1230: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1231: and wdt1.status = 9
1232: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1341: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1337: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1338: --7169220: USERS LOCKED
1339: AND (mmtt.cartonization_id is null
1340: or not exists
1341: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1342: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1343: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1344: and wdt1.status = 9
1345: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1469: FROM wms_dispatched_tasks wdt1

1465: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1466: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1467: AND NOT EXISTS -- exclude tasks already dispatched and queued
1468: (SELECT NULL
1469: FROM wms_dispatched_tasks wdt1
1470: WHERE wdt1.transaction_temp_id = wdtv.task_id
1471: AND wdt1.task_type = wdtv.wms_task_type_id)
1472: -- excluded skipped tasks
1473: AND wdtv.task_id NOT IN

Line 1527: FROM wms_dispatched_tasks wdt,

1523: qt.transaction_type_id,
1524: qt.transaction_action_id,
1525: qt.transaction_source_id,
1526: qt.transaction_source_type_id
1527: FROM wms_dispatched_tasks wdt,
1528: (SELECT
1529: transaction_temp_id task_id,
1530: pick_slip_number pick_slip,
1531: cartonization_id,

Line 1555: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1551: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1552: --7169220: USERS LOCKED
1553: AND (mmtt.cartonization_id is null
1554: or not exists
1555: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1556: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1557: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1558: and wdt1.status = 9
1559: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1603: FROM wms_dispatched_tasks wdt,

1599: qt.transaction_type_id,
1600: qt.transaction_action_id,
1601: qt.transaction_source_id,
1602: qt.transaction_source_type_id
1603: FROM wms_dispatched_tasks wdt,
1604: (SELECT
1605: transaction_temp_id task_id,
1606: wms_task_status task_status, -- bug 6326482 added to get the previous state of dispatched tasks
1607: pick_slip_number pick_slip,

Line 1632: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1628: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1629: --7169220: USERS LOCKED
1630: AND (mmtt.cartonization_id is null
1631: or not exists
1632: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1633: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1634: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1635: and wdt1.status = 9
1636: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1725: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

1721: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1722: --7169220: USERS LOCKED
1723: AND (mmtt.cartonization_id is null
1724: or not exists
1725: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1726: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1727: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1728: and wdt1.status = 9
1729: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1816: FROM wms_dispatched_tasks wdt1

1812: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1813: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1814: AND NOT EXISTS -- exclude tasks already dispatched and queued
1815: (SELECT NULL
1816: FROM wms_dispatched_tasks wdt1
1817: WHERE wdt1.transaction_temp_id = wdtv.task_id
1818: AND wdt1.task_type = wdtv.wms_task_type_id)
1819: -- excluded skipped tasks
1820: AND wdtv.task_id NOT IN

Line 1873: FROM wms_dispatched_tasks wdt,

1869: qt.transaction_type_id,
1870: qt.transaction_action_id,
1871: qt.transaction_source_id,
1872: qt.transaction_source_type_id
1873: FROM wms_dispatched_tasks wdt,
1874: (SELECT
1875: MIN(mcce.cycle_count_entry_id) task_id,
1876: TO_NUMBER(NULL) pick_slip,
1877: To_number(NULL) cartonization_id,

Line 2040: FROM wms_dispatched_tasks wdt1

2036: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2037: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2038: AND NOT EXISTS -- exclude tasks already dispatched and queued
2039: (SELECT NULL
2040: FROM wms_dispatched_tasks wdt1
2041: WHERE wdt1.transaction_temp_id = wdtv.task_id
2042: AND wdt1.task_type = wdtv.wms_task_type_id)
2043: -- excluded skipped tasks
2044: AND wdtv.task_id NOT IN

Line 2111: FROM wms_dispatched_tasks wdt,

2107: qt.transaction_type_id,
2108: qt.transaction_action_id,
2109: qt.transaction_source_id,
2110: qt.transaction_source_type_id
2111: FROM wms_dispatched_tasks wdt,
2112: (SELECT
2113: transaction_temp_id task_id,
2114: pick_slip_number pick_slip,
2115: cartonization_id,

Line 2146: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2142: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2143: --7169220: USERS LOCKED
2144: AND (mmtt.cartonization_id is null
2145: or not exists
2146: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2147: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2148: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2149: and wdt1.status = 9
2150: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2296: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2292: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2293: --7169220: USERS LOCKED
2294: AND (mmtt.cartonization_id is null
2295: or not exists
2296: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2297: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2298: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2299: and wdt1.status = 9
2300: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2412: FROM wms_dispatched_tasks wdt1

2408: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2409: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2410: AND NOT EXISTS -- exclude tasks already dispatched and queued
2411: (SELECT NULL
2412: FROM wms_dispatched_tasks wdt1
2413: WHERE wdt1.transaction_temp_id = wdtv.task_id
2414: AND wdt1.task_type = wdtv.wms_task_type_id)
2415: -- Bug 7254397: exclude tasks from locked cartons
2416: AND NOT EXISTS

Line 2491: FROM wms_dispatched_tasks wdt,

2487: qt.transaction_type_id,
2488: qt.transaction_action_id,
2489: qt.transaction_source_id,
2490: qt.transaction_source_type_id
2491: FROM wms_dispatched_tasks wdt,
2492: (SELECT
2493: transaction_temp_id task_id,
2494: pick_slip_number pick_slip,
2495: cartonization_id,

Line 2526: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2522: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2523: --7169220: USERS LOCKED
2524: AND (mmtt.cartonization_id is null
2525: or not exists
2526: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2527: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2528: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2529: and wdt1.status = 9
2530: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2599: FROM wms_dispatched_tasks wdt,

2595: qt.transaction_type_id,
2596: qt.transaction_action_id,
2597: qt.transaction_source_id,
2598: qt.transaction_source_type_id
2599: FROM wms_dispatched_tasks wdt,
2600: (SELECT
2601: transaction_temp_id task_id,
2602: wms_task_status task_status, --bug 6326482 added to check for the previous state of dispatched tasks
2603: pick_slip_number pick_slip,

Line 2635: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2631: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2632: --7169220: USERS LOCKED
2633: AND (mmtt.cartonization_id is null
2634: or not exists
2635: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2636: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2637: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2638: and wdt1.status = 9
2639: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2754: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1

2750: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2751: --7169220: USERS LOCKED
2752: AND (mmtt.cartonization_id is null
2753: or not exists
2754: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2755: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2756: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2757: and wdt1.status = 9
2758: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2833: FROM wms_dispatched_tasks wdt1

2829: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2830: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2831: AND NOT EXISTS -- exclude tasks already dispatched and queued
2832: (SELECT NULL
2833: FROM wms_dispatched_tasks wdt1
2834: WHERE wdt1.transaction_temp_id = wdtv.task_id
2835: AND wdt1.task_type = wdtv.wms_task_type_id)
2836: -- Bug 7254397: exclude tasks from locked cartons
2837: AND NOT EXISTS

Line 2909: FROM wms_dispatched_tasks wdt,

2905: qt.transaction_type_id,
2906: qt.transaction_action_id,
2907: qt.transaction_source_id,
2908: qt.transaction_source_type_id
2909: FROM wms_dispatched_tasks wdt,
2910: (SELECT
2911: MIN(mcce.cycle_count_entry_id) task_id,
2912: TO_NUMBER(NULL) pick_slip,
2913: To_number(NULL) cartonization_id,

Line 3084: FROM wms_dispatched_tasks wdt1

3080: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
3081: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
3082: AND NOT EXISTS -- exclude tasks already dispatched and queued
3083: (SELECT NULL
3084: FROM wms_dispatched_tasks wdt1
3085: WHERE wdt1.transaction_temp_id = wdtv.task_id
3086: AND wdt1.task_type = wdtv.wms_task_type_id)
3087: -- excluded skipped tasks
3088: AND wdtv.task_id NOT IN

Line 3293: FROM wms_dispatched_tasks wdt

3289: BEGIN
3290: SELECT transaction_temp_id, task_type, loaded_time
3291: INTO l_last_loaded_task_id, l_last_loaded_task_type, l_last_loaded_time
3292: FROM (SELECT transaction_temp_id, task_type, loaded_time
3293: FROM wms_dispatched_tasks wdt
3294: WHERE wdt.person_id = p_sign_on_emp_id
3295: AND wdt.loaded_time = (SELECT MAX(loaded_time)
3296: FROM wms_dispatched_tasks
3297: WHERE person_id = p_sign_on_emp_id))

Line 3296: FROM wms_dispatched_tasks

3292: FROM (SELECT transaction_temp_id, task_type, loaded_time
3293: FROM wms_dispatched_tasks wdt
3294: WHERE wdt.person_id = p_sign_on_emp_id
3295: AND wdt.loaded_time = (SELECT MAX(loaded_time)
3296: FROM wms_dispatched_tasks
3297: WHERE person_id = p_sign_on_emp_id))
3298: WHERE ROWNUM = 1; -- make sure only one task selected
3299:
3300: l_progress := '31';

Line 3319: FROM wms_dispatched_tasks_history wdth

3315:
3316: SELECT transaction_id, task_type, loaded_time
3317: INTO l_last_dropoff_task_id, l_last_dropoff_task_type, l_last_dropoff_time
3318: FROM (SELECT transaction_id, task_type, loaded_time
3319: FROM wms_dispatched_tasks_history wdth
3320: WHERE wdth.person_id = p_sign_on_emp_id
3321: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3322: FROM wms_dispatched_tasks_history
3323: WHERE person_id = p_sign_on_emp_id))

Line 3322: FROM wms_dispatched_tasks_history

3318: FROM (SELECT transaction_id, task_type, loaded_time
3319: FROM wms_dispatched_tasks_history wdth
3320: WHERE wdth.person_id = p_sign_on_emp_id
3321: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3322: FROM wms_dispatched_tasks_history
3323: WHERE person_id = p_sign_on_emp_id))
3324: WHERE ROWNUM = 1; -- make sure only one task selected
3325:
3326: l_progress := '33';

Line 3939: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

3935:
3936: /*Check if any task has been dispatched to other users for the same LPN*/
3937: IF l_lpn_id IS NOT NULL THEN
3938: l_wdt_count := 0 ;
3939: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
3940: WHERE mmtt.cartonization_id = l_lpn_id
3941: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
3942: AND wdt.status in(3,9) AND wdt.person_id <> p_sign_on_emp_id ;
3943:

Line 4519: FROM wms_dispatched_tasks wdt1

4515: AND mmtt.parent_line_id IS NOT NULL
4516: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4517: AND NOT EXISTS -- exclude tasks already dispatched
4518: (SELECT NULL
4519: FROM wms_dispatched_tasks wdt1
4520: WHERE wdt1.transaction_temp_id = wdtv.task_id
4521: AND wdt1.task_type = wdtv.wms_task_type_id)
4522: --******************
4523: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 4675: FROM wms_dispatched_tasks wdt1

4671: AND mmtt.parent_line_id IS NOT NULL
4672: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4673: AND NOT EXISTS -- exclude tasks already dispatched
4674: (SELECT NULL
4675: FROM wms_dispatched_tasks wdt1
4676: WHERE wdt1.transaction_temp_id = wdtv.task_id
4677: AND wdt1.task_type = wdtv.wms_task_type_id)
4678: --******************
4679: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 4828: FROM wms_dispatched_tasks wdt1

4824: AND mmtt.parent_line_id IS NOT NULL
4825: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4826: AND NOT EXISTS -- exclude tasks already dispatched
4827: (SELECT NULL
4828: FROM wms_dispatched_tasks wdt1
4829: WHERE wdt1.transaction_temp_id = wdtv.task_id
4830: AND wdt1.task_type = wdtv.wms_task_type_id)
4831: --******************
4832: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 4982: FROM wms_dispatched_tasks wdt1

4978: AND mmtt.parent_line_id IS NOT NULL
4979: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4980: AND NOT EXISTS -- exclude tasks already dispatched
4981: (SELECT NULL
4982: FROM wms_dispatched_tasks wdt1
4983: WHERE wdt1.transaction_temp_id = wdtv.task_id
4984: AND wdt1.task_type = wdtv.wms_task_type_id)
4985: --******************
4986: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5137: FROM wms_dispatched_tasks wdt1

5133: AND mmtt.parent_line_id IS NOT NULL
5134: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5135: AND NOT EXISTS -- exclude tasks already dispatched
5136: (SELECT NULL
5137: FROM wms_dispatched_tasks wdt1
5138: WHERE wdt1.transaction_temp_id = wdtv.task_id
5139: AND wdt1.task_type = wdtv.wms_task_type_id)
5140: --******************
5141: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5290: FROM wms_dispatched_tasks wdt1

5286: AND mmtt.parent_line_id IS NOT NULL
5287: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5288: AND NOT EXISTS -- exclude tasks already dispatched
5289: (SELECT NULL
5290: FROM wms_dispatched_tasks wdt1
5291: WHERE wdt1.transaction_temp_id = wdtv.task_id
5292: AND wdt1.task_type = wdtv.wms_task_type_id)
5293: --******************
5294: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5441: FROM wms_dispatched_tasks wdt1

5437: AND mmtt.parent_line_id IS NOT NULL
5438: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5439: AND NOT EXISTS -- exclude tasks already dispatched
5440: (SELECT NULL
5441: FROM wms_dispatched_tasks wdt1
5442: WHERE wdt1.transaction_temp_id = wdtv.task_id
5443: AND wdt1.task_type = wdtv.wms_task_type_id)
5444: --******************
5445: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5593: FROM wms_dispatched_tasks wdt1

5589: AND mmtt.parent_line_id IS NOT NULL
5590: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5591: AND NOT EXISTS -- exclude tasks already dispatched
5592: (SELECT NULL
5593: FROM wms_dispatched_tasks wdt1
5594: WHERE wdt1.transaction_temp_id = wdtv.task_id
5595: AND wdt1.task_type = wdtv.wms_task_type_id)
5596: --******************
5597: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5743: FROM wms_dispatched_tasks wdt1

5739: AND mmtt.parent_line_id IS NOT NULL
5740: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5741: AND NOT EXISTS -- exclude tasks already dispatched
5742: (SELECT NULL
5743: FROM wms_dispatched_tasks wdt1
5744: WHERE wdt1.transaction_temp_id = wdtv.task_id
5745: AND wdt1.task_type = wdtv.wms_task_type_id)
5746: --******************
5747: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5897: FROM wms_dispatched_tasks wdt1

5893: AND mmtt.parent_line_id IS NOT NULL
5894: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5895: AND NOT EXISTS -- exclude tasks already dispatched
5896: (SELECT NULL
5897: FROM wms_dispatched_tasks wdt1
5898: WHERE wdt1.transaction_temp_id = wdtv.task_id
5899: AND wdt1.task_type = wdtv.wms_task_type_id)
5900: --******************
5901: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6045: FROM wms_dispatched_tasks wdt1

6041: AND mmtt.parent_line_id IS NOT NULL
6042: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6043: AND NOT EXISTS -- exclude tasks already dispatched
6044: (SELECT NULL
6045: FROM wms_dispatched_tasks wdt1
6046: WHERE wdt1.transaction_temp_id = wdtv.task_id
6047: AND wdt1.task_type = wdtv.wms_task_type_id)
6048: --******************
6049: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6196: FROM wms_dispatched_tasks wdt1

6192: AND mmtt.parent_line_id IS NOT NULL
6193: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6194: AND NOT EXISTS -- exclude tasks already dispatched
6195: (SELECT NULL
6196: FROM wms_dispatched_tasks wdt1
6197: WHERE wdt1.transaction_temp_id = wdtv.task_id
6198: AND wdt1.task_type = wdtv.wms_task_type_id)
6199: --******************
6200: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6333: FROM wms_dispatched_tasks wdt1

6329: AND wste.organization_id = mp.organization_id )
6330: --************
6331: AND wdtv.task_id NOT IN
6332: (SELECT wdt1.transaction_temp_id
6333: FROM wms_dispatched_tasks wdt1
6334: -- WHERE wdt1.status = 1
6335: UNION ALL
6336: SELECT wdt2.transaction_temp_id
6337: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

Line 6337: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

6333: FROM wms_dispatched_tasks wdt1
6334: -- WHERE wdt1.status = 1
6335: UNION ALL
6336: SELECT wdt2.transaction_temp_id
6337: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2
6338: WHERE wms_except.person_id = ' || p_sign_on_emp_id || '
6339: AND wdt2.task_id = wms_except.task_id
6340: AND discrepancy_type = 1
6341: )

Line 6363: FROM wms_dispatched_tasks wdt

6359: , l_last_loaded_time
6360: FROM (SELECT transaction_temp_id
6361: , task_type
6362: , loaded_time
6363: FROM wms_dispatched_tasks wdt
6364: WHERE wdt.person_id = p_sign_on_emp_id
6365: AND wdt.loaded_time = (SELECT MAX(loaded_time)
6366: FROM wms_dispatched_tasks
6367: WHERE person_id = p_sign_on_emp_id))

Line 6366: FROM wms_dispatched_tasks

6362: , loaded_time
6363: FROM wms_dispatched_tasks wdt
6364: WHERE wdt.person_id = p_sign_on_emp_id
6365: AND wdt.loaded_time = (SELECT MAX(loaded_time)
6366: FROM wms_dispatched_tasks
6367: WHERE person_id = p_sign_on_emp_id))
6368: WHERE ROWNUM = 1 -- make sure only one task selected
6369: ;
6370:

Line 6396: FROM wms_dispatched_tasks_history wdth

6392: , l_last_dropoff_time
6393: FROM (SELECT transaction_id
6394: , task_type
6395: , loaded_time
6396: FROM wms_dispatched_tasks_history wdth
6397: WHERE wdth.person_id = p_sign_on_emp_id
6398: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6399: FROM wms_dispatched_tasks_history
6400: WHERE person_id = p_sign_on_emp_id))

Line 6399: FROM wms_dispatched_tasks_history

6395: , loaded_time
6396: FROM wms_dispatched_tasks_history wdth
6397: WHERE wdth.person_id = p_sign_on_emp_id
6398: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6399: FROM wms_dispatched_tasks_history
6400: WHERE person_id = p_sign_on_emp_id))
6401: WHERE ROWNUM = 1 -- make sure only one task selected
6402: ;
6403:

Line 7434: FROM wms_dispatched_tasks wdt1

7430: AND mmtt.parent_line_id IS NOT NULL
7431: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7432: AND NOT EXISTS -- exclude tasks already dispatched
7433: (SELECT NULL
7434: FROM wms_dispatched_tasks wdt1
7435: WHERE wdt1.transaction_temp_id = wdtv.task_id
7436: AND wdt1.task_type = wdtv.wms_task_type_id)
7437: -- Join with delivery details
7438: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 7591: FROM wms_dispatched_tasks wdt1

7587: AND mmtt.parent_line_id IS NOT NULL
7588: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7589: AND NOT EXISTS -- exclude tasks already dispatched
7590: (SELECT NULL
7591: FROM wms_dispatched_tasks wdt1
7592: WHERE wdt1.transaction_temp_id = wdtv.task_id
7593: AND wdt1.task_type = wdtv.wms_task_type_id)
7594: --******************
7595: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 7754: FROM wms_dispatched_tasks wdt1

7750: AND mmtt.parent_line_id IS NOT NULL
7751: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7752: AND NOT EXISTS -- exclude tasks already dispatched
7753: (SELECT NULL
7754: FROM wms_dispatched_tasks wdt1
7755: WHERE wdt1.transaction_temp_id = wdtv.task_id
7756: AND wdt1.task_type = wdtv.wms_task_type_id)
7757: -- Join with delivery details
7758: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 7910: FROM wms_dispatched_tasks wdt1

7906: AND mmtt.parent_line_id IS NOT NULL
7907: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7908: AND NOT EXISTS -- exclude tasks already dispatched
7909: (SELECT NULL
7910: FROM wms_dispatched_tasks wdt1
7911: WHERE wdt1.transaction_temp_id = wdtv.task_id
7912: AND wdt1.task_type = wdtv.wms_task_type_id)
7913: --******************
7914: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 7973: FROM wms_dispatched_tasks wdt,

7969: , wdt.effective_start_date
7970: , wdt.effective_end_date
7971: , wdt.person_resource_id
7972: , wdt.machine_resource_id
7973: FROM wms_dispatched_tasks wdt,
7974: (SELECT transaction_temp_id task_id
7975: , standard_operation_id user_task_type_id
7976: , wms_task_type wms_task_type_id
7977: , organization_id organization_id

Line 8151: FROM wms_dispatched_tasks wdt1

8147: AND mmtt.parent_line_id IS NOT NULL
8148: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8149: AND NOT EXISTS -- exclude tasks already dispatched
8150: (SELECT NULL
8151: FROM wms_dispatched_tasks wdt1
8152: WHERE wdt1.transaction_temp_id = wdtv.task_id
8153: AND wdt1.task_type = wdtv.wms_task_type_id)
8154: -- Join with delivery details
8155: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 8217: FROM wms_dispatched_tasks wdt,

8213: , wdt.effective_start_date
8214: , wdt.effective_end_date
8215: , wdt.person_resource_id
8216: , wdt.machine_resource_id
8217: FROM wms_dispatched_tasks wdt,
8218: (SELECT transaction_temp_id task_id
8219: , standard_operation_id user_task_type_id
8220: , wms_task_type wms_task_type_id
8221: , organization_id organization_id

Line 8379: FROM wms_dispatched_tasks wdt1

8375: AND mmtt.parent_line_id IS NOT NULL
8376: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8377: AND NOT EXISTS -- exclude tasks already dispatched
8378: (SELECT NULL
8379: FROM wms_dispatched_tasks wdt1
8380: WHERE wdt1.transaction_temp_id = wdtv.task_id
8381: AND wdt1.task_type = wdtv.wms_task_type_id)
8382: --******************
8383: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 8445: FROM wms_dispatched_tasks wdt,

8441: , wdt.effective_start_date
8442: , wdt.effective_end_date
8443: , wdt.person_resource_id
8444: , wdt.machine_resource_id
8445: FROM wms_dispatched_tasks wdt,
8446: (SELECT transaction_temp_id task_id
8447: , standard_operation_id user_task_type_id
8448: , wms_task_type wms_task_type_id
8449: , organization_id organization_id

Line 8623: FROM wms_dispatched_tasks wdt1

8619: AND mmtt.parent_line_id IS NOT NULL
8620: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8621: AND NOT EXISTS -- exclude tasks already dispatched
8622: (SELECT NULL
8623: FROM wms_dispatched_tasks wdt1
8624: WHERE wdt1.transaction_temp_id = wdtv.task_id
8625: AND wdt1.task_type = wdtv.wms_task_type_id)
8626: -- Join with delivery details
8627: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 8679: FROM wms_dispatched_tasks wdt,

8675: , wdt.effective_start_date
8676: , wdt.effective_end_date
8677: , wdt.person_resource_id
8678: , wdt.machine_resource_id
8679: FROM wms_dispatched_tasks wdt,
8680: (SELECT transaction_temp_id task_id
8681: , standard_operation_id user_task_type_id
8682: , wms_task_type wms_task_type_id
8683: , organization_id organization_id

Line 8843: FROM wms_dispatched_tasks wdt1

8839: AND mmtt.parent_line_id IS NOT NULL
8840: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8841: AND NOT EXISTS -- exclude tasks already dispatched
8842: (SELECT NULL
8843: FROM wms_dispatched_tasks wdt1
8844: WHERE wdt1.transaction_temp_id = wdtv.task_id
8845: AND wdt1.task_type = wdtv.wms_task_type_id)
8846: --******************
8847: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 8909: FROM wms_dispatched_tasks wdt,

8905: , wdt.effective_start_date
8906: , wdt.effective_end_date
8907: , wdt.person_resource_id
8908: , wdt.machine_resource_id
8909: FROM wms_dispatched_tasks wdt,
8910: (SELECT transaction_temp_id task_id
8911: , standard_operation_id user_task_type_id
8912: , wms_task_type wms_task_type_id
8913: , organization_id organization_id

Line 9083: FROM wms_dispatched_tasks wdt1

9079: AND mmtt.parent_line_id IS NOT NULL
9080: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9081: AND NOT EXISTS -- exclude tasks already dispatched
9082: (SELECT NULL
9083: FROM wms_dispatched_tasks wdt1
9084: WHERE wdt1.transaction_temp_id = wdtv.task_id
9085: AND wdt1.task_type = wdtv.wms_task_type_id)
9086: -- Join with delivery details
9087: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 9148: FROM wms_dispatched_tasks wdt,

9144: , wdt.effective_start_date
9145: , wdt.effective_end_date
9146: , wdt.person_resource_id
9147: , wdt.machine_resource_id
9148: FROM wms_dispatched_tasks wdt,
9149: (SELECT transaction_temp_id task_id
9150: , standard_operation_id user_task_type_id
9151: , wms_task_type wms_task_type_id
9152: , organization_id organization_id

Line 9310: FROM wms_dispatched_tasks wdt1

9306: AND mmtt.parent_line_id IS NOT NULL
9307: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9308: AND NOT EXISTS -- exclude tasks already dispatched
9309: (SELECT NULL
9310: FROM wms_dispatched_tasks wdt1
9311: WHERE wdt1.transaction_temp_id = wdtv.task_id
9312: AND wdt1.task_type = wdtv.wms_task_type_id)
9313: --******************
9314: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 9373: FROM wms_dispatched_tasks wdt,

9369: , wdt.effective_start_date
9370: , wdt.effective_end_date
9371: , wdt.person_resource_id
9372: , wdt.machine_resource_id
9373: FROM wms_dispatched_tasks wdt,
9374: (SELECT transaction_temp_id task_id
9375: , standard_operation_id user_task_type_id
9376: , wms_task_type wms_task_type_id
9377: , organization_id organization_id

Line 9548: FROM wms_dispatched_tasks wdt1

9544: AND mmtt.parent_line_id IS NOT NULL
9545: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9546: AND NOT EXISTS -- exclude tasks already dispatched
9547: (SELECT NULL
9548: FROM wms_dispatched_tasks wdt1
9549: WHERE wdt1.transaction_temp_id = wdtv.task_id
9550: AND wdt1.task_type = wdtv.wms_task_type_id)
9551: -- Join with delivery details
9552: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 9604: FROM wms_dispatched_tasks wdt,

9600: , wdt.effective_start_date
9601: , wdt.effective_end_date
9602: , wdt.person_resource_id
9603: , wdt.machine_resource_id
9604: FROM wms_dispatched_tasks wdt,
9605: (SELECT transaction_temp_id task_id
9606: , standard_operation_id user_task_type_id
9607: , wms_task_type wms_task_type_id
9608: , organization_id organization_id

Line 9766: FROM wms_dispatched_tasks wdt1

9762: AND mmtt.parent_line_id IS NOT NULL
9763: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9764: AND NOT EXISTS -- exclude tasks already dispatched
9765: (SELECT NULL
9766: FROM wms_dispatched_tasks wdt1
9767: WHERE wdt1.transaction_temp_id = wdtv.task_id
9768: AND wdt1.task_type = wdtv.wms_task_type_id)
9769: --******************
9770: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 9891: FROM wms_dispatched_tasks wdt1

9887: AND wste.organization_id = mp.organization_id )
9888: --************
9889: AND wdtv.task_id NOT IN
9890: (SELECT wdt1.transaction_temp_id
9891: FROM wms_dispatched_tasks wdt1
9892: -- WHERE wdt1.status = 1
9893: UNION ALL
9894: SELECT wdt2.transaction_temp_id
9895: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

Line 9895: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

9891: FROM wms_dispatched_tasks wdt1
9892: -- WHERE wdt1.status = 1
9893: UNION ALL
9894: SELECT wdt2.transaction_temp_id
9895: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2
9896: WHERE wms_except.person_id = ' || p_sign_on_emp_id || '
9897: AND wdt2.task_id = wms_except.task_id
9898: AND discrepancy_type = 1
9899: )

Line 9922: FROM wms_dispatched_tasks wdt

9918: , l_last_loaded_time
9919: FROM (SELECT transaction_temp_id
9920: , task_type
9921: , loaded_time
9922: FROM wms_dispatched_tasks wdt
9923: WHERE wdt.person_id = p_sign_on_emp_id
9924: AND wdt.loaded_time = (SELECT MAX(loaded_time)
9925: FROM wms_dispatched_tasks
9926: WHERE person_id = p_sign_on_emp_id))

Line 9925: FROM wms_dispatched_tasks

9921: , loaded_time
9922: FROM wms_dispatched_tasks wdt
9923: WHERE wdt.person_id = p_sign_on_emp_id
9924: AND wdt.loaded_time = (SELECT MAX(loaded_time)
9925: FROM wms_dispatched_tasks
9926: WHERE person_id = p_sign_on_emp_id))
9927: WHERE ROWNUM = 1; -- make sure only one task selected
9928:
9929: l_progress := '31';

Line 9954: FROM wms_dispatched_tasks_history wdth

9950: , l_last_dropoff_time
9951: FROM (SELECT transaction_id
9952: , task_type
9953: , loaded_time
9954: FROM wms_dispatched_tasks_history wdth
9955: WHERE wdth.person_id = p_sign_on_emp_id
9956: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
9957: FROM wms_dispatched_tasks_history
9958: WHERE person_id = p_sign_on_emp_id))

Line 9957: FROM wms_dispatched_tasks_history

9953: , loaded_time
9954: FROM wms_dispatched_tasks_history wdth
9955: WHERE wdth.person_id = p_sign_on_emp_id
9956: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
9957: FROM wms_dispatched_tasks_history
9958: WHERE person_id = p_sign_on_emp_id))
9959: WHERE ROWNUM = 1; -- make sure only one task selected
9960:
9961: l_progress := '33';