APPS.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_SALES_ORDERS

Line 175: FROM MTL_SALES_ORDERS MSO ,

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
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: );

Line 2262: FROM MTL_SALES_ORDERS MSO ,

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
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: )

Line 2455: FROM MTL_SALES_ORDERS MSO ,

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
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: )

Line 2658: FROM MTL_SALES_ORDERS MSO ,

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
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: )

Line 2785: FROM MTL_SALES_ORDERS MSO ,

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
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: )

Line 2944: FROM MTL_SALES_ORDERS MSO ,

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
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: )

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 4290: SELECT SEGMENT1 INTO l_transaction_source_id FROM mtl_sales_orders WHERE sales_order_id=l_transaction_source_id;

4286: fnd_msg_pub.ADD;
4287: RAISE fnd_api.g_exc_error;
4288: ELSIF p_task_method = 'ORDERPICK' THEN
4289: IF l_transaction_type_id = 52 THEN
4290: SELECT SEGMENT1 INTO l_transaction_source_id FROM mtl_sales_orders WHERE sales_order_id=l_transaction_source_id;
4291: END IF;
4292: FND_MESSAGE.set_name('WMS', 'WMS_LOCKED_ORDERPICK_TASK');
4293: FND_MESSAGE.set_token('ENTITY1',l_transaction_source_id);
4294: fnd_msg_pub.ADD;