View: OKL_CS_AP_INVS_PAYMENTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_AP_INVS_PAYMENTS_UV

View Text

SELECT AC.CHECK_DATE PAYMENT_DATE
, ALC.DISPLAYED_FIELD PAYMENT_METHOD
, APS.GROSS_AMOUNT AMOUNT
, APS.INVOICE_ID INVOICE_ID
, APS.PAYMENT_NUM PAYMENT_NUM
, AC.CURRENCY_CODE CURRENCY
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.BANK_ACCOUNT_NAME BANK_NAME
, AC.BANK_ACCOUNT_NUM BANK_ACCOUNT
FROM AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICE_PAYMENTS_ALL AIP
, AP_CHECKS_ALL AC
, AP_LOOKUP_CODES ALC
WHERE APS.HOLD_FLAG = 'N'
AND AIP.INVOICE_ID = APS.INVOICE_ID
AND AIP.PAYMENT_NUM = APS.PAYMENT_NUM
AND AIP.CHECK_ID = AC.CHECK_ID
AND ALC.LOOKUP_TYPE = 'PAYMENT METHOD'
AND ALC.LOOKUP_CODE = APS.PAYMENT_METHOD_CODE

Columns