[Home] [Help]
View: 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
Name |
REFUND_TYPE |
REFUND_TYPE_MEANING |
CURRENCY_CODE |
VENDOR_NAME |
VENDOR_ID |
VENDOR_SITE_ID |
VENDOR_CURE_DUE |
VENDOR_SITE_CURE_DUE |
REFUND_AMOUNT_DUE |