SVC_CATEGORIES_HIER_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
CATEGORY_ID HIERARCHY DEPTH CATEGORY_ID_HIERARCHY ROOT_CATEGORY_CODE

Query

SQL_Statement

select category_id, case when instr(svc_util.get_svc_categ_path(category_id),'>')=0 then null else svc_util.get_svc_categ_path(category_id) end as hierarchy, REGEXP_COUNT(svc_util.get_svc_categ_path(category_id),'>') as depth, case when instr(svc_util.get_svc_categ_id_path(category_id),'>')=0 then null else svc_util.get_svc_categ_id_path(category_id) end as CATEGORY_ID_HIERARCHY, svc_util.get_svc_categ_root_code(category_id) as root_category_code from svc_categories_b