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_PICKING_PKG

Line 153: WHERE GROUPING_DOCUMENT_NUMBER IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id));

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);
157: END IF;

Line 178: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

174: SELECT MMTT.TRANSACTION_SOURCE_ID
175: FROM MTL_SALES_ORDERS MSO ,
176: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
177: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
178: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
179: );
180: EXCEPTION
181: WHEN OTHERS THEN
182: rollback to remove_stored_order_numbers;

Line 192: (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers));

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
195: rollback to remove_stored_pick_slip_number;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2257: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))

2253: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2254: -1) = nvl(v_transaction_source_id, -1))
2255: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2256: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2257: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))
2258: --Added for Case Picking Project start
2259: OR ( p_task_method = 'MANIFESTORDER' AND
2260: qt.transaction_source_id IN (
2261: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 2265: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

2261: SELECT MMTT.TRANSACTION_SOURCE_ID
2262: FROM MTL_SALES_ORDERS MSO ,
2263: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2264: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2265: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2266: )
2267: and qt.parent_line_id IS NULL -- Added for bulk task
2268: )
2269: OR (p_task_method = 'MANIFESTPICKSLIP'

Line 2270: AND qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))

2266: )
2267: and qt.parent_line_id IS NULL -- Added for bulk task
2268: )
2269: OR (p_task_method = 'MANIFESTPICKSLIP'
2270: AND qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))
2271: and qt.parent_line_id IS NULL -- Added for bulk task
2272: )
2273: --Added for Case Picking Project end
2274: )

Line 2450: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))

2446: 13, Decode(wdtv.transaction_type_id, 51, wdtv.transaction_source_id),
2447: -1) = nvl(v_transaction_source_id, -1))
2448: OR (p_task_method = 'PICKBYLABEL' AND wdtv.cartonization_id = l_cartonization_id)
2449: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2450: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))
2451: --Added for Case Picking Project start
2452: OR ( p_task_method = 'MANIFESTORDER' AND
2453: wdtv.transaction_source_id IN (
2454: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 2458: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

2454: SELECT MMTT.TRANSACTION_SOURCE_ID
2455: FROM MTL_SALES_ORDERS MSO ,
2456: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2457: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2458: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2459: )
2460: and wdtv.parent_line_id IS NULL -- Added for bulk task
2461: )
2462: OR (p_task_method = 'MANIFESTPICKSLIP'

Line 2463: AND wdtv.pick_slip_number IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))

2459: )
2460: and wdtv.parent_line_id IS NULL -- Added for bulk task
2461: )
2462: OR (p_task_method = 'MANIFESTPICKSLIP'
2463: AND wdtv.pick_slip_number IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))
2464: and wdtv.parent_line_id IS NULL -- Added for bulk task
2465: )
2466: --Added for Case Picking Project end
2467: )

Line 2653: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))

2649: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2650: -1) = nvl(v_transaction_source_id, -1))
2651: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2652: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2653: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))
2654: --Added for Case Picking Project start
2655: OR ( p_task_method = 'MANIFESTORDER' AND
2656: qt.transaction_source_id IN (
2657: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 2661: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

2657: SELECT MMTT.TRANSACTION_SOURCE_ID
2658: FROM MTL_SALES_ORDERS MSO ,
2659: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2660: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2661: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2662: )
2663: and qt.parent_line_id IS NULL -- Added for bulk task
2664: )
2665: OR (p_task_method = 'MANIFESTPICKSLIP'

Line 2666: AND qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))

2662: )
2663: and qt.parent_line_id IS NULL -- Added for bulk task
2664: )
2665: OR (p_task_method = 'MANIFESTPICKSLIP'
2666: AND qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))
2667: and qt.parent_line_id IS NULL -- Added for bulk task
2668: )
2669: --Added for Case Picking Project end
2670: )

Line 2780: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))

2776: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2777: -1) = nvl(v_transaction_source_id, -1))
2778: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2779: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2780: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))
2781: --Added for Case Picking Project start
2782: OR ( p_task_method = 'MANIFESTORDER' AND
2783: qt.transaction_source_id IN (
2784: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 2788: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

2784: SELECT MMTT.TRANSACTION_SOURCE_ID
2785: FROM MTL_SALES_ORDERS MSO ,
2786: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2787: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2788: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2789: )
2790: and qt.parent_line_id IS NULL -- Added for bulk task
2791: )
2792: OR (p_task_method = 'MANIFESTPICKSLIP' AND

Line 2793: qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))

2789: )
2790: and qt.parent_line_id IS NULL -- Added for bulk task
2791: )
2792: OR (p_task_method = 'MANIFESTPICKSLIP' AND
2793: qt.pick_slip IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))
2794: and qt.parent_line_id IS NULL -- Added for bulk task
2795: )
2796: --Added for Case Picking Project end
2797: )

Line 2939: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))

2935: 13, Decode(wdtv.transaction_type_id, 51, wdtv.transaction_source_id),
2936: -1) = nvl(v_transaction_source_id, -1))
2937: OR (p_task_method = 'PICKBYLABEL' AND wdtv.cartonization_id = l_cartonization_id)
2938: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2939: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id)))
2940: --Added for Case Picking Project start
2941: OR ( p_task_method = 'MANIFESTORDER' AND
2942: wdtv.transaction_source_id IN (
2943: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 2947: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))

2943: SELECT MMTT.TRANSACTION_SOURCE_ID
2944: FROM MTL_SALES_ORDERS MSO ,
2945: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
2946: WHERE MMTT.TRANSACTION_SOURCE_ID = MSO.SALES_ORDER_ID
2947: AND MSO.SEGMENT1 IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.LIST_ORDER_NUMBERS))
2948: )
2949: and wdtv.parent_line_id IS NULL -- Added for bulk task
2950: )
2951: OR (p_task_method = 'MANIFESTPICKSLIP'

Line 2952: AND wdtv.pick_slip_number IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))

2948: )
2949: and wdtv.parent_line_id IS NULL -- Added for bulk task
2950: )
2951: OR (p_task_method = 'MANIFESTPICKSLIP'
2952: AND wdtv.pick_slip_number IN (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers))
2953: and wdtv.parent_line_id IS NULL -- Added for bulk task
2954: )
2955: --Added for Case Picking Project end
2956: )

Line 3342: SELECT column_value pick_slip_number FROM TABLE(wms_picking_pkg.list_pick_slip_numbers);

3338:
3339: --Added for Case Picking Project start
3340:
3341: CURSOR c_pick_slip_numbers IS
3342: SELECT column_value pick_slip_number FROM TABLE(wms_picking_pkg.list_pick_slip_numbers);
3343:
3344: CURSOR c_order_numbers IS
3345: SELECT mso.sales_order_id FROM TABLE(wms_picking_pkg.list_order_numbers) lon , mtl_sales_orders mso
3346: WHERE mso.segment1 = lon.column_value;

Line 3345: SELECT mso.sales_order_id FROM TABLE(wms_picking_pkg.list_order_numbers) lon , mtl_sales_orders mso

3341: CURSOR c_pick_slip_numbers IS
3342: SELECT column_value pick_slip_number FROM TABLE(wms_picking_pkg.list_pick_slip_numbers);
3343:
3344: CURSOR c_order_numbers IS
3345: SELECT mso.sales_order_id FROM TABLE(wms_picking_pkg.list_order_numbers) lon , mtl_sales_orders mso
3346: WHERE mso.segment1 = lon.column_value;
3347:
3348:
3349: CURSOR c_manifest_order_lock_check(v_sales_order_id NUMBER) IS

Line 3359: SELECT column_value LPN_ID FROM TABLE(wms_picking_pkg.list_cartonization_id);

3355: --Added for Case Picking Project end
3356:
3357:
3358: CURSOR lpn_ids_cur IS
3359: SELECT column_value LPN_ID FROM TABLE(wms_picking_pkg.list_cartonization_id);
3360:
3361: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3362:
3363: BEGIN

Line 3704: l_total_lpns := wms_picking_pkg.get_total_lpns;

3700: END IF;
3701: --Bug 7254397, added loop for detecting and storing
3702: IF p_task_method = 'CLUSTERPICKBYLABEL' THEN
3703: BEGIN
3704: l_total_lpns := wms_picking_pkg.get_total_lpns;
3705: l_locked_lpns := 0;
3706: FOR lpn_id_rec IN lpn_ids_cur
3707: LOOP
3708: IF l_debug = 1 THEN

Line 4541: --in WMS_PICKING_PKG.NEXT_TASK while returning the dispatched tasks.

4537: --Tasks for manifest picking are not returned based on the x_grouping_document_number,they are based
4538: --on TABLE(list_order_numbers).Refer get_next_task_in_group for criteria used to return tasks for manifest picking.
4539: --So here just assigning the l_transaction_source_id returned from the l_curs_ordered_tasks_xx cursor
4540: --so as to just satisy the condition "p_task_method NOT IN ('MANUAL') AND x_grouping_document_number IS NOT NULL"
4541: --in WMS_PICKING_PKG.NEXT_TASK while returning the dispatched tasks.
4542: x_grouping_document_number := l_transaction_source_id;
4543: IF l_debug = 1 THEN
4544: print_debug('PRINTING x_grouping_document_number for MANIFEST ORDER Picking::'||x_grouping_document_number, 4);
4545: END IF;

Line 4556: --WMS_PICKING_PKG.get_next_task_in_group for MANIFESTPICKSLIP task method.

4552: remove_stored_pick_slip_num(x_return_status => l_return_status);
4553: print_debug('dispatch_task - remove_stored_pick_slip_numbers l_return_status'||l_return_status, 4);
4554: --Adding below for Bug 13644087 - START - Here not assigning the transaction source type id beacuse i)there may
4555: --different transaction source types ii)transaction source type is not a criteria in fetching the tasks in
4556: --WMS_PICKING_PKG.get_next_task_in_group for MANIFESTPICKSLIP task method.
4557: x_grouping_document_number := l_pick_slip;
4558: IF l_debug = 1 THEN
4559: print_debug('PRINTING x_grouping_document_number for MANIFEST PICK SLIP Picking::'||x_grouping_document_number, 4);
4560: END IF;