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_BPD_RECEIPT_DETAILS_UV

Source

View Text - Preformatted


SELECT ARCASH.RECEIPT_NUMBER CHECK_NUMBER, ARCASH.CURRENCY_CODE, ARCASH.RECEIPT_DATE, ARRCPT.NAME RECEIPT_METHOD, ARCASH.AMOUNT REMITTANCE_AMOUNT, NVL(ARAPP.GL_POSTED_DATE,SYSDATE) GL_DATE, ARAPP.AMOUNT_APPLIED, CNSLD.ID CNR_ID FROM OKL_CNSLD_AR_STRMS_B CNSLD,AR_CASH_RECEIPTS_ALL ARCASH,AR_PAYMENT_SCHEDULES_ALL PMTSCH,AR_RECEIPT_METHODS ARRCPT,AR_RECEIVABLE_APPLICATIONS_ALL ARAPP WHERE CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID and ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id and PMTSCH.class = 'INV' and ARAPP.cash_receipt_id = ARCASH.cash_receipt_id

View Text - HTML Formatted

SELECT ARCASH.RECEIPT_NUMBER CHECK_NUMBER
, ARCASH.CURRENCY_CODE
, ARCASH.RECEIPT_DATE
, ARRCPT.NAME RECEIPT_METHOD
, ARCASH.AMOUNT REMITTANCE_AMOUNT
, NVL(ARAPP.GL_POSTED_DATE
, SYSDATE) GL_DATE
, ARAPP.AMOUNT_APPLIED
, CNSLD.ID CNR_ID
FROM OKL_CNSLD_AR_STRMS_B CNSLD
, AR_CASH_RECEIPTS_ALL ARCASH
, AR_PAYMENT_SCHEDULES_ALL PMTSCH
, AR_RECEIPT_METHODS ARRCPT
, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
WHERE CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID
AND ARRCPT.RECEIPT_METHOD_ID = ARCASH.RECEIPT_METHOD_ID
AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID
AND PMTSCH.CLASS = 'INV'
AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID