eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.KU$_NTPART_VIEW

Source

View Text - Preformatted


select
                nt.obj#,
                dbms_metadata.get_partn(1,ntp.bo#,ntp.part#),
                nt.intcol#, nt.ntab#,
                (select value(o) from ku$_schemaobj_view o
                 where o.obj_num = ntp.obj#),
                (select value(c) from ku$_simple_col_view c
                 where c.obj_num = nt.obj#
                 and   c.intcol_num = nt.intcol#),
                (select t.property from tab$ t where t.obj# = nt.ntab#),
                (select ct.flags from coltype$ ct
                        where ct.obj# = nt.obj#
                        and   ct.intcol# = nt.intcol#),
                (select value(hntp) from ku$_hntp_view hntp
                 where hntp.obj_num = ntp.obj#)
            from ntab$ nt,
               tabpart$ ntp
            where ntp.bo#=nt.ntab#

View Text - HTML Formatted

SELECT NT.OBJ#
, DBMS_METADATA.GET_PARTN(1
, NTP.BO#
, NTP.PART#)
, NT.INTCOL#
, NT.NTAB#
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = NTP.OBJ#)
, (SELECT VALUE(C)
FROM KU$_SIMPLE_COL_VIEW C
WHERE C.OBJ_NUM = NT.OBJ#
AND C.INTCOL_NUM = NT.INTCOL#)
, (SELECT T.PROPERTY
FROM TAB$ T
WHERE T.OBJ# = NT.NTAB#)
, (SELECT CT.FLAGS
FROM COLTYPE$ CT
WHERE CT.OBJ# = NT.OBJ#
AND CT.INTCOL# = NT.INTCOL#)
, (SELECT VALUE(HNTP)
FROM KU$_HNTP_VIEW HNTP
WHERE HNTP.OBJ_NUM = NTP.OBJ#)
FROM NTAB$ NT
, TABPART$ NTP
WHERE NTP.BO#=NT.NTAB#