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 333: FROM wms_dispatched_tasks wdt,

329: qt.transaction_type_id,
330: qt.transaction_action_id,
331: qt.transaction_source_id,
332: qt.transaction_source_type_id
333: FROM wms_dispatched_tasks wdt,
334: (SELECT
335: transaction_temp_id task_id,
336: pick_slip_number pick_slip,
337: cartonization_id,

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

357: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
358: --7169220: USERS LOCKED
359: AND (mmtt.cartonization_id is null
360: or not exists
361: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
362: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
363: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
364: and wdt1.status = 9
365: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

468: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
469: --7169220: USERS LOCKED
470: AND (mmtt.cartonization_id is null
471: or not exists
472: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
473: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
474: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
475: and wdt1.status = 9
476: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 601: FROM wms_dispatched_tasks wdt1

597: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
598: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
599: AND NOT EXISTS -- exclude tasks already dispatched and queued
600: (SELECT NULL
601: FROM wms_dispatched_tasks wdt1
602: WHERE wdt1.transaction_temp_id = wdtv.task_id
603: AND wdt1.task_type = wdtv.wms_task_type_id)
604: -- excluded skipped tasks
605: AND wdtv.task_id NOT IN

Line 658: FROM wms_dispatched_tasks wdt,

654: qt.transaction_type_id,
655: qt.transaction_action_id,
656: qt.transaction_source_id,
657: qt.transaction_source_type_id
658: FROM wms_dispatched_tasks wdt,
659: (SELECT
660: transaction_temp_id task_id,
661: pick_slip_number pick_slip,
662: cartonization_id,

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

682: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
683: --7169220: USERS LOCKED
684: AND (mmtt.cartonization_id is null
685: or not exists
686: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
687: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
688: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
689: and wdt1.status = 9
690: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 735: FROM wms_dispatched_tasks wdt,

731: qt.transaction_type_id,
732: qt.transaction_action_id,
733: qt.transaction_source_id,
734: qt.transaction_source_type_id
735: FROM wms_dispatched_tasks wdt,
736: (SELECT
737: transaction_temp_id task_id,
738: wms_task_status task_status,--bug 6326482 added to know the previous state of dispatched tasks
739: pick_slip_number pick_slip,

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

760: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
761: --7169220: USERS LOCKED
762: AND (mmtt.cartonization_id is null
763: or not exists
764: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
765: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
766: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
767: and wdt1.status = 9
768: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

854: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
855: --7169220: USERS LOCKED
856: AND (mmtt.cartonization_id is null
857: or not exists
858: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
859: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
860: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
861: and wdt1.status = 9
862: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 950: FROM wms_dispatched_tasks wdt1

946: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
947: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
948: AND NOT EXISTS -- exclude tasks already dispatched and queued
949: (SELECT NULL
950: FROM wms_dispatched_tasks wdt1
951: WHERE wdt1.transaction_temp_id = wdtv.task_id
952: AND wdt1.task_type = wdtv.wms_task_type_id)
953: -- excluded skipped tasks
954: AND wdtv.task_id NOT IN

Line 1007: FROM wms_dispatched_tasks wdt,

1003: qt.transaction_type_id,
1004: qt.transaction_action_id,
1005: qt.transaction_source_id,
1006: qt.transaction_source_type_id
1007: FROM wms_dispatched_tasks wdt,
1008: (SELECT
1009: MIN(mcce.cycle_count_entry_id) task_id,
1010: TO_NUMBER(NULL) pick_slip,
1011: To_number(NULL) cartonization_id,

Line 1182: FROM wms_dispatched_tasks wdt1

1178: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1179: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1180: AND NOT EXISTS -- exclude tasks already dispatched and queued
1181: (SELECT NULL
1182: FROM wms_dispatched_tasks wdt1
1183: WHERE wdt1.transaction_temp_id = wdtv.task_id
1184: AND wdt1.task_type = wdtv.wms_task_type_id)
1185: -- excluded skipped tasks
1186: AND wdtv.task_id NOT IN

Line 1238: FROM wms_dispatched_tasks wdt,

1234: qt.transaction_type_id,
1235: qt.transaction_action_id,
1236: qt.transaction_source_id,
1237: qt.transaction_source_type_id
1238: FROM wms_dispatched_tasks wdt,
1239: (SELECT
1240: transaction_temp_id task_id,
1241: pick_slip_number pick_slip,
1242: cartonization_id,

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

1262: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1263: --7169220: USERS LOCKED
1264: AND (mmtt.cartonization_id is null
1265: or not exists
1266: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1267: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1268: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1269: and wdt1.status = 9
1270: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

1375: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1376: --7169220: USERS LOCKED
1377: AND (mmtt.cartonization_id is null
1378: or not exists
1379: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1380: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1381: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1382: and wdt1.status = 9
1383: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1507: FROM wms_dispatched_tasks wdt1

1503: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1504: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1505: AND NOT EXISTS -- exclude tasks already dispatched and queued
1506: (SELECT NULL
1507: FROM wms_dispatched_tasks wdt1
1508: WHERE wdt1.transaction_temp_id = wdtv.task_id
1509: AND wdt1.task_type = wdtv.wms_task_type_id)
1510: -- excluded skipped tasks
1511: AND wdtv.task_id NOT IN

Line 1565: FROM wms_dispatched_tasks wdt,

1561: qt.transaction_type_id,
1562: qt.transaction_action_id,
1563: qt.transaction_source_id,
1564: qt.transaction_source_type_id
1565: FROM wms_dispatched_tasks wdt,
1566: (SELECT
1567: transaction_temp_id task_id,
1568: pick_slip_number pick_slip,
1569: cartonization_id,

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

1589: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1590: --7169220: USERS LOCKED
1591: AND (mmtt.cartonization_id is null
1592: or not exists
1593: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1594: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1595: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1596: and wdt1.status = 9
1597: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1641: FROM wms_dispatched_tasks wdt,

1637: qt.transaction_type_id,
1638: qt.transaction_action_id,
1639: qt.transaction_source_id,
1640: qt.transaction_source_type_id
1641: FROM wms_dispatched_tasks wdt,
1642: (SELECT
1643: transaction_temp_id task_id,
1644: wms_task_status task_status, -- bug 6326482 added to get the previous state of dispatched tasks
1645: pick_slip_number pick_slip,

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

1666: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1667: --7169220: USERS LOCKED
1668: AND (mmtt.cartonization_id is null
1669: or not exists
1670: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1671: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1672: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1673: and wdt1.status = 9
1674: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

1759: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
1760: --7169220: USERS LOCKED
1761: AND (mmtt.cartonization_id is null
1762: or not exists
1763: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
1764: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
1765: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
1766: and wdt1.status = 9
1767: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 1854: FROM wms_dispatched_tasks wdt1

1850: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
1851: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
1852: AND NOT EXISTS -- exclude tasks already dispatched and queued
1853: (SELECT NULL
1854: FROM wms_dispatched_tasks wdt1
1855: WHERE wdt1.transaction_temp_id = wdtv.task_id
1856: AND wdt1.task_type = wdtv.wms_task_type_id)
1857: -- excluded skipped tasks
1858: AND wdtv.task_id NOT IN

Line 1911: FROM wms_dispatched_tasks wdt,

1907: qt.transaction_type_id,
1908: qt.transaction_action_id,
1909: qt.transaction_source_id,
1910: qt.transaction_source_type_id
1911: FROM wms_dispatched_tasks wdt,
1912: (SELECT
1913: MIN(mcce.cycle_count_entry_id) task_id,
1914: TO_NUMBER(NULL) pick_slip,
1915: To_number(NULL) cartonization_id,

Line 2080: FROM wms_dispatched_tasks wdt1

2076: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2077: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2078: AND NOT EXISTS -- exclude tasks already dispatched and queued
2079: (SELECT NULL
2080: FROM wms_dispatched_tasks wdt1
2081: WHERE wdt1.transaction_temp_id = wdtv.task_id
2082: AND wdt1.task_type = wdtv.wms_task_type_id)
2083: -- excluded skipped tasks
2084: AND wdtv.task_id NOT IN

Line 2151: FROM wms_dispatched_tasks wdt,

2147: qt.transaction_type_id,
2148: qt.transaction_action_id,
2149: qt.transaction_source_id,
2150: qt.transaction_source_type_id
2151: FROM wms_dispatched_tasks wdt,
2152: (SELECT
2153: transaction_temp_id task_id,
2154: pick_slip_number pick_slip,
2155: cartonization_id,

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

2183: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2184: --7169220: USERS LOCKED
2185: AND (mmtt.cartonization_id is null
2186: or not exists
2187: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2188: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2189: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2190: and wdt1.status = 9
2191: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

2352: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2353: --7169220: USERS LOCKED
2354: AND (mmtt.cartonization_id is null
2355: or not exists
2356: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2357: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2358: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2359: and wdt1.status = 9
2360: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2492: FROM wms_dispatched_tasks wdt1

2488: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2489: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2490: AND NOT EXISTS -- exclude tasks already dispatched and queued
2491: (SELECT NULL
2492: FROM wms_dispatched_tasks wdt1
2493: WHERE wdt1.transaction_temp_id = wdtv.task_id
2494: AND wdt1.task_type = wdtv.wms_task_type_id)
2495: -- Bug 7254397: exclude tasks from locked cartons
2496: AND NOT EXISTS

Line 2583: FROM wms_dispatched_tasks wdt,

2579: qt.transaction_type_id,
2580: qt.transaction_action_id,
2581: qt.transaction_source_id,
2582: qt.transaction_source_type_id
2583: FROM wms_dispatched_tasks wdt,
2584: (SELECT
2585: transaction_temp_id task_id,
2586: pick_slip_number pick_slip,
2587: cartonization_id,

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

2615: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2616: --7169220: USERS LOCKED
2617: AND (mmtt.cartonization_id is null
2618: or not exists
2619: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2620: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2621: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2622: and wdt1.status = 9
2623: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2709: FROM wms_dispatched_tasks wdt,

2705: qt.transaction_type_id,
2706: qt.transaction_action_id,
2707: qt.transaction_source_id,
2708: qt.transaction_source_type_id
2709: FROM wms_dispatched_tasks wdt,
2710: (SELECT
2711: transaction_temp_id task_id,
2712: wms_task_status task_status, --bug 6326482 added to check for the previous state of dispatched tasks
2713: pick_slip_number pick_slip,

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

2742: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2743: --7169220: USERS LOCKED
2744: AND (mmtt.cartonization_id is null
2745: or not exists
2746: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2747: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2748: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2749: and wdt1.status = 9
2750: and mmtt1.cartonization_id = mmtt.cartonization_id)

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

2879: Decode(transaction_action_id, 2, decode(wms_task_type, 4, l_rep_allowed)))) = 1
2880: --7169220: USERS LOCKED
2881: AND (mmtt.cartonization_id is null
2882: or not exists
2883: (select 1 from mtl_material_transactions_temp mmtt1 ,wms_dispatched_tasks wdt1
2884: where mmtt1.transaction_temp_id <> mmtt.transaction_temp_id
2885: and wdt1.transaction_temp_id = mmtt1.transaction_temp_id
2886: and wdt1.status = 9
2887: and mmtt1.cartonization_id = mmtt.cartonization_id)

Line 2981: FROM wms_dispatched_tasks wdt1

2977: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
2978: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
2979: AND NOT EXISTS -- exclude tasks already dispatched and queued
2980: (SELECT NULL
2981: FROM wms_dispatched_tasks wdt1
2982: WHERE wdt1.transaction_temp_id = wdtv.task_id
2983: AND wdt1.task_type = wdtv.wms_task_type_id)
2984: -- Bug 7254397: exclude tasks from locked cartons
2985: AND NOT EXISTS

Line 3069: FROM wms_dispatched_tasks wdt,

3065: qt.transaction_type_id,
3066: qt.transaction_action_id,
3067: qt.transaction_source_id,
3068: qt.transaction_source_type_id
3069: FROM wms_dispatched_tasks wdt,
3070: (SELECT
3071: MIN(mcce.cycle_count_entry_id) task_id,
3072: TO_NUMBER(NULL) pick_slip,
3073: To_number(NULL) cartonization_id,

Line 3246: FROM wms_dispatched_tasks wdt1

3242: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
3243: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
3244: AND NOT EXISTS -- exclude tasks already dispatched and queued
3245: (SELECT NULL
3246: FROM wms_dispatched_tasks wdt1
3247: WHERE wdt1.transaction_temp_id = wdtv.task_id
3248: AND wdt1.task_type = wdtv.wms_task_type_id)
3249: -- excluded skipped tasks
3250: AND wdtv.task_id NOT IN

Line 3295: FROM wms_dispatched_tasks wdt

3291: WHERE mmtt.pick_slip_number = v_pick_slip_number
3292: AND NVL(mmtt.subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(mmtt.subinventory_code, '@@@'))
3293: -- Bug 14094713 added to lock only the tasks queued to that particular user
3294: AND NOT EXISTS ( SELECT 1
3295: FROM wms_dispatched_tasks wdt
3296: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
3297: AND wdt.person_id <> p_sign_on_emp_id
3298: )
3299: FOR UPDATE nowait;

Line 3314: FROM wms_dispatched_tasks wdt

3310: AND transaction_type_id = v_transaction_type_id
3311: AND NVL(subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(subinventory_code, '@@@'))
3312: -- Bug 14094713 added to lock only the tasks queued to that particular user
3313: AND NOT EXISTS ( SELECT 1
3314: FROM wms_dispatched_tasks wdt
3315: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
3316: AND wdt.person_id <> p_sign_on_emp_id
3317: )
3318: FOR UPDATE nowait;

Line 3486: FROM wms_dispatched_tasks wdt

3482: BEGIN
3483: SELECT transaction_temp_id, task_type, loaded_time
3484: INTO l_last_loaded_task_id, l_last_loaded_task_type, l_last_loaded_time
3485: FROM (SELECT transaction_temp_id, task_type, loaded_time
3486: FROM wms_dispatched_tasks wdt
3487: WHERE wdt.person_id = p_sign_on_emp_id
3488: AND wdt.loaded_time = (SELECT MAX(loaded_time)
3489: FROM wms_dispatched_tasks
3490: WHERE person_id = p_sign_on_emp_id))

Line 3489: FROM wms_dispatched_tasks

3485: FROM (SELECT transaction_temp_id, task_type, loaded_time
3486: FROM wms_dispatched_tasks wdt
3487: WHERE wdt.person_id = p_sign_on_emp_id
3488: AND wdt.loaded_time = (SELECT MAX(loaded_time)
3489: FROM wms_dispatched_tasks
3490: WHERE person_id = p_sign_on_emp_id))
3491: WHERE ROWNUM = 1; -- make sure only one task selected
3492:
3493: l_progress := '31';

Line 3512: FROM wms_dispatched_tasks_history wdth

3508:
3509: SELECT transaction_id, task_type, loaded_time
3510: INTO l_last_dropoff_task_id, l_last_dropoff_task_type, l_last_dropoff_time
3511: FROM (SELECT transaction_id, task_type, loaded_time
3512: FROM wms_dispatched_tasks_history wdth
3513: WHERE wdth.person_id = p_sign_on_emp_id
3514: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3515: FROM wms_dispatched_tasks_history
3516: WHERE person_id = p_sign_on_emp_id))

Line 3515: FROM wms_dispatched_tasks_history

3511: FROM (SELECT transaction_id, task_type, loaded_time
3512: FROM wms_dispatched_tasks_history wdth
3513: WHERE wdth.person_id = p_sign_on_emp_id
3514: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3515: FROM wms_dispatched_tasks_history
3516: WHERE person_id = p_sign_on_emp_id))
3517: WHERE ROWNUM = 1; -- make sure only one task selected
3518:
3519: l_progress := '33';

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

4202:
4203: /*Check if any task has been dispatched to other users for the same LPN*/
4204: IF l_lpn_id IS NOT NULL THEN
4205: l_wdt_count := 0 ;
4206: SELECT count(1) INTO l_wdt_count FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
4207: WHERE mmtt.cartonization_id = l_lpn_id
4208: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
4209: AND wdt.status in(3,9) AND wdt.person_id <> p_sign_on_emp_id ;
4210:

Line 4858: FROM wms_dispatched_tasks wdt1

4854: AND mmtt.parent_line_id IS NOT NULL
4855: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
4856: AND NOT EXISTS -- exclude tasks already dispatched
4857: (SELECT NULL
4858: FROM wms_dispatched_tasks wdt1
4859: WHERE wdt1.transaction_temp_id = wdtv.task_id
4860: AND wdt1.task_type = wdtv.wms_task_type_id)
4861: --******************
4862: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5014: FROM wms_dispatched_tasks wdt1

5010: AND mmtt.parent_line_id IS NOT NULL
5011: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5012: AND NOT EXISTS -- exclude tasks already dispatched
5013: (SELECT NULL
5014: FROM wms_dispatched_tasks wdt1
5015: WHERE wdt1.transaction_temp_id = wdtv.task_id
5016: AND wdt1.task_type = wdtv.wms_task_type_id)
5017: --******************
5018: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5167: FROM wms_dispatched_tasks wdt1

5163: AND mmtt.parent_line_id IS NOT NULL
5164: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5165: AND NOT EXISTS -- exclude tasks already dispatched
5166: (SELECT NULL
5167: FROM wms_dispatched_tasks wdt1
5168: WHERE wdt1.transaction_temp_id = wdtv.task_id
5169: AND wdt1.task_type = wdtv.wms_task_type_id)
5170: --******************
5171: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5321: FROM wms_dispatched_tasks wdt1

5317: AND mmtt.parent_line_id IS NOT NULL
5318: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5319: AND NOT EXISTS -- exclude tasks already dispatched
5320: (SELECT NULL
5321: FROM wms_dispatched_tasks wdt1
5322: WHERE wdt1.transaction_temp_id = wdtv.task_id
5323: AND wdt1.task_type = wdtv.wms_task_type_id)
5324: --******************
5325: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5476: FROM wms_dispatched_tasks wdt1

5472: AND mmtt.parent_line_id IS NOT NULL
5473: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5474: AND NOT EXISTS -- exclude tasks already dispatched
5475: (SELECT NULL
5476: FROM wms_dispatched_tasks wdt1
5477: WHERE wdt1.transaction_temp_id = wdtv.task_id
5478: AND wdt1.task_type = wdtv.wms_task_type_id)
5479: --******************
5480: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5629: FROM wms_dispatched_tasks wdt1

5625: AND mmtt.parent_line_id IS NOT NULL
5626: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5627: AND NOT EXISTS -- exclude tasks already dispatched
5628: (SELECT NULL
5629: FROM wms_dispatched_tasks wdt1
5630: WHERE wdt1.transaction_temp_id = wdtv.task_id
5631: AND wdt1.task_type = wdtv.wms_task_type_id)
5632: --******************
5633: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5780: FROM wms_dispatched_tasks wdt1

5776: AND mmtt.parent_line_id IS NOT NULL
5777: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5778: AND NOT EXISTS -- exclude tasks already dispatched
5779: (SELECT NULL
5780: FROM wms_dispatched_tasks wdt1
5781: WHERE wdt1.transaction_temp_id = wdtv.task_id
5782: AND wdt1.task_type = wdtv.wms_task_type_id)
5783: --******************
5784: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 5932: FROM wms_dispatched_tasks wdt1

5928: AND mmtt.parent_line_id IS NOT NULL
5929: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
5930: AND NOT EXISTS -- exclude tasks already dispatched
5931: (SELECT NULL
5932: FROM wms_dispatched_tasks wdt1
5933: WHERE wdt1.transaction_temp_id = wdtv.task_id
5934: AND wdt1.task_type = wdtv.wms_task_type_id)
5935: --******************
5936: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6082: FROM wms_dispatched_tasks wdt1

6078: AND mmtt.parent_line_id IS NOT NULL
6079: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6080: AND NOT EXISTS -- exclude tasks already dispatched
6081: (SELECT NULL
6082: FROM wms_dispatched_tasks wdt1
6083: WHERE wdt1.transaction_temp_id = wdtv.task_id
6084: AND wdt1.task_type = wdtv.wms_task_type_id)
6085: --******************
6086: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6236: FROM wms_dispatched_tasks wdt1

6232: AND mmtt.parent_line_id IS NOT NULL
6233: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6234: AND NOT EXISTS -- exclude tasks already dispatched
6235: (SELECT NULL
6236: FROM wms_dispatched_tasks wdt1
6237: WHERE wdt1.transaction_temp_id = wdtv.task_id
6238: AND wdt1.task_type = wdtv.wms_task_type_id)
6239: --******************
6240: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6384: FROM wms_dispatched_tasks wdt1

6380: AND mmtt.parent_line_id IS NOT NULL
6381: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6382: AND NOT EXISTS -- exclude tasks already dispatched
6383: (SELECT NULL
6384: FROM wms_dispatched_tasks wdt1
6385: WHERE wdt1.transaction_temp_id = wdtv.task_id
6386: AND wdt1.task_type = wdtv.wms_task_type_id)
6387: --******************
6388: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6535: FROM wms_dispatched_tasks wdt1

6531: AND mmtt.parent_line_id IS NOT NULL
6532: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
6533: AND NOT EXISTS -- exclude tasks already dispatched
6534: (SELECT NULL
6535: FROM wms_dispatched_tasks wdt1
6536: WHERE wdt1.transaction_temp_id = wdtv.task_id
6537: AND wdt1.task_type = wdtv.wms_task_type_id)
6538: --******************
6539: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 6672: FROM wms_dispatched_tasks wdt1

6668: AND wste.organization_id = mp.organization_id )
6669: --************
6670: AND wdtv.task_id NOT IN
6671: (SELECT wdt1.transaction_temp_id
6672: FROM wms_dispatched_tasks wdt1
6673: -- WHERE wdt1.status = 1
6674: UNION ALL
6675: SELECT wdt2.transaction_temp_id
6676: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

Line 6676: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

6672: FROM wms_dispatched_tasks wdt1
6673: -- WHERE wdt1.status = 1
6674: UNION ALL
6675: SELECT wdt2.transaction_temp_id
6676: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2
6677: WHERE wms_except.person_id = ' || p_sign_on_emp_id || '
6678: AND wdt2.task_id = wms_except.task_id
6679: AND discrepancy_type = 1
6680: )

Line 6702: FROM wms_dispatched_tasks wdt

6698: , l_last_loaded_time
6699: FROM (SELECT transaction_temp_id
6700: , task_type
6701: , loaded_time
6702: FROM wms_dispatched_tasks wdt
6703: WHERE wdt.person_id = p_sign_on_emp_id
6704: AND wdt.loaded_time = (SELECT MAX(loaded_time)
6705: FROM wms_dispatched_tasks
6706: WHERE person_id = p_sign_on_emp_id))

Line 6705: FROM wms_dispatched_tasks

6701: , loaded_time
6702: FROM wms_dispatched_tasks wdt
6703: WHERE wdt.person_id = p_sign_on_emp_id
6704: AND wdt.loaded_time = (SELECT MAX(loaded_time)
6705: FROM wms_dispatched_tasks
6706: WHERE person_id = p_sign_on_emp_id))
6707: WHERE ROWNUM = 1 -- make sure only one task selected
6708: ;
6709:

Line 6735: FROM wms_dispatched_tasks_history wdth

6731: , l_last_dropoff_time
6732: FROM (SELECT transaction_id
6733: , task_type
6734: , loaded_time
6735: FROM wms_dispatched_tasks_history wdth
6736: WHERE wdth.person_id = p_sign_on_emp_id
6737: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6738: FROM wms_dispatched_tasks_history
6739: WHERE person_id = p_sign_on_emp_id))

Line 6738: FROM wms_dispatched_tasks_history

6734: , loaded_time
6735: FROM wms_dispatched_tasks_history wdth
6736: WHERE wdth.person_id = p_sign_on_emp_id
6737: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6738: FROM wms_dispatched_tasks_history
6739: WHERE person_id = p_sign_on_emp_id))
6740: WHERE ROWNUM = 1 -- make sure only one task selected
6741: ;
6742:

Line 7773: FROM wms_dispatched_tasks wdt1

7769: AND mmtt.parent_line_id IS NOT NULL
7770: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7771: AND NOT EXISTS -- exclude tasks already dispatched
7772: (SELECT NULL
7773: FROM wms_dispatched_tasks wdt1
7774: WHERE wdt1.transaction_temp_id = wdtv.task_id
7775: AND wdt1.task_type = wdtv.wms_task_type_id)
7776: -- Join with delivery details
7777: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 7930: FROM wms_dispatched_tasks wdt1

7926: AND mmtt.parent_line_id IS NOT NULL
7927: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
7928: AND NOT EXISTS -- exclude tasks already dispatched
7929: (SELECT NULL
7930: FROM wms_dispatched_tasks wdt1
7931: WHERE wdt1.transaction_temp_id = wdtv.task_id
7932: AND wdt1.task_type = wdtv.wms_task_type_id)
7933: --******************
7934: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 8093: FROM wms_dispatched_tasks wdt1

8089: AND mmtt.parent_line_id IS NOT NULL
8090: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8091: AND NOT EXISTS -- exclude tasks already dispatched
8092: (SELECT NULL
8093: FROM wms_dispatched_tasks wdt1
8094: WHERE wdt1.transaction_temp_id = wdtv.task_id
8095: AND wdt1.task_type = wdtv.wms_task_type_id)
8096: -- Join with delivery details
8097: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 8249: FROM wms_dispatched_tasks wdt1

8245: AND mmtt.parent_line_id IS NOT NULL
8246: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8247: AND NOT EXISTS -- exclude tasks already dispatched
8248: (SELECT NULL
8249: FROM wms_dispatched_tasks wdt1
8250: WHERE wdt1.transaction_temp_id = wdtv.task_id
8251: AND wdt1.task_type = wdtv.wms_task_type_id)
8252: --******************
8253: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 8312: FROM wms_dispatched_tasks wdt,

8308: , wdt.effective_start_date
8309: , wdt.effective_end_date
8310: , wdt.person_resource_id
8311: , wdt.machine_resource_id
8312: FROM wms_dispatched_tasks wdt,
8313: (SELECT transaction_temp_id task_id
8314: , standard_operation_id user_task_type_id
8315: , wms_task_type wms_task_type_id
8316: , organization_id organization_id

Line 8490: FROM wms_dispatched_tasks wdt1

8486: AND mmtt.parent_line_id IS NOT NULL
8487: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8488: AND NOT EXISTS -- exclude tasks already dispatched
8489: (SELECT NULL
8490: FROM wms_dispatched_tasks wdt1
8491: WHERE wdt1.transaction_temp_id = wdtv.task_id
8492: AND wdt1.task_type = wdtv.wms_task_type_id)
8493: -- Join with delivery details
8494: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 8556: FROM wms_dispatched_tasks wdt,

8552: , wdt.effective_start_date
8553: , wdt.effective_end_date
8554: , wdt.person_resource_id
8555: , wdt.machine_resource_id
8556: FROM wms_dispatched_tasks wdt,
8557: (SELECT transaction_temp_id task_id
8558: , standard_operation_id user_task_type_id
8559: , wms_task_type wms_task_type_id
8560: , organization_id organization_id

Line 8718: FROM wms_dispatched_tasks wdt1

8714: AND mmtt.parent_line_id IS NOT NULL
8715: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8716: AND NOT EXISTS -- exclude tasks already dispatched
8717: (SELECT NULL
8718: FROM wms_dispatched_tasks wdt1
8719: WHERE wdt1.transaction_temp_id = wdtv.task_id
8720: AND wdt1.task_type = wdtv.wms_task_type_id)
8721: --******************
8722: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 8784: FROM wms_dispatched_tasks wdt,

8780: , wdt.effective_start_date
8781: , wdt.effective_end_date
8782: , wdt.person_resource_id
8783: , wdt.machine_resource_id
8784: FROM wms_dispatched_tasks wdt,
8785: (SELECT transaction_temp_id task_id
8786: , standard_operation_id user_task_type_id
8787: , wms_task_type wms_task_type_id
8788: , organization_id organization_id

Line 8962: FROM wms_dispatched_tasks wdt1

8958: AND mmtt.parent_line_id IS NOT NULL
8959: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
8960: AND NOT EXISTS -- exclude tasks already dispatched
8961: (SELECT NULL
8962: FROM wms_dispatched_tasks wdt1
8963: WHERE wdt1.transaction_temp_id = wdtv.task_id
8964: AND wdt1.task_type = wdtv.wms_task_type_id)
8965: -- Join with delivery details
8966: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 9018: FROM wms_dispatched_tasks wdt,

9014: , wdt.effective_start_date
9015: , wdt.effective_end_date
9016: , wdt.person_resource_id
9017: , wdt.machine_resource_id
9018: FROM wms_dispatched_tasks wdt,
9019: (SELECT transaction_temp_id task_id
9020: , standard_operation_id user_task_type_id
9021: , wms_task_type wms_task_type_id
9022: , organization_id organization_id

Line 9182: FROM wms_dispatched_tasks wdt1

9178: AND mmtt.parent_line_id IS NOT NULL
9179: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9180: AND NOT EXISTS -- exclude tasks already dispatched
9181: (SELECT NULL
9182: FROM wms_dispatched_tasks wdt1
9183: WHERE wdt1.transaction_temp_id = wdtv.task_id
9184: AND wdt1.task_type = wdtv.wms_task_type_id)
9185: --******************
9186: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 9248: FROM wms_dispatched_tasks wdt,

9244: , wdt.effective_start_date
9245: , wdt.effective_end_date
9246: , wdt.person_resource_id
9247: , wdt.machine_resource_id
9248: FROM wms_dispatched_tasks wdt,
9249: (SELECT transaction_temp_id task_id
9250: , standard_operation_id user_task_type_id
9251: , wms_task_type wms_task_type_id
9252: , organization_id organization_id

Line 9422: FROM wms_dispatched_tasks wdt1

9418: AND mmtt.parent_line_id IS NOT NULL
9419: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9420: AND NOT EXISTS -- exclude tasks already dispatched
9421: (SELECT NULL
9422: FROM wms_dispatched_tasks wdt1
9423: WHERE wdt1.transaction_temp_id = wdtv.task_id
9424: AND wdt1.task_type = wdtv.wms_task_type_id)
9425: -- Join with delivery details
9426: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 9487: FROM wms_dispatched_tasks wdt,

9483: , wdt.effective_start_date
9484: , wdt.effective_end_date
9485: , wdt.person_resource_id
9486: , wdt.machine_resource_id
9487: FROM wms_dispatched_tasks wdt,
9488: (SELECT transaction_temp_id task_id
9489: , standard_operation_id user_task_type_id
9490: , wms_task_type wms_task_type_id
9491: , organization_id organization_id

Line 9649: FROM wms_dispatched_tasks wdt1

9645: AND mmtt.parent_line_id IS NOT NULL
9646: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9647: AND NOT EXISTS -- exclude tasks already dispatched
9648: (SELECT NULL
9649: FROM wms_dispatched_tasks wdt1
9650: WHERE wdt1.transaction_temp_id = wdtv.task_id
9651: AND wdt1.task_type = wdtv.wms_task_type_id)
9652: --******************
9653: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 9712: FROM wms_dispatched_tasks wdt,

9708: , wdt.effective_start_date
9709: , wdt.effective_end_date
9710: , wdt.person_resource_id
9711: , wdt.machine_resource_id
9712: FROM wms_dispatched_tasks wdt,
9713: (SELECT transaction_temp_id task_id
9714: , standard_operation_id user_task_type_id
9715: , wms_task_type wms_task_type_id
9716: , organization_id organization_id

Line 9887: FROM wms_dispatched_tasks wdt1

9883: AND mmtt.parent_line_id IS NOT NULL
9884: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
9885: AND NOT EXISTS -- exclude tasks already dispatched
9886: (SELECT NULL
9887: FROM wms_dispatched_tasks wdt1
9888: WHERE wdt1.transaction_temp_id = wdtv.task_id
9889: AND wdt1.task_type = wdtv.wms_task_type_id)
9890: -- Join with delivery details
9891: AND(wdd.move_order_line_id = wdtv.move_order_line_id

Line 9943: FROM wms_dispatched_tasks wdt,

9939: , wdt.effective_start_date
9940: , wdt.effective_end_date
9941: , wdt.person_resource_id
9942: , wdt.machine_resource_id
9943: FROM wms_dispatched_tasks wdt,
9944: (SELECT transaction_temp_id task_id
9945: , standard_operation_id user_task_type_id
9946: , wms_task_type wms_task_type_id
9947: , organization_id organization_id

Line 10105: FROM wms_dispatched_tasks wdt1

10101: AND mmtt.parent_line_id IS NOT NULL
10102: AND mmtt.wms_task_type = wdtv.wms_task_type_id)
10103: AND NOT EXISTS -- exclude tasks already dispatched
10104: (SELECT NULL
10105: FROM wms_dispatched_tasks wdt1
10106: WHERE wdt1.transaction_temp_id = wdtv.task_id
10107: AND wdt1.task_type = wdtv.wms_task_type_id)
10108: --******************
10109: AND wdtv.task_id NOT IN -- excluded skipped tasks

Line 10230: FROM wms_dispatched_tasks wdt1

10226: AND wste.organization_id = mp.organization_id )
10227: --************
10228: AND wdtv.task_id NOT IN
10229: (SELECT wdt1.transaction_temp_id
10230: FROM wms_dispatched_tasks wdt1
10231: -- WHERE wdt1.status = 1
10232: UNION ALL
10233: SELECT wdt2.transaction_temp_id
10234: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

Line 10234: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2

10230: FROM wms_dispatched_tasks wdt1
10231: -- WHERE wdt1.status = 1
10232: UNION ALL
10233: SELECT wdt2.transaction_temp_id
10234: FROM wms_exceptions wms_except, wms_dispatched_tasks wdt2
10235: WHERE wms_except.person_id = ' || p_sign_on_emp_id || '
10236: AND wdt2.task_id = wms_except.task_id
10237: AND discrepancy_type = 1
10238: )

Line 10261: FROM wms_dispatched_tasks wdt

10257: , l_last_loaded_time
10258: FROM (SELECT transaction_temp_id
10259: , task_type
10260: , loaded_time
10261: FROM wms_dispatched_tasks wdt
10262: WHERE wdt.person_id = p_sign_on_emp_id
10263: AND wdt.loaded_time = (SELECT MAX(loaded_time)
10264: FROM wms_dispatched_tasks
10265: WHERE person_id = p_sign_on_emp_id))

Line 10264: FROM wms_dispatched_tasks

10260: , loaded_time
10261: FROM wms_dispatched_tasks wdt
10262: WHERE wdt.person_id = p_sign_on_emp_id
10263: AND wdt.loaded_time = (SELECT MAX(loaded_time)
10264: FROM wms_dispatched_tasks
10265: WHERE person_id = p_sign_on_emp_id))
10266: WHERE ROWNUM = 1; -- make sure only one task selected
10267:
10268: l_progress := '31';

Line 10293: FROM wms_dispatched_tasks_history wdth

10289: , l_last_dropoff_time
10290: FROM (SELECT transaction_id
10291: , task_type
10292: , loaded_time
10293: FROM wms_dispatched_tasks_history wdth
10294: WHERE wdth.person_id = p_sign_on_emp_id
10295: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
10296: FROM wms_dispatched_tasks_history
10297: WHERE person_id = p_sign_on_emp_id))

Line 10296: FROM wms_dispatched_tasks_history

10292: , loaded_time
10293: FROM wms_dispatched_tasks_history wdth
10294: WHERE wdth.person_id = p_sign_on_emp_id
10295: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
10296: FROM wms_dispatched_tasks_history
10297: WHERE person_id = p_sign_on_emp_id))
10298: WHERE ROWNUM = 1; -- make sure only one task selected
10299:
10300: l_progress := '33';