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 2215: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))

2211: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2212: -1) = nvl(v_transaction_source_id, -1))
2213: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2214: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2215: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))
2216: -- Bug: 7254397
2217: AND NVL(e.equipment_id, -999) = NVL(l_sign_on_equipment_id, NVL(e.equipment_id, -999))
2218: AND wdt.user_task_type = e.standard_operation_id(+)
2219: AND qt.move_order_line_id = mol.line_id(+)

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

2383: 13, Decode(wdtv.transaction_type_id, 51, wdtv.transaction_source_id),
2384: -1) = nvl(v_transaction_source_id, -1))
2385: OR (p_task_method = 'PICKBYLABEL' AND wdtv.cartonization_id = l_cartonization_id)
2386: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2387: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))
2388: AND wdtv.organization_id = p_sign_on_org_id
2389: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
2390: AND NVL(wdtv.subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(wdtv.subinventory_code, '@@@')) AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))
2391: AND NVL(v.eqp_id, -999) = NVL(l_sign_on_equipment_id, NVL(v.eqp_id, -999))

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

2556: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2557: -1) = nvl(v_transaction_source_id, -1))
2558: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2559: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2560: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))
2561: AND NVL(e.equipment_id, -999) = NVL(l_q_sign_on_equipment_id, NVL(e.equipment_id, -999))--bug 6326482
2562: AND wdt.user_task_type = e.standard_operation_id(+)
2563: AND qt.move_order_line_id = mol.line_id(+)
2564: AND NVL(qt.subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(qt.subinventory_code, '@@@'))

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

2665: 13, Decode(qt.transaction_type_id, 51, qt.transaction_source_id),
2666: -1) = nvl(v_transaction_source_id, -1))
2667: OR (p_task_method = 'PICKBYLABEL' AND qt.cartonization_id = l_cartonization_id)
2668: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2669: qt.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))
2670: -- -bug 6326482
2671: AND ((qt.task_status is NULL
2672: AND NVL(e.equipment_id, -999) = NVL(l_q_sign_on_equipment_id, NVL(e.equipment_id, -999)))
2673: or

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

2804: 13, Decode(wdtv.transaction_type_id, 51, wdtv.transaction_source_id),
2805: -1) = nvl(v_transaction_source_id, -1))
2806: OR (p_task_method = 'PICKBYLABEL' AND wdtv.cartonization_id = l_cartonization_id)
2807: OR (p_task_method = 'CLUSTERPICKBYLABEL' AND
2808: wdtv.cartonization_id IN (SELECT * FROM TABLE(wms_picking_pkg.list_cartonization_id))))
2809: AND wdtv.organization_id = p_sign_on_org_id
2810: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
2811: AND NVL(wdtv.subinventory_code, '@@@') = NVL(p_sign_on_zone, NVL(wdtv.subinventory_code, '@@@'))
2812: AND NVL(v.eqp_id, -999) = NVL(l_sign_on_equipment_id, NVL(v.eqp_id, -999))

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

3162: WHERE task_filter_name = v_filter_name
3163: AND wtf.task_filter_id = wtfd.task_filter_id;
3164:
3165: CURSOR lpn_ids_cur IS
3166: SELECT column_value LPN_ID FROM TABLE(wms_picking_pkg.list_cartonization_id);
3167:
3168: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3169:
3170: BEGIN

Line 3511: l_total_lpns := wms_picking_pkg.get_total_lpns;

3507: END IF;
3508: --Bug 7254397, added loop for detecting and storing
3509: IF p_task_method = 'CLUSTERPICKBYLABEL' THEN
3510: BEGIN
3511: l_total_lpns := wms_picking_pkg.get_total_lpns;
3512: l_locked_lpns := 0;
3513: FOR lpn_id_rec IN lpn_ids_cur
3514: LOOP
3515: IF l_debug = 1 THEN