View: OKL_BPD_RECEIPT_DETAILS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_RECEIPT_DETAILS_UV

View Text

SELECT ARCASH.RECEIPT_NUMBER CHECK_NUMBER
, ARCASH.CURRENCY_CODE
, ARCASH.RECEIPT_DATE
, ARRCPT.NAME RECEIPT_METHOD
, ARCASH.AMOUNT REMITTANCE_AMOUNT
, NVL(ARAPP.GL_POSTED_DATE
, SYSDATE) GL_DATE
, ARAPP.AMOUNT_APPLIED
, CNSLD.ID CNR_ID
FROM OKL_CNSLD_AR_STRMS_B CNSLD
, AR_CASH_RECEIPTS_ALL ARCASH
, AR_PAYMENT_SCHEDULES_ALL PMTSCH
, AR_RECEIPT_METHODS ARRCPT
, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
WHERE CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID
AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID
AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID
AND PMTSCH.CLASS = 'INV'
AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID

Columns