View: IGI_MPP_NON_MPP_INVOICES_V

Product:	IGI - Public Sector Financials International
Description:	Contains invoices that are not used by Multi Period Posting
Implementation/DBA Data:	APPS.IGI_MPP_NON_MPP_INVOICES_V

View Text

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 )

Columns