VIEW: SYS.KU$_TEMP_SUBPARTDATA_VIEW

Source

View Text - Preformatted

SELECT
              p.obj#,
              sp.ts_num,
              dsp.ts#,
              p.defts#,
              tpo.defts#,
              u.datats#,
              sp.bhiboundval,
              dsp.bhiboundval
        FROM sys.tabcompart$ p, sys.partobj$ tpo,  ku$_temp_subpart_view sp,
             sys.defsubpart$ dsp, sys.obj$ po, sys.obj$ spo, sys.user$ u
        WHERE
             p.bo# = tpo.obj# AND
             p.subpartcnt = MOD(TRUNC(tpo.spare2/65536), 65536) AND
             sp.pobj_num = p.obj# AND
             po.obj# = p.obj# AND
             spo.obj# = sp.obj_num AND
             sp.subpartno = dsp.spart_position AND
             dsp.bo# = p.bo# AND
             u.user# = po.owner# AND
             (spo.subname = (po.subname || '_' || dsp.spart_name) OR
                            (po.subname LIKE 'SYS_P%' AND
                             spo.subname LIKE 'SYS_SUBP%'))

View Text - HTML Formatted

SELECT P.OBJ#
, SP.TS_NUM
, DSP.TS#
, P.DEFTS#
, TPO.DEFTS#
, U.DATATS#
, SP.BHIBOUNDVAL
, DSP.BHIBOUNDVAL
FROM SYS.TABCOMPART$ P
, SYS.PARTOBJ$ TPO
, KU$_TEMP_SUBPART_VIEW SP
, SYS.DEFSUBPART$ DSP
, SYS.OBJ$ PO
, SYS.OBJ$ SPO
, SYS.USER$ U WHERE P.BO# = TPO.OBJ# AND P.SUBPARTCNT = MOD(TRUNC(TPO.SPARE2/65536)
, 65536) AND SP.POBJ_NUM = P.OBJ# AND PO.OBJ# = P.OBJ# AND SPO.OBJ# = SP.OBJ_NUM AND SP.SUBPARTNO = DSP.SPART_POSITION AND DSP.BO# = P.BO# AND U.USER# = PO.OWNER# AND (SPO.SUBNAME = (PO.SUBNAME || '_' || DSP.SPART_NAME) OR (PO.SUBNAME LIKE 'SYS_P%' AND SPO.SUBNAME LIKE 'SYS_SUBP%'))