SELECT AIV.INVOICE_TYPE , AIV.VENDOR_NAME , AIV.VENDOR_NUMBER , AIV.VENDOR_SITE_CODE , AIV.INVOICE_DATE , AIV.INVOICE_NUM , AIV.INVOICE_CURRENCY_CODE , AIV.INVOICE_AMOUNT , AIV.GL_DATE , AIV.INVOICE_ID , AIV.APPROVAL_STATUS_LOOKUP_CODE FROM AP_INVOICES_V AIV WHERE AIV.APPROVAL_STATUS_LOOKUP_CODE = 'APPROVED' AND NOT EXISTS ( SELECT 'X' FROM IGI_MPP_AP_INVOICES MAI WHERE MAI.INVOICE_ID = AIV.INVOICE_ID ) AND NOT EXISTS ( SELECT 'X' FROM IGI_MPP_INVOICE_TRANSFER MIT WHERE MIT.INVOICE_ID = AIV.INVOICE_ID )