View: OKL_CS_UNAPPLIED_CASH_UV

Product:	OKL - Leasing and Finance Management
Description:	Unapplied Cash for a customer Account
Implementation/DBA Data:	APPS.OKL_CS_UNAPPLIED_CASH_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 ('UNAPP'
, '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