VIEW: APPS.OKL_CS_CONT_VENDOR_INVOICES_UV

Source

View Text - Preformatted

SELECT customer_acct_id, invoice_id, chr_id AS khr_id, invoice_number, invoice_date, due_date, invoice_currency_code, invoice_amount, (SELECT SUM(nvl(extended_amount, 0)) FROM ra_customer_trx_lines_all WHERE line_type = 'TAX' AND link_to_cust_trx_line_id IN (SELECT customer_trx_line_id FROM ra_customer_trx_lines_all WHERE customer_trx_id = ar_invoice_id) ) tax_amount, okl_billing_util_pvt.invoice_amount_applied(ar_invoice_id) amount_applied, okl_billing_util_pvt.invoice_amount_credited(ar_invoice_id) amount_credited, okl_billing_util_pvt.invoice_amount_remaining(ar_invoice_id) amount_remaining, payment_term, mo_utils.get_org_name(org_id) operating_unit, trx_status, invoice_pull_yn, org_id, okl_billing_util_pvt.invoice_amount_adjusted(ar_invoice_id) amount_adjusted FROM OKL_CS_VENDOR_INVOICE_DTLS_UV WHERE 1=1 GROUP BY customer_acct_id, chr_id, invoice_id, invoice_number, invoice_date, due_date, invoice_currency_code, invoice_amount, payment_term, org_id, trx_status, invoice_pull_yn, ar_invoice_id

View Text - HTML Formatted

SELECT CUSTOMER_ACCT_ID
, INVOICE_ID
, CHR_ID AS KHR_ID
, INVOICE_NUMBER
, INVOICE_DATE
, DUE_DATE
, INVOICE_CURRENCY_CODE
, INVOICE_AMOUNT
, (SELECT SUM(NVL(EXTENDED_AMOUNT
, 0))
FROM RA_CUSTOMER_TRX_LINES_ALL
WHERE LINE_TYPE = 'TAX'
AND LINK_TO_CUST_TRX_LINE_ID IN (SELECT CUSTOMER_TRX_LINE_ID
FROM RA_CUSTOMER_TRX_LINES_ALL
WHERE CUSTOMER_TRX_ID = AR_INVOICE_ID) ) TAX_AMOUNT
, OKL_BILLING_UTIL_PVT.INVOICE_AMOUNT_APPLIED(AR_INVOICE_ID) AMOUNT_APPLIED
, OKL_BILLING_UTIL_PVT.INVOICE_AMOUNT_CREDITED(AR_INVOICE_ID) AMOUNT_CREDITED
, OKL_BILLING_UTIL_PVT.INVOICE_AMOUNT_REMAINING(AR_INVOICE_ID) AMOUNT_REMAINING
, PAYMENT_TERM
, MO_UTILS.GET_ORG_NAME(ORG_ID) OPERATING_UNIT
, TRX_STATUS
, INVOICE_PULL_YN
, ORG_ID
, OKL_BILLING_UTIL_PVT.INVOICE_AMOUNT_ADJUSTED(AR_INVOICE_ID) AMOUNT_ADJUSTED
FROM OKL_CS_VENDOR_INVOICE_DTLS_UV
WHERE 1=1 GROUP BY CUSTOMER_ACCT_ID
, CHR_ID
, INVOICE_ID
, INVOICE_NUMBER
, INVOICE_DATE
, DUE_DATE
, INVOICE_CURRENCY_CODE
, INVOICE_AMOUNT
, PAYMENT_TERM
, ORG_ID
, TRX_STATUS
, INVOICE_PULL_YN
, AR_INVOICE_ID