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_DISPATCH_TASKS_GTMP

Line 114: insert into WMS_DISPATCH_TASKS_GTMP

110:
111: savepoint store_locked_tasks;
112:
113: -- Inserting the data into temp table
114: insert into WMS_DISPATCH_TASKS_GTMP
115: (
116: grouping_document_type,
117: grouping_document_number,
118: grouping_source_type_id

Line 152: DELETE FROM WMS_DISPATCH_TASKS_GTMP

148:
149: savepoint remove_stored_cartons;
150:
151: -- remove the data from temp table
152: DELETE FROM WMS_DISPATCH_TASKS_GTMP
153: WHERE GROUPING_DOCUMENT_NUMBER IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id));
154:
155: IF (l_debug = 1) THEN
156: print_debug('Exit REMOVE_STORED_CARTONS ' , 1);

Line 172: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE

168: PROCEDURE remove_stored_order_num(x_return_status OUT NOCOPY VARCHAR2) IS
169: BEGIN
170: x_return_status := fnd_api.g_ret_sts_success;
171: savepoint remove_stored_order_numbers;
172: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE
173: GROUPING_DOCUMENT_NUMBER IN (
174: SELECT MMTT.TRANSACTION_SOURCE_ID
175: FROM MTL_SALES_ORDERS MSO ,
176: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

Line 190: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE

186: PROCEDURE remove_stored_pick_slip_num(x_return_status OUT NOCOPY VARCHAR2) IS
187: BEGIN
188: x_return_status := fnd_api.g_ret_sts_success;
189: savepoint remove_store_pick_slip_numbers;
190: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE
191: GROUPING_DOCUMENT_NUMBER IN
192: (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers));
193: EXCEPTION
194: WHEN OTHERS THEN

Line 567: FROM WMS_DISPATCH_TASKS_GTMP

563: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
564: -- bug 4358107
565: AND NOT EXISTS
566: ( SELECT 1
567: FROM WMS_DISPATCH_TASKS_GTMP
568: WHERE (p_task_method = 'DISCRETE'
569: and
570: grouping_document_number = wdtv.pick_slip_number
571: )

Line 916: FROM WMS_DISPATCH_TASKS_GTMP

912: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
913: -- bug 4358107
914: AND NOT EXISTS
915: ( SELECT 1
916: FROM WMS_DISPATCH_TASKS_GTMP
917: WHERE (p_task_method = 'DISCRETE'
918: and
919: grouping_document_number = wdtv.pick_slip_number
920: )

Line 1153: FROM WMS_DISPATCH_TASKS_GTMP

1149: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
1150: -- bug 4358107
1151: AND NOT EXISTS
1152: ( SELECT 1
1153: FROM WMS_DISPATCH_TASKS_GTMP
1154: WHERE (p_task_method = 'DISCRETE'
1155: and
1156: grouping_document_number = wdtv.pick_slip_number
1157: )

Line 1473: FROM WMS_DISPATCH_TASKS_GTMP

1469: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
1470: -- bug 4358107
1471: AND NOT EXISTS
1472: ( SELECT 1
1473: FROM WMS_DISPATCH_TASKS_GTMP
1474: WHERE (p_task_method = 'DISCRETE'
1475: and
1476: grouping_document_number = wdtv.pick_slip_number
1477: )

Line 1820: FROM WMS_DISPATCH_TASKS_GTMP

1816: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
1817: -- bug 4358107
1818: AND NOT EXISTS
1819: ( SELECT 1
1820: FROM WMS_DISPATCH_TASKS_GTMP
1821: WHERE (p_task_method = 'DISCRETE'
1822: and
1823: grouping_document_number = wdtv.pick_slip_number
1824: )

Line 2051: FROM WMS_DISPATCH_TASKS_GTMP

2047: --AND Nvl(wdtv.pick_slip_number, -1) <> l_pick_slip -- bug 2832818
2048: -- bug 4358107
2049: AND NOT EXISTS
2050: ( SELECT 1
2051: FROM WMS_DISPATCH_TASKS_GTMP
2052: WHERE (p_task_method = 'DISCRETE'
2053: and
2054: grouping_document_number = wdtv.pick_slip_number
2055: )

Line 2498: FROM WMS_DISPATCH_TASKS_GTMP

2494: AND wdt1.task_type = wdtv.wms_task_type_id)
2495: -- Bug 7254397: exclude tasks from locked cartons
2496: AND NOT EXISTS
2497: ( SELECT 1
2498: FROM WMS_DISPATCH_TASKS_GTMP
2499: WHERE p_task_method = 'CLUSTERPICKBYLABEL'
2500: AND
2501: grouping_document_number = wdtv.cartonization_id)
2502: --Added for Case Picking Project start

Line 2505: FROM WMS_DISPATCH_TASKS_GTMP

2501: grouping_document_number = wdtv.cartonization_id)
2502: --Added for Case Picking Project start
2503: AND NOT EXISTS
2504: ( SELECT 1
2505: FROM WMS_DISPATCH_TASKS_GTMP
2506: WHERE p_task_method = 'MANIFESTPICKSLIP'
2507: AND grouping_document_number = wdtv.pick_slip_number)
2508: AND NOT EXISTS
2509: ( SELECT 1

Line 2510: FROM WMS_DISPATCH_TASKS_GTMP

2506: WHERE p_task_method = 'MANIFESTPICKSLIP'
2507: AND grouping_document_number = wdtv.pick_slip_number)
2508: AND NOT EXISTS
2509: ( SELECT 1
2510: FROM WMS_DISPATCH_TASKS_GTMP
2511: WHERE p_task_method = 'MANIFESTORDER'
2512: AND grouping_document_number = wdtv.transaction_source_id)
2513: --Added for Case Picking Project end
2514: -- excluded skipped tasks

Line 2987: FROM WMS_DISPATCH_TASKS_GTMP

2983: AND wdt1.task_type = wdtv.wms_task_type_id)
2984: -- Bug 7254397: exclude tasks from locked cartons
2985: AND NOT EXISTS
2986: ( SELECT 1
2987: FROM WMS_DISPATCH_TASKS_GTMP
2988: WHERE p_task_method = 'CLUSTERPICKBYLABEL'
2989: AND
2990: grouping_document_number = wdtv.cartonization_id)
2991: --Added for Case Picking Project start

Line 2994: FROM WMS_DISPATCH_TASKS_GTMP

2990: grouping_document_number = wdtv.cartonization_id)
2991: --Added for Case Picking Project start
2992: AND NOT EXISTS
2993: ( SELECT 1
2994: FROM WMS_DISPATCH_TASKS_GTMP
2995: WHERE p_task_method = 'MANIFESTPICKSLIP'
2996: AND grouping_document_number = wdtv.pick_slip_number)
2997: AND NOT EXISTS
2998: ( SELECT 1

Line 2999: FROM WMS_DISPATCH_TASKS_GTMP

2995: WHERE p_task_method = 'MANIFESTPICKSLIP'
2996: AND grouping_document_number = wdtv.pick_slip_number)
2997: AND NOT EXISTS
2998: ( SELECT 1
2999: FROM WMS_DISPATCH_TASKS_GTMP
3000: WHERE p_task_method = 'MANIFESTORDER'
3001: AND grouping_document_number = wdtv.transaction_source_id)
3002: --Added for Case Picking Project end
3003: -- excluded skipped taskS