eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_UNAPPLIED_CASH_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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