View: IGI_EXP_AP_INV_V

Product:	IGI - Public Sector Financials International
Description:	Displays all unposted invoices awaiting release of exchange protocol hold.
Implementation/DBA Data:	APPS.IGI_EXP_AP_INV_V

View Text

SELECT I.ROWID ROW_ID
, I.INVOICE_ID
, I.INVOICE_NUM
, I.DESCRIPTION
, V.VENDOR_NAME
, I.VENDOR_ID
, S.VENDOR_SITE_CODE
, I.VENDOR_SITE_ID
, I.INVOICE_AMOUNT
, F.USER_NAME
, I.CREATED_BY
, I.CREATION_DATE
, I.INVOICE_TYPE_LOOKUP_CODE
, I.INVOICE_CURRENCY_CODE
FROM AP_HOLDS H
, AP_INVOICES I
, FND_USER F
, IGI_AP_INVOICES IAI
, PO_VENDORS V
, PO_VENDOR_SITES S
WHERE I.VENDOR_ID = V.VENDOR_ID
AND I.VENDOR_SITE_ID = S.VENDOR_SITE_ID
AND I.CREATED_BY = F.USER_ID
AND IAI.DIAL_UNIT_ID IS NULL
AND I.INVOICE_ID = H.INVOICE_ID
AND I.INVOICE_ID = IAI.INVOICE_ID(+)
AND H.HOLD_LOOKUP_CODE = 'AWAIT EXP APP'
AND H.RELEASE_LOOKUP_CODE IS NULL AND EXISTS (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS D WHERE D.INVOICE_ID = I.INVOICE_ID AND NVL(D.POSTED_FLAG
, 'N') = 'N')

Columns