VIEW: DVSYS.KU$_DV_IDENTITY_MAP_VIEW

Source

View Text - Preformatted

select '0','0',
          d6.name,
          d1.value,
          d4.name,
          d5.name,
          d2.code,
          m.operand1,
          m.operand2
  from    dvsys.identity_map$           m,
          dvsys.identity$               d1,
          dvsys.code$                   d2,
          dvsys.factor_link$            d3,
          dvsys.factor$                 d4,
          dvsys.factor$                 d5,
          dvsys.factor$                 d6
  where   d1.id# = m.identity_id#
    and   m.id# >= 5000
    and   d2.id# = m.operation_code_id#
    and   d2.code_group = 'OPERATORS'
    and   d3.id# (+)= m.factor_link_id#
    and   d4.id# (+)= d3.parent_factor_id#
    and   d5.id# (+)= d3.child_factor_id#
    and   d6.id# = d1.factor_id#
    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'
, D6.NAME
, D1.VALUE
, D4.NAME
, D5.NAME
, D2.CODE
, M.OPERAND1
, M.OPERAND2
FROM DVSYS.IDENTITY_MAP$ M
, DVSYS.IDENTITY$ D1
, DVSYS.CODE$ D2
, DVSYS.FACTOR_LINK$ D3
, DVSYS.FACTOR$ D4
, DVSYS.FACTOR$ D5
, DVSYS.FACTOR$ D6
WHERE D1.ID# = M.IDENTITY_ID#
AND M.ID# >= 5000
AND D2.ID# = M.OPERATION_CODE_ID#
AND D2.CODE_GROUP = 'OPERATORS'
AND D3.ID# (+)= M.FACTOR_LINK_ID#
AND D4.ID# (+)= D3.PARENT_FACTOR_ID#
AND D5.ID# (+)= D3.CHILD_FACTOR_ID#
AND D6.ID# = D1.FACTOR_ID#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))