VIEW: SYS.KU$_IND_SUBNAME_VIEW

Source

View Text - Preformatted

SELECT tsov.owner_name, isov.owner_name, tsov.name, isov.name, tsov.subname,
         isov.subname, NULL, NULL, ts$.name
  FROM   sys.ku$_schemaobj_view tsov, sys.ku$_schemaobj_view isov, tabpart$ tp,
         ind$ i, indpart$ ip, ts$
  WHERE  tsov.obj_num=tp.obj# AND
         isov.obj_num=ip.obj# AND
         i.obj# = ip.bo# AND
         i.bo# = tp.bo# AND
         ip.ts# = ts$.ts# AND
         ip.part# = tp.part# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (isov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))
UNION ALL
  SELECT tsov.owner_name, isov.owner_name,  tsov.name, isov.name, tpo.subname,
         ipo.subname, tsov.subname, isov.subname, ts$.name
  FROM   sys.ku$_schemaobj_view tsov, sys.ku$_schemaobj_view isov,
         sys.obj$ tpo, sys.obj$ ipo, sys.tabsubpart$ tsp, sys.tabcompart$ tcp,
         sys.indcompart$ icp, sys.ind$ i, indsubpart$ isp, ts$
  WHERE  tsov.obj_num=tsp.obj# AND
         isov.obj_num=isp.obj# AND
         isp.pobj# = icp.obj# AND
         tsp.pobj# = tcp.obj# AND
         tpo.obj# = tcp.obj# AND
         isp.subpart# = tsp.subpart# AND
         icp.part# = tcp.part# AND
         icp.bo# = i.obj# AND
         i.bo# = tcp.bo# AND
         ipo.obj# = icp.obj# AND
         isp.ts# = ts$.ts# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (isov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT TSOV.OWNER_NAME
, ISOV.OWNER_NAME
, TSOV.NAME
, ISOV.NAME
, TSOV.SUBNAME
, ISOV.SUBNAME
, NULL
, NULL
, TS$.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW TSOV
, SYS.KU$_SCHEMAOBJ_VIEW ISOV
, TABPART$ TP
, IND$ I
, INDPART$ IP
, TS$
WHERE TSOV.OBJ_NUM=TP.OBJ# AND ISOV.OBJ_NUM=IP.OBJ# AND I.OBJ# = IP.BO# AND I.BO# = TP.BO# AND IP.TS# = TS$.TS# AND IP.PART# = TP.PART# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (ISOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) UNION ALL SELECT TSOV.OWNER_NAME
, ISOV.OWNER_NAME
, TSOV.NAME
, ISOV.NAME
, TPO.SUBNAME
, IPO.SUBNAME
, TSOV.SUBNAME
, ISOV.SUBNAME
, TS$.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW TSOV
, SYS.KU$_SCHEMAOBJ_VIEW ISOV
, SYS.OBJ$ TPO
, SYS.OBJ$ IPO
, SYS.TABSUBPART$ TSP
, SYS.TABCOMPART$ TCP
, SYS.INDCOMPART$ ICP
, SYS.IND$ I
, INDSUBPART$ ISP
, TS$
WHERE TSOV.OBJ_NUM=TSP.OBJ# AND ISOV.OBJ_NUM=ISP.OBJ# AND ISP.POBJ# = ICP.OBJ# AND TSP.POBJ# = TCP.OBJ# AND TPO.OBJ# = TCP.OBJ# AND ISP.SUBPART# = TSP.SUBPART# AND ICP.PART# = TCP.PART# AND ICP.BO# = I.OBJ# AND I.BO# = TCP.BO# AND IPO.OBJ# = ICP.OBJ# AND ISP.TS# = TS$.TS# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (ISOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))