VIEW: APPS.GL_CONS_ROLLUP_RANGES_V

Source

View Text - Preformatted

SELECT cfh.rowid, cfh.child_flex_value_low, cfh.child_flex_value_high, cfh.last_update_date, cfh.last_updated_by, cfh.creation_date, cfh.created_by, cfh.last_update_login, cfh.segment_map_id, cfh.parent_flex_value, -1, 'R' FROM GL_CONS_FLEX_HIERARCHIES cfh UNION ALL SELECT cfh.rowid, cfh.child_flex_value_low, cfh.child_flex_value_high, cfh.last_update_date, cfh.last_updated_by, cfh.creation_date, cfh.created_by, cfh.last_update_login, cfh.segment_map_id, cfh.parent_flex_value, -1, 'U' FROM GL_CONS_FLEX_HIERARCHIES cfh UNION ALL SELECT fvh.rowid, fvh.child_flex_value_low, fvh.child_flex_value_high, fvh.last_update_date, fvh.last_updated_by, fvh.creation_date, fvh.created_by, fvh.last_update_login, -1, fvh.parent_flex_value, fvh.flex_value_set_id, 'P' FROM FND_FLEX_VALUE_HIERARCHIES fvh

View Text - HTML Formatted

SELECT CFH.ROWID
, CFH.CHILD_FLEX_VALUE_LOW
, CFH.CHILD_FLEX_VALUE_HIGH
, CFH.LAST_UPDATE_DATE
, CFH.LAST_UPDATED_BY
, CFH.CREATION_DATE
, CFH.CREATED_BY
, CFH.LAST_UPDATE_LOGIN
, CFH.SEGMENT_MAP_ID
, CFH.PARENT_FLEX_VALUE
, -1
, 'R'
FROM GL_CONS_FLEX_HIERARCHIES CFH UNION ALL SELECT CFH.ROWID
, CFH.CHILD_FLEX_VALUE_LOW
, CFH.CHILD_FLEX_VALUE_HIGH
, CFH.LAST_UPDATE_DATE
, CFH.LAST_UPDATED_BY
, CFH.CREATION_DATE
, CFH.CREATED_BY
, CFH.LAST_UPDATE_LOGIN
, CFH.SEGMENT_MAP_ID
, CFH.PARENT_FLEX_VALUE
, -1
, 'U'
FROM GL_CONS_FLEX_HIERARCHIES CFH UNION ALL SELECT FVH.ROWID
, FVH.CHILD_FLEX_VALUE_LOW
, FVH.CHILD_FLEX_VALUE_HIGH
, FVH.LAST_UPDATE_DATE
, FVH.LAST_UPDATED_BY
, FVH.CREATION_DATE
, FVH.CREATED_BY
, FVH.LAST_UPDATE_LOGIN
, -1
, FVH.PARENT_FLEX_VALUE
, FVH.FLEX_VALUE_SET_ID
, 'P'
FROM FND_FLEX_VALUE_HIERARCHIES FVH