293: FROM wsh_delivery_details wdd,
294: wsh_delivery_assignments_v wda,
295: mtl_item_locations mil,
296: mtl_secondary_inventories msi,
297: wms_dispatched_tasks_history wdth
298: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
299: wdd.released_status = 'Y' AND
300: wdd.locator_id = mil.inventory_location_id AND
301: nvl(mil.inventory_location_type, 3) = G_LOC_TYPE_CONSOLIDATION AND
372: wsh_delivery_assignments_v wda,
373: mtl_txn_request_lines mol,
374: mtl_item_locations mil,
375: mtl_secondary_inventories msi,
376: wms_dispatched_tasks_history wdth
377: WHERE
378: mol.line_id = wdd.move_order_line_id AND
379: wdd.released_status = 'Y' AND
380: wdd.locator_id = mil.inventory_location_id AND