SELECT POH.SEGMENT1 SEGMENT1 , NULL PO_RELEASE_ID , POH.PO_HEADER_ID PO_HEADER_ID , NULL RELEASE_NUM , POH.VENDOR_ID VENDOR_ID , POH.VENDOR_SITE_ID VENDOR_SITE_ID FROM PO_HEADERS_ALL POH WHERE POH.AUTHORIZATION_STATUS = 'APPROVED' AND NVL(POH.CANCEL_FLAG , 'N') = 'N' AND NVL(POH.USER_HOLD_FLAG , 'N') = 'N' AND NVL(POH.APPROVED_FLAG , 'N') = 'Y' AND NVL(POH.CLOSED_CODE , '$$') NOT LIKE ('%CLOSED%') AND EXISTS (SELECT 1 FROM PO_LINES_ALL POL WHERE POL.LINE_TYPE_ID IN (SELECT LINE_TYPE_ID FROM PO_LINE_TYPES_B WHERE OUTSIDE_OPERATION_FLAG = 'Y') AND POL.PO_HEADER_ID= POH.PO_HEADER_ID) AND NOT EXISTS ( SELECT 1 FROM PO_RELEASES_ALL WHERE PO_HEADER_ID = POH.PO_HEADER_ID ) UNION ALL SELECT POH.SEGMENT1 , POR.PO_RELEASE_ID , POH.PO_HEADER_ID , POR.RELEASE_NUM , POH.VENDOR_ID , POH.VENDOR_SITE_ID FROM PO_HEADERS_ALL POH , PO_RELEASES_ALL POR WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID AND POR.AUTHORIZATION_STATUS = 'APPROVED' AND NVL(POR.CANCEL_FLAG , 'N') = 'N' AND NVL(POR.HOLD_FLAG , 'N') = 'N' AND NVL(POR.APPROVED_FLAG , 'N')= 'Y' AND NVL(POR.CLOSED_CODE , '$$') NOT LIKE ('%CLOSED%') AND EXISTS (SELECT 1 FROM PO_LINES_ALL POL WHERE POL.LINE_TYPE_ID IN (SELECT LINE_TYPE_ID FROM PO_LINE_TYPES_B WHERE OUTSIDE_OPERATION_FLAG = 'Y') AND POL.PO_HEADER_ID= POH.PO_HEADER_ID)