[Home] [Help]
View: OKL_CS_UNAPPLIED_CASH_UV
Product: | OKL - Lease 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
Name |
RECEIPT_ID |
RECEIPT_NUMBER |
RECEIPT_DATE |
CUST_ACCOUNT_ID |
AMOUNT |
CURRENCY_CODE |