DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_SALES_ORDERS

Line 2660: AND mmtt.transaction_source_id IN ( SELECT sales_order_id FROM mtl_sales_orders WHERE segment1 IN (SELECT * FROM TABLE(list_order_numbers)) ) --Modified for bug 13644087,previously comparing transaction source id with order number

2656: AND mmtt.locator_id = mil.inventory_location_id
2657: AND mmtt.organization_id = mil.organization_id
2658: AND wdt.task_method = 'MANIFESTORDER'
2659: AND mmtt.transaction_source_type_id = p_grouping_source_type_id
2660: AND mmtt.transaction_source_id IN ( SELECT sales_order_id FROM mtl_sales_orders WHERE segment1 IN (SELECT * FROM TABLE(list_order_numbers)) ) --Modified for bug 13644087,previously comparing transaction source id with order number
2661: AND wdt.task_group_id = g_group_sequence_number
2662: AND mmtt.parent_line_id IS NULL -- Added for bulk task
2663: ORDER BY msi.picking_order, mil.picking_order, wdt.priority , wdt.status , wdt.task_id
2664: )