VIEW: SYS.KU$_TEMP_SUBPARTLOB_VIEW

Source

View Text - Preformatted

SELECT
              tp.obj#,
              lp.defts#,
              lf.ts_num,
              lb.defts#,
              dsp.lob_spart_ts#,
              tsp.ts#
        FROM  sys.tabcompart$ tp, sys.lobcomppart$ lp, sys.partlob$ lb,
              sys.ku$_temp_subpartlobfrg_view lf, sys.defsubpartlob$ dsp,
              sys.obj$ lspo, sys.obj$ tpo, sys.tabsubpart$ tsp
        WHERE
              lp.tabpartobj# = tp.obj# AND
              lp.lobj# = lb.lobj# and
              lf.obj_num = lp.partobj# AND
              dsp.bo# = tp.bo# and
              dsp.intcol# = lb.intcol# AND
              lspo.obj# = lf.fragobj_num AND
              tpo.obj# = tp.obj# AND
              (lspo.subname = tpo.subname || '_' || dsp.lob_spart_name OR
               (tpo.subname LIKE 'SYS_P%' AND lspo.subname
                                 LIKE 'SYS_LOB_SUBP%')) AND
              dsp.spart_position = lf.frag_num AND
              tsp.obj# = lf.tabfragobj_num
     UNION   -- ALL
        SELECT tp.obj#,
               lp.defts#,
               lf.ts_num,
               lb.defts#,
               NULL,
               tsp.ts#
        FROM sys.tabcompart$ tp, sys.lobcomppart$ lp, sys.partlob$ lb,
             sys.ku$_temp_subpartlobfrg_view lf, sys.obj$ lspo, sys.obj$ tpo,
             sys.tabsubpart$ tsp
        WHERE lp.tabpartobj# = tp.obj# AND
              lp.lobj# = lb.lobj# AND
              lf.obj_num = lp.partobj# AND
              lb.intcol# NOT IN
                (SELECT distinct dsp.intcol#
                  FROM sys.defsubpartlob$ dsp
                  WHERE dsp.bo# = tp.bo#) AND
              lspo.obj# = lf.fragobj_num AND
              tpo.obj# = tp.obj# AND
              lspo.subname LIKE 'SYS_LOB_SUBP%' AND
              tsp.obj# = lf.tabfragobj_num

View Text - HTML Formatted

SELECT TP.OBJ#
, LP.DEFTS#
, LF.TS_NUM
, LB.DEFTS#
, DSP.LOB_SPART_TS#
, TSP.TS#
FROM SYS.TABCOMPART$ TP
, SYS.LOBCOMPPART$ LP
, SYS.PARTLOB$ LB
, SYS.KU$_TEMP_SUBPARTLOBFRG_VIEW LF
, SYS.DEFSUBPARTLOB$ DSP
, SYS.OBJ$ LSPO
, SYS.OBJ$ TPO
, SYS.TABSUBPART$ TSP WHERE LP.TABPARTOBJ# = TP.OBJ# AND LP.LOBJ# = LB.LOBJ# AND LF.OBJ_NUM = LP.PARTOBJ# AND DSP.BO# = TP.BO# AND DSP.INTCOL# = LB.INTCOL# AND LSPO.OBJ# = LF.FRAGOBJ_NUM AND TPO.OBJ# = TP.OBJ# AND (LSPO.SUBNAME = TPO.SUBNAME || '_' || DSP.LOB_SPART_NAME OR (TPO.SUBNAME LIKE 'SYS_P%'
AND LSPO.SUBNAME LIKE 'SYS_LOB_SUBP%')) AND DSP.SPART_POSITION = LF.FRAG_NUM AND TSP.OBJ# = LF.TABFRAGOBJ_NUM UNION -- ALL SELECT TP.OBJ#
, LP.DEFTS#
, LF.TS_NUM
, LB.DEFTS#
, NULL
, TSP.TS#
FROM SYS.TABCOMPART$ TP
, SYS.LOBCOMPPART$ LP
, SYS.PARTLOB$ LB
, SYS.KU$_TEMP_SUBPARTLOBFRG_VIEW LF
, SYS.OBJ$ LSPO
, SYS.OBJ$ TPO
, SYS.TABSUBPART$ TSP
WHERE LP.TABPARTOBJ# = TP.OBJ# AND LP.LOBJ# = LB.LOBJ# AND LF.OBJ_NUM = LP.PARTOBJ# AND LB.INTCOL# NOT IN (SELECT DISTINCT DSP.INTCOL#
FROM SYS.DEFSUBPARTLOB$ DSP
WHERE DSP.BO# = TP.BO#) AND LSPO.OBJ# = LF.FRAGOBJ_NUM AND TPO.OBJ# = TP.OBJ# AND LSPO.SUBNAME LIKE 'SYS_LOB_SUBP%' AND TSP.OBJ# = LF.TABFRAGOBJ_NUM