eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_CONS_MAPPING_V

Product:	FII - Financial Intelligence (Obsolete)
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