This table contains item category set information.
Module:
CATEGORY_SET_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CATEGORY_SET_ID | NUMBER | 38 | 0 | True | CATEGORY_SET_ID | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source record identifier. | |||
| CATALOG_CODE | VARCHAR2 | 32 | CATALOG_CODE | ||||
| MULT_ITEM_CAT_ASSIGN_FLAG | VARCHAR2 | 16 | MULT_ITEM_CAT_ASSIGN_FLAG | ||||
| CONTROL_LEVEL | NUMBER | CONTROL_LEVEL | DW_CATALOG_CONTROL_LVL_LKP_TL | CATALOG_CONTROL_LEVEL_CODE | |||
| DEFAULT_CATEGORY_CODE | VARCHAR2 | 999 | Category an item is assigned to when during new item creation | ||||
| START_DATE | DATE | Date the catalog will become active | |||||
| END_DATE | DATE | Date the catalog will become inactive |
Copyright © 2019, 2025, Oracle and/or its affiliates.