Order status detail query

SELECT   ooh.order_number,
         ool.line_number || '.' || ool.shipment_number line_number,
         ool.ordered_item, ool.ordered_quantity, ool.shipped_quantity,
         flv.meaning status
    FROM oe_order_headers_v ooh,
         oe_order_lines_v ool,
         wsh_delivery_details wdd,
         fnd_lookup_values flv
   WHERE ooh.header_id = ool.header_id
     AND ooh.header_id = wdd.source_header_id
     AND ool.line_id = wdd.source_line_id
     AND wdd.released_status = flv.lookup_code
     AND flv.lookup_type LIKE 'PICK_STATUS%'
--and flv.meaning='Interfaced'
     AND TO_CHAR (ooh.creation_date, 'MON-YYYY') = 'JUL-2013'
ORDER BY 1, 2