View: ICX_AP_INVOICE_PAYMENTS_V

Product:	ICX - Oracle iProcurement
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ICX_AP_INVOICE_PAYMENTS_V

View Text

SELECT AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.CHECK_ID CHECK_ID
, AC.CURRENCY_CODE CHECK_CURRENCY_CODE
, AC.VENDOR_SITE_ID VENDOR_SITE_ID
, TO_CHAR(AIP.AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE
, 30)) AMOUNT
, TO_CHAR(NVL(AIP.DISCOUNT_TAKEN
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE
, 30)) DISCOUNT_TAKEN
, AIP.ACCOUNTING_DATE ACCOUNTING_DATE
, AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
FROM AP_INVOICE_PAYMENTS AIP
, AP_INVOICES AI
, AP_CHECKS AC
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.CHECK_ID = AC.CHECK_ID

Columns