select sc.obj#, sc.intcol#, value(c), sc.pos#, sc.spare1
from ku$_simple_col_view c, subpartcol$ sc
where sc.obj#=c.obj_num
and sc.intcol#=c.intcol_num
View Text - HTML Formatted
SELECT SC.OBJ# , SC.INTCOL# , VALUE(C) , SC.POS# , SC.SPARE1
FROM KU$_SIMPLE_COL_VIEW C , SUBPARTCOL$ SC
WHERE SC.OBJ#=C.OBJ_NUM
AND SC.INTCOL#=C.INTCOL_NUM