VIEW: SYS.KU$_TTS_TABSUBPARTVIEW

Source

View Text - Preformatted

SELECT tp.bo#, value(po), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view po, sys.tabcompart$ tp,
          sys.tabsubpart$ tsp, sys.ts$ ts
    WHERE  po.obj_num = tsp.obj# and
           tp.obj# = tsp.pobj# and
           tsp.ts# = ts.ts#
  UNION ALL
    SELECT tp.bo#, value(po), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view po, sys.tabcompart$ tp,
          sys.tabsubpart$ tsp, sys.ts$ ts
    WHERE  po.obj_num = tp.obj# and
           tp.obj# = tsp.pobj# and
           tsp.ts# = ts.ts#

View Text - HTML Formatted

SELECT TP.BO#
, VALUE(PO)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW PO
, SYS.TABCOMPART$ TP
, SYS.TABSUBPART$ TSP
, SYS.TS$ TS
WHERE PO.OBJ_NUM = TSP.OBJ# AND TP.OBJ# = TSP.POBJ# AND TSP.TS# = TS.TS# UNION ALL SELECT TP.BO#
, VALUE(PO)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW PO
, SYS.TABCOMPART$ TP
, SYS.TABSUBPART$ TSP
, SYS.TS$ TS
WHERE PO.OBJ_NUM = TP.OBJ# AND TP.OBJ# = TSP.POBJ# AND TSP.TS# = TS.TS#