MSC_DIM_CATEGORY_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME PARENT_ID DESCRIPTION PARENT_CATEGORY_SET_ID REFRESH_NUMBER |
問合せ
| 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 |