Product: | FII - Financial Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FII_AR_RESR_REV_SRC_LCV |
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