Query to find Sales Orders that are shipped but not invoiced

1SELECT b.order_number,
2       a.line_number,
3       a.ordered_item,
4       a.line_type_id,
5       a.ordered_quantity,
6       a.shipped_quantity,
7       a.freight_terms_code,
8       b.order_type_id
9  FROM apps.oe_order_lines_all a, apps.oe_order_headers_all b
10 WHERE     a.header_id = b.header_id
11       AND a.FLOW_Status_CODE = 'CLOSED'
12       AND NVL (a.INVOICE_INTERFACE_STATUS_CODE, 'NO') <> 'YES'
13       AND a.SOLD_FROM_ORG_ID = '123'
14       AND b.org_id = '123'
15       AND ORDER_TYPE_ID <> 1005