VIEW: DVSYS.KU$_DV_FACTOR_LINK_VIEW

Source

View Text - Preformatted

select '0','0',
          d1.name,
          d2.name,
          m.label_ind
  from    dvsys.factor_link$   m,
          dvsys.factor$        d1,
          dvsys.factor$        d2
  where   d1.id# = m.parent_factor_id#
    and   d2.id# = m.child_factor_id#
    and   m.id# >= 5000
    and   (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990 OR
           EXISTS ( SELECT * FROM sys.session_roles
                    WHERE role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, D1.NAME
, D2.NAME
, M.LABEL_IND
FROM DVSYS.FACTOR_LINK$ M
, DVSYS.FACTOR$ D1
, DVSYS.FACTOR$ D2
WHERE D1.ID# = M.PARENT_FACTOR_ID#
AND D2.ID# = M.CHILD_FACTOR_ID#
AND M.ID# >= 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))