FND Design Data [Home] [Help]

View: OKL_CS_UNAPPLIED_CASH_UV

Product: OKL - Leasing and Finance Management
Description: Unapplied Cash for a customer Account
Implementation/DBA Data: ViewAPPS.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

Name
RECEIPT_ID
RECEIPT_NUMBER
RECEIPT_DATE
CUST_ACCOUNT_ID
AMOUNT
CURRENCY_CODE