VIEW: APPS.OKL_CS_CONT_INV_RECEIPTS_UV

Source

View Text - Preformatted

SELECT TRXUV.KHR_ID, TRXUV.CASH_RECEIPT_ID, TRXUV.INVOICE_NUMBER, TRXUV.RECEIPT_NUMBER, TRXUV.RECEIPT_DATE, TRXUV.RECEIPT_STATUS, TRXUV.RECEIPT_CURRENCY_CODE, TRXUV.RECEIPT_AMOUNT, (SELECT SUM(APP_LINE.AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL APP_LINE WHERE APP_LINE.CASH_RECEIPT_ID = TRXUV.CASH_RECEIPT_ID AND APP_LINE.APPLIED_CUSTOMER_TRX_ID = TRXUV.INVOICE_ID AND APP_LINE.STATUS = 'APP' AND APP_LINE.APPLICATION_TYPE = 'CASH') AMOUNT_APPLIED, TRXUV.RECEIPT_TYPE_CODE, TRXUV.PAYMENT_METHOD, TRXUV.ADVANCED_YN, TRXUV.INVOICE_DATE, TRXUV.CUST_ACCOUNT_ID, TRXUV.UNAPPLIED_AMOUNT, TRXUV.ONACCOUNT_AMOUNT, TRXUV.INVOICE_CURRENCY_CODE FROM OKL_CS_TRX_PAYMENTS_UV TRXUV WHERE TRXUV.khr_id = TRXUV.khr_id GROUP BY TRXUV.KHR_ID, TRXUV.CASH_RECEIPT_ID, TRXUV.INVOICE_NUMBER, TRXUV.RECEIPT_NUMBER, TRXUV.RECEIPT_DATE, TRXUV.RECEIPT_STATUS, TRXUV.RECEIPT_CURRENCY_CODE, TRXUV.RECEIPT_AMOUNT, TRXUV.RECEIPT_TYPE_CODE, TRXUV.PAYMENT_METHOD, TRXUV.ADVANCED_YN, TRXUV.INVOICE_DATE, TRXUV.CUST_ACCOUNT_ID, TRXUV.INVOICE_CURRENCY_CODE, TRXUV.INVOICE_ID, TRXUV.UNAPPLIED_AMOUNT, TRXUV.ONACCOUNT_AMOUNT

View Text - HTML Formatted

SELECT TRXUV.KHR_ID
, TRXUV.CASH_RECEIPT_ID
, TRXUV.INVOICE_NUMBER
, TRXUV.RECEIPT_NUMBER
, TRXUV.RECEIPT_DATE
, TRXUV.RECEIPT_STATUS
, TRXUV.RECEIPT_CURRENCY_CODE
, TRXUV.RECEIPT_AMOUNT
, (SELECT SUM(APP_LINE.AMOUNT_APPLIED)
FROM AR_RECEIVABLE_APPLICATIONS_ALL APP_LINE
WHERE APP_LINE.CASH_RECEIPT_ID = TRXUV.CASH_RECEIPT_ID
AND APP_LINE.APPLIED_CUSTOMER_TRX_ID = TRXUV.INVOICE_ID
AND APP_LINE.STATUS = 'APP'
AND APP_LINE.APPLICATION_TYPE = 'CASH') AMOUNT_APPLIED
, TRXUV.RECEIPT_TYPE_CODE
, TRXUV.PAYMENT_METHOD
, TRXUV.ADVANCED_YN
, TRXUV.INVOICE_DATE
, TRXUV.CUST_ACCOUNT_ID
, TRXUV.UNAPPLIED_AMOUNT
, TRXUV.ONACCOUNT_AMOUNT
, TRXUV.INVOICE_CURRENCY_CODE
FROM OKL_CS_TRX_PAYMENTS_UV TRXUV
WHERE TRXUV.KHR_ID = TRXUV.KHR_ID GROUP BY TRXUV.KHR_ID
, TRXUV.CASH_RECEIPT_ID
, TRXUV.INVOICE_NUMBER
, TRXUV.RECEIPT_NUMBER
, TRXUV.RECEIPT_DATE
, TRXUV.RECEIPT_STATUS
, TRXUV.RECEIPT_CURRENCY_CODE
, TRXUV.RECEIPT_AMOUNT
, TRXUV.RECEIPT_TYPE_CODE
, TRXUV.PAYMENT_METHOD
, TRXUV.ADVANCED_YN
, TRXUV.INVOICE_DATE
, TRXUV.CUST_ACCOUNT_ID
, TRXUV.INVOICE_CURRENCY_CODE
, TRXUV.INVOICE_ID
, TRXUV.UNAPPLIED_AMOUNT
, TRXUV.ONACCOUNT_AMOUNT