[Home] [Help]
View: EDW_CONS_MAPPING_V
Product: | FII - Financial Intelligence |
Description: | Internal view used for consolidation package |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CFH.CHILD_FLEX_VALUE_LOW CHILD_LOW
, CFH.CHILD_FLEX_VALUE_HIGH CHILD_HIGH
, CFH.PARENT_FLEX_VALUE PARENT
, CSM.CONSOLIDATION_ID CONSOLIDATION_ID
, CSM.SEGMENT_MAP_TYPE SEGMENT_MAP_TYPE
, CSM.SEGMENT_MAP_ID SEGMENT_MAP_ID
, CSM.FROM_VALUE_SET_ID FROM_VALUE_SET_ID
, CSM.TO_VALUE_SET_ID TO_VALUE_SET_ID
FROM GL_CONS_SEGMENT_MAP CSM
, GL_CONS_FLEX_HIERARCHIES CFH
WHERE CFH.SEGMENT_MAP_ID = CSM.SEGMENT_MAP_ID
AND CSM.SEGMENT_MAP_TYPE = 'R' UNION ALL SELECT CSM.PARENT_ROLLUP_VALUE CHILD_LOW
, CSM.PARENT_ROLLUP_VALUE CHILD_HIGH
, CSM.SINGLE_VALUE PARENT
, CSM.CONSOLIDATION_ID CONSOLIDATION_ID
, CSM.SEGMENT_MAP_TYPE SEGMENT_MAP_TYPE
, CSM.SEGMENT_MAP_ID SEGMENT_MAP_ID
, CSM.FROM_VALUE_SET_ID FROM_VALUE_SET_ID
, CSM.TO_VALUE_SET_ID TO_VALUE_SET_ID
FROM GL_CONS_SEGMENT_MAP CSM
WHERE CSM.SEGMENT_MAP_TYPE = 'P'
Columns
Name |
CHILD_LOW |
CHILD_HIGH |
PARENT |
CONSOLIDATION_ID |
SEGMENT_MAP_TYPE |
SEGMENT_MAP_ID |
FROM_VALUE_SET_ID |
TO_VALUE_SET_ID |