VIEW: SYS.KU$_TTSP_INDSUBPARTVIEW

Source

View Text - Preformatted

SELECT i.bo#, value(tspo), ts.name, ts.ts#, po.flags
    from  (
                sys.ku$_schemaobj_view tspo
     inner join sys.tabsubpart$ tsp on tspo.obj_num = tsp.obj#
     inner join sys.tabcompart$ tp  on tsp.pobj#=tp.obj#
     inner join sys.ind$         i   on tp.bo#=i.bo#
     inner join sys.partobj$     po  on po.obj# = i.obj#
     inner join sys.indcompart$ ip  on i.obj#=ip.bo# and
                tp.part#=ip.part#
     inner join sys.indsubpart$ isp on isp.pobj# = ip.obj# and
                tsp.subpart#=isp.subpart#
     inner join sys.ts$         ts  on isp.ts#=ts.ts#
  )

View Text - HTML Formatted

SELECT I.BO#
, VALUE(TSPO)
, TS.NAME
, TS.TS#
, PO.FLAGS
FROM ( SYS.KU$_SCHEMAOBJ_VIEW TSPO INNER JOIN SYS.TABSUBPART$ TSP ON TSPO.OBJ_NUM = TSP.OBJ# INNER JOIN SYS.TABCOMPART$ TP ON TSP.POBJ#=TP.OBJ# INNER JOIN SYS.IND$ I ON TP.BO#=I.BO# INNER JOIN SYS.PARTOBJ$ PO ON PO.OBJ# = I.OBJ# INNER JOIN SYS.INDCOMPART$ IP ON I.OBJ#=IP.BO# AND TP.PART#=IP.PART# INNER JOIN SYS.INDSUBPART$ ISP ON ISP.POBJ# = IP.OBJ# AND TSP.SUBPART#=ISP.SUBPART# INNER JOIN SYS.TS$ TS ON ISP.TS#=TS.TS# )