VIEW: APPS.IGI_MPP_NON_MPP_INVOICES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )