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