View: OKL_CURE_RFND_VND_DTLS_UV

Product:	OKL - Leasing and Finance Management
Description:	View by Vendor refunds
Implementation/DBA Data:	APPS.OKL_CURE_RFND_VND_DTLS_UV

View Text

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

Columns