DBA_DIM_CHILD_OF

Representaion of a 1: n hierarchical relationship between a pair of levels in a dimension

Columns
   ___________________________
 
   OWNER
      Owner of the dimension
   DIMENSION_NAME
      Name of the dimension
   HIERARCHY_NAME
      Name of the hierarchy
   POSITION
      Hierarchical position within this hierarchy,position 1 being the most detailed
   CHILD_LEVEL_NAME
      Name of the child-side level of this 1:n relationship
   JOIN_KEY_ID
      Keys that join child uniquely to the parent
   PARENT_LEVEL_NAME
      Name of the parent-side level of this 1:n relationship