VIEW: SYS.KU$_TAB_PARTOBJ_VIEW

Source

View Text - Preformatted

select po.obj_num, value(po),
         cast(multiset(select * from ku$_tab_part_col_view pc
                       where pc.obj_num = po.obj_num
                        order by pc.pos_num
                      ) as ku$_part_col_list_t
             ),
         cast(multiset(select * from ku$_tab_subpart_col_view sc
                       where sc.obj_num = po.obj_num
                        order by sc.pos_num
                      ) as ku$_part_col_list_t
             ),
         cast(multiset(select * from ku$_tab_part_view tp
                       where tp.base_obj_num = po.obj_num
                        order by tp.part_num
                      ) as ku$_tab_part_list_t
             ),
         cast(multiset(select * from ku$_tab_compart_view tcp
                       where tcp.base_obj_num = po.obj_num
                        order by tcp.part_num
                      ) as ku$_tab_compart_list_t
             ),
         cast(multiset(select * from ku$_tab_tsubpart_view ttsp
                       where ttsp.base_objnum = po.obj_num
                        order by ttsp.spart_pos
                      ) as ku$_tab_tsubpart_list_t
             )
  from ku$_partobj_view po

View Text - HTML Formatted

SELECT PO.OBJ_NUM
, VALUE(PO)
, CAST(MULTISET(SELECT *
FROM KU$_TAB_PART_COL_VIEW PC
WHERE PC.OBJ_NUM = PO.OBJ_NUM ORDER BY PC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TAB_SUBPART_COL_VIEW SC
WHERE SC.OBJ_NUM = PO.OBJ_NUM ORDER BY SC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TAB_PART_VIEW TP
WHERE TP.BASE_OBJ_NUM = PO.OBJ_NUM ORDER BY TP.PART_NUM ) AS KU$_TAB_PART_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TAB_COMPART_VIEW TCP
WHERE TCP.BASE_OBJ_NUM = PO.OBJ_NUM ORDER BY TCP.PART_NUM ) AS KU$_TAB_COMPART_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TAB_TSUBPART_VIEW TTSP
WHERE TTSP.BASE_OBJNUM = PO.OBJ_NUM ORDER BY TTSP.SPART_POS ) AS KU$_TAB_TSUBPART_LIST_T )
FROM KU$_PARTOBJ_VIEW PO