MSC_DIM_CATEGORY_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID DESCRIPTION PARENT_CATEGORY_SET_ID REFRESH_NUMBER

Query

SQL_Statement
SELECT category_id ID, category_name NAME, NVL(parent_category_id,-1) PARENT_ID, description DESCRIPTION, category_set_id PARENT_CATEGORY_SET_ID, refresh_number refresh_number FROM msc_catalog_categories WHERE CATEGORY_ID IS NOT NULL