Query to get ‘Sub Category’ Data

create or replace view  LSG_CATL_OBJ_SUB_CATGRY_V
as select ocu.PARENT_CAT_USAGE_ID,ocup.category parent_category,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