VIEW: APPS.OKL_CURE_RFND_VND_DTLS_UV

Source

View Text - Preformatted

SELECT 'VENDOR_SITE','Vendor Site', contract_currency_code, vendor_name, vendor_id, vendor_site_id, vendor_cure_due, to_char(vendor_site_cure_due), sum(refund_amount_due) FROM OKL_CURE_REFUNDS_DTLS_UV group by 1,2 ,contract_currency_code ,vendor_name ,vendor_id ,vendor_site_id ,vendor_cure_due ,vendor_site_cure_due UNION ALL select 'ACROSS_SITES','Include All Sites', contract_currency_code, vendor_name, vendor_id, to_number(null) vendor_site_id, vendor_cure_due, '  ' vendor_site_cure_due, sum(refund_amount_due) from okl_cure_refunds_dtls_uv group by 1,2 ,contract_currency_code ,vendor_name ,vendor_id ,vendor_site_id ,vendor_cure_due ,vendor_site_cure_due

View Text - HTML Formatted

SELECT 'VENDOR_SITE'
, 'VENDOR SITE'
, CONTRACT_CURRENCY_CODE
, VENDOR_NAME
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CURE_DUE
, TO_CHAR(VENDOR_SITE_CURE_DUE)
, SUM(REFUND_AMOUNT_DUE)
FROM OKL_CURE_REFUNDS_DTLS_UV GROUP BY 1
, 2
, CONTRACT_CURRENCY_CODE
, VENDOR_NAME
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CURE_DUE
, VENDOR_SITE_CURE_DUE UNION ALL SELECT 'ACROSS_SITES'
, 'INCLUDE ALL SITES'
, CONTRACT_CURRENCY_CODE
, VENDOR_NAME
, VENDOR_ID
, TO_NUMBER(NULL) VENDOR_SITE_ID
, VENDOR_CURE_DUE
, ' ' VENDOR_SITE_CURE_DUE
, SUM(REFUND_AMOUNT_DUE)
FROM OKL_CURE_REFUNDS_DTLS_UV GROUP BY 1
, 2
, CONTRACT_CURRENCY_CODE
, VENDOR_NAME
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CURE_DUE
, VENDOR_SITE_CURE_DUE