VIEW: SYS.USER_DIM_CHILD_OF

Source

View Text - Preformatted

select d."OWNER",d."DIMENSION_NAME",d."HIERARCHY_NAME",d."POSITION",d."CHILD_LEVEL_NAME",d."JOIN_KEY_ID",d."PARENT_LEVEL_NAME" FROM dba_dim_child_of d, sys.user$ u
where u.user# = userenv('SCHEMAID')
  and d.owner = u.name

View Text - HTML Formatted

SELECT D."OWNER"
, D."DIMENSION_NAME"
, D."HIERARCHY_NAME"
, D."POSITION"
, D."CHILD_LEVEL_NAME"
, D."JOIN_KEY_ID"
, D."PARENT_LEVEL_NAME"
FROM DBA_DIM_CHILD_OF D
, SYS.USER$ U WHERE U.USER# = USERENV('SCHEMAID')
AND D.OWNER = U.NAME