VIEW: APPS.OKL_BPD_TRX_SUM_CHECKS_UV

Source

View Text - Preformatted

SELECT ARAPP.AMOUNT_APPLIED, ARCASH.RECEIPT_NUMBER, ARRCPT.NAME, ARCASH.RECEIPT_DATE, CNSLD.ID FROM OKC_K_HEADERS_B CHR,OKL_CNSLD_AR_STRMS_B CNSLD,AR_PAYMENT_SCHEDULES_ALL PMTSCH,AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,AR_CASH_RECEIPTS_ALL ARCASH,AR_RECEIPT_METHODS ARRCPT WHERE CHR.ID = CNSLD.KHR_ID AND 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 ARAPP.AMOUNT_APPLIED
, ARCASH.RECEIPT_NUMBER
, ARRCPT.NAME
, ARCASH.RECEIPT_DATE
, CNSLD.ID
FROM OKC_K_HEADERS_B CHR
, OKL_CNSLD_AR_STRMS_B CNSLD
, AR_PAYMENT_SCHEDULES_ALL PMTSCH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIPT_METHODS ARRCPT
WHERE CHR.ID = CNSLD.KHR_ID
AND 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