Oracle Order Management Queries -2

Following sql query retrieve the Internal Requisition details which were

transferred to OM , but Internal Sales Orders were NOT created.



SELECT poh.org_id,
       poh.segment1 Requisition_Number,
       poh.requisition_header_id,
       poh.creation_date,
       poh.created_by,
       poh.last_update_date,
       poh.last_updated_by
  FROM po_requisition_headers_all poh 
  where poh.authorization_status = 'APPROVED'  
 AND poh.transferred_to_oe_flag = 'Y'  
 AND poh.type_lookup_code = 'INTERNAL' 
  and NOT EXISTS (
SELECT 1
  FROM oe_order_headers_all h
 WHERE h.order_source_id = 10

       AND h.source_document_id = poh.requisition_header_id)  AND TRUNC(poh.creation_date) BETWEEN TO_DATE ('&from_date', 'DD-MM-RR')          AND TO_DATE ('&To_Date','DD-MM-RR');