View: OKL_CS_PPD_RECEIPTS_UV

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

View Text

SELECT REC.CASH_RECEIPT_ID RECEIPT_ID
, CASH.RECEIPT_NUMBER RECEIPT_NUMBER
, CASH.RECEIPT_DATE RECEIPT_DATE
, CASH.PAY_FROM_CUSTOMER CUST_ACCOUNT_ID
, SUM(REC.AMOUNT_APPLIED) AMOUNT
, CASH.CURRENCY_CODE CURRENCY_CODE
FROM AR_RECEIVABLE_APPLICATIONS_ALL REC
, AR_CASH_RECEIPTS CASH
WHERE REC.CASH_RECEIPT_ID = CASH.CASH_RECEIPT_ID
AND REC.STATUS IN ('ACC') GROUP BY REC.CASH_RECEIPT_ID
, CASH.RECEIPT_NUMBER
, CASH.RECEIPT_DATE
, CASH.PAY_FROM_CUSTOMER
, CASH.CURRENCY_CODE HAVING SUM(REC.AMOUNT_APPLIED) >0

Columns