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.

VIEW: APPS.CNDIHY_ROOT_NODES

Source

View Text - Preformatted


SELECT he.dim_hierarchy_id, he.value_id, max(hn.name), count(distinct exp.value_id) FROM CN_HIERARCHY_NODES HN,CN_DIM_EXPLOSION EXP,CN_HIERARCHY_EDGES HE where exp.ancestor_id = he.value_id and exp.dim_hierarchy_id = he.dim_hierarchy_id and hn.value_id = he.value_id and hn.dim_hierarchy_id = he.dim_hierarchy_id and he.parent_value_id is null group by he.dim_hierarchy_id,he.value_id

View Text - HTML Formatted

SELECT HE.DIM_HIERARCHY_ID
, HE.VALUE_ID
, MAX(HN.NAME)
, COUNT(DISTINCT EXP.VALUE_ID)
FROM CN_HIERARCHY_NODES HN
, CN_DIM_EXPLOSION EXP
, CN_HIERARCHY_EDGES HE
WHERE EXP.ANCESTOR_ID = HE.VALUE_ID
AND EXP.DIM_HIERARCHY_ID = HE.DIM_HIERARCHY_ID
AND HN.VALUE_ID = HE.VALUE_ID
AND HN.DIM_HIERARCHY_ID = HE.DIM_HIERARCHY_ID
AND HE.PARENT_VALUE_ID IS NULL GROUP BY HE.DIM_HIERARCHY_ID
, HE.VALUE_ID