SQL Query to identify duplicate distributions for an Internal Requisition.

SELECT SEGMENT1,REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL 
WHERE REQUISITION_HEADER_ID IN (select REQUISITION_HEADER_ID from PO_REQUISITION_LINES_ALL where REQUISITION_LINE_ID not in 
(select REQUISITION_LINE_ID FROM PO_REQ_DISTRIBUTIONS_ALL) AND SOURCE_TYPE_CODE='INVENTORY') 
and org_id =&orgid and authorization_status='APPROVED';