Query to get all Internal Requisitions that do not have an associated Internal Sales Order

  SELECT rqh.segment1 req_num,

         rql.line_num,

         rql.requisition_header_id,

         rql.requisition_line_id,

         rql.item_id,

         rql.unit_meas_lookup_code,

         rql.unit_price,

         rql.quantity,

         rql.quantity_cancelled,

         rql.quantity_delivered,

         rql.cancel_flag,

         rql.source_type_code,

         rql.source_organization_id,

         rql.destination_organization_id,

         rqh.transferred_to_oe_flag

    FROM po_requisition_lines_all rql

    ,po_requisition_headers_all rqh

   WHERE rql.requisition_header_id = rqh.requisition_header_id

     AND rql.source_type_code = 'INVENTORY'

     AND rql.source_organization_id IS NOT NULL

     AND NOT EXISTS

(SELECT 'Y'--Existing Internal Order

   FROM oe_order_lines_all lin

       ,oe_order_sources order_source

  WHERE lin.source_document_line_id = rql.requisition_line_id

     AND lin.source_document_type_id = order_source.order_source_id

AND order_source.name = 'Internal'

)

ORDER BY rqh.requisition_header_id

        ,rql.line_num;