Query to get ‘Category’ Data

create or replace view  LSG_CATL_OBJ_PARNT_CATGRY_V
as select distinct ocu.PARENT_CAT_USAGE_ID,ocup.category parent_ctagory–,ocu.CATEGORY_USAGE_ID,ocu.category,ocu.type,ocu.DATA_SOURCE
from ota_category_usages ocu, ota_category_usages ocup
where ocup.CATEGORY_USAGE_ID = ocu.PARENT_CAT_USAGE_ID
order by 2