View: IGI_AP_INVOICE_PAY_V

Product:	IGI - Public Sector Financials International
Description:	Provides invoices which are awaiting payment approval.
Implementation/DBA Data:	APPS.IGI_AP_INVOICE_PAY_V

View Text

SELECT DISTINCT API.INVOICE_ID
, NULL
, NULL
, API.BATCH_ID
, API.VENDOR_ID
, APB.BATCH_NAME
, POV.VENDOR_NAME
, API.INVOICE_NUM
, API.INVOICE_DATE
, API.INVOICE_AMOUNT
, FU.USER_NAME
, API.CREATED_BY
, API.CREATION_DATE
, API.LAST_UPDATED_BY
, API.LAST_UPDATE_DATE
, API.LAST_UPDATE_LOGIN
, 'Y'
, API.ROWID
FROM AP_HOLDS AH
, AP_INVOICES API
, AP_BATCHES APB
, FND_USER FU
, PO_VENDORS POV
WHERE API.BATCH_ID = APB.BATCH_ID(+)
AND API.VENDOR_ID = POV.VENDOR_ID(+)
AND FU.USER_ID = API.CREATED_BY
AND AH.HOLD_LOOKUP_CODE = 'AWAIT_PAY_APP'
AND AH.RELEASE_LOOKUP_CODE IS NULL
AND AH.INVOICE_ID = API.INVOICE_ID
AND EXISTS (SELECT 'X'
FROM AP_HOLDS AH
WHERE AH.HOLD_LOOKUP_CODE = 'AWAIT_SEC_APP'
AND AH.RELEASE_LOOKUP_CODE IS NOT NULL
AND AH.INVOICE_ID = API.INVOICE_ID)

Columns