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_PARENTS_V

Source

View Text - Preformatted


SELECT he.value_id, he.parent_value_id, he.dim_hierarchy_id, exp.ancestor_id FROM CN_HIERARCHY_EDGES HE,CN_DIM_EXPLOSION EXP,CN_HIERARCHY_EDGES HE2 where he.parent_value_id = exp.value_id AND he.dim_hierarchy_id = exp.dim_hierarchy_id AND exp.ancestor_id = he2.value_id AND exp.dim_hierarchy_id = he2.dim_hierarchy_id AND he2.parent_value_id IS NULL

View Text - HTML Formatted

SELECT HE.VALUE_ID
, HE.PARENT_VALUE_ID
, HE.DIM_HIERARCHY_ID
, EXP.ANCESTOR_ID
FROM CN_HIERARCHY_EDGES HE
, CN_DIM_EXPLOSION EXP
, CN_HIERARCHY_EDGES HE2
WHERE HE.PARENT_VALUE_ID = EXP.VALUE_ID
AND HE.DIM_HIERARCHY_ID = EXP.DIM_HIERARCHY_ID
AND EXP.ANCESTOR_ID = HE2.VALUE_ID
AND EXP.DIM_HIERARCHY_ID = HE2.DIM_HIERARCHY_ID
AND HE2.PARENT_VALUE_ID IS NULL