VIEW: APPS.FII_AR_RESR_REV_SRC_LCV

Source

View Text - Preformatted

SELECT 'AR REV', 'ALL', 'AR Revenue', 'AR Revenue', 'AR Revenue', 'AR Revenue', substr(edw_instance.get_code,1,40), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, sysdate -1 from dual union all select 'AR ADJ', 'ALL', 'AR Adjustment', 'AR Adjustment', 'AR Adjustment', 'AR Adjustment', substr(edw_instance.get_code,1,40), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, sysdate -1 from dual union all select 'PA REV', 'ALL', 'PA Revenue', 'PA Revenue', 'PA Revenue', 'PA Revenue', substr(edw_instance.get_code,1,40), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, sysdate -1 from dual union all select 'GL MA', 'ALL', 'GL Manual Adjustment', 'GL Manual Adjustment', 'GL Manual Adjustment', 'GL Manual Adjustment', substr(edw_instance.get_code,1,40), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, sysdate -1 from dual

View Text - HTML Formatted

SELECT 'AR REV'
, 'ALL'
, 'AR REVENUE'
, 'AR REVENUE'
, 'AR REVENUE'
, 'AR REVENUE'
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SYSDATE -1
FROM DUAL UNION ALL SELECT 'AR ADJ'
, 'ALL'
, 'AR ADJUSTMENT'
, 'AR ADJUSTMENT'
, 'AR ADJUSTMENT'
, 'AR ADJUSTMENT'
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SYSDATE -1
FROM DUAL UNION ALL SELECT 'PA REV'
, 'ALL'
, 'PA REVENUE'
, 'PA REVENUE'
, 'PA REVENUE'
, 'PA REVENUE'
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SYSDATE -1
FROM DUAL UNION ALL SELECT 'GL MA'
, 'ALL'
, 'GL MANUAL ADJUSTMENT'
, 'GL MANUAL ADJUSTMENT'
, 'GL MANUAL ADJUSTMENT'
, 'GL MANUAL ADJUSTMENT'
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SYSDATE -1
FROM DUAL