VIEW: SYS.KU$_IND_PARTOBJ_VIEW

Source

View Text - Preformatted

select po.obj_num, value(po),
         cast(multiset(select * from ku$_ind_part_col_view pc
                       where pc.obj_num = i.obj#
                        order by pc.pos_num
                      ) as ku$_part_col_list_t
             ),
         cast(multiset(select * from ku$_ind_subpart_col_view sc
                       where sc.obj_num = i.obj#
                        order by sc.pos_num
                      ) as ku$_part_col_list_t
             ),
         cast(multiset(select * from ku$_ind_part_view ip
                       where ip.base_obj_num = po.obj_num
                        order by ip.part_num
                      ) as ku$_ind_part_list_t
             ),
         cast(multiset(select * from ku$_ind_compart_view icp
                       where icp.base_obj_num = po.obj_num
                        order by icp.part_num
                      ) as ku$_ind_compart_list_t
             )
  from ind$ i, ku$_partobj_view po
        where i.obj#=po.obj_num

View Text - HTML Formatted

SELECT PO.OBJ_NUM
, VALUE(PO)
, CAST(MULTISET(SELECT *
FROM KU$_IND_PART_COL_VIEW PC
WHERE PC.OBJ_NUM = I.OBJ# ORDER BY PC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_IND_SUBPART_COL_VIEW SC
WHERE SC.OBJ_NUM = I.OBJ# ORDER BY SC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_IND_PART_VIEW IP
WHERE IP.BASE_OBJ_NUM = PO.OBJ_NUM ORDER BY IP.PART_NUM ) AS KU$_IND_PART_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_IND_COMPART_VIEW ICP
WHERE ICP.BASE_OBJ_NUM = PO.OBJ_NUM ORDER BY ICP.PART_NUM ) AS KU$_IND_COMPART_LIST_T )
FROM IND$ I
, KU$_PARTOBJ_VIEW PO
WHERE I.OBJ#=PO.OBJ_NUM