[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_CATEGORY_SETS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_CATEGORY_SETS_B
|
| Subobject Name: | |
| Status: | VALID |
MTL_CATEGORY_SETS_B contains the entity definition for category sets. A category set is a categorization scheme for a group of items. Items
may be assigned to different categories in different category sets to
represent the different groupings of items used for different
purposes. An item may be assigned to only one category within a
category set, however.
.
STRUCTURE_ID identifies the flexfield structure associated with the
category set. Only categories with the same flexfield structure may
be grouped into a category set.
.
CONTROL_LEVEL defines whether the category set is controlled at the
item or the item/organization level. When an item is assigned to an
item level category set within the item master organization, the
category set assignment is propagated to all other organizations to
which the item is assigned.
.
VALIDATE_FLAG defines whether a list of valid categories is used to
validate category usage within the set. Validated category sets will
not allow item assignment to the category set in categories that are
not in a predefined list of valid categories.
.
Category Sets now support multilingual category set name and description. MLS is implemented with a pair of tables: MTL_CATEGORY_SETS_B and MTL_CATEGORY_SETS_TL. MTL_CATEGORY_SETS_TL table holds translated Name and Description for Category Sets.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_CATEGORY_SETS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CATEGORY_SET_ID
ZD_EDITION_NAME
|
| MTL_CATEGORY_SETS_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STRUCTURE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CATEGORY_SET_ID | NUMBER | Yes | Category set identifier | |
| STRUCTURE_ID | NUMBER | Yes | Flexfield structure identifier | |
| VALIDATE_FLAG | VARCHAR2 | (1) | Yes | Flag indicating category validation required |
| CONTROL_LEVEL | NUMBER | Yes | Item or item/org control level | |
| DEFAULT_CATEGORY_ID | NUMBER | Default category identifier | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| MULT_ITEM_CAT_ASSIGN_FLAG | VARCHAR2 | (1) | Yes | Flag indicating an Item can be assigned to multiple categories in a Category Set. |
| CONTROL_LEVEL_UPDATEABLE_FLAG | VARCHAR2 | (1) | Flag indicating if item category control level flag if updateable. | |
| MULT_ITEM_CAT_UPDATEABLE_FLAG | VARCHAR2 | (1) | Flag indicating if multiple categories assignment flag is updateable | |
| HIERARCHY_ENABLED | VARCHAR2 | (1) | Flag to indicate heirachies in categories in categoriy sets | |
| VALIDATE_FLAG_UPDATEABLE_FLAG | VARCHAR2 | (1) | Flag indicating that user can update Validate Flag in a Category Set. | |
| USER_CREATION_ALLOWED_FLAG | VARCHAR2 | (1) | Flag for controlling if user can create category using this category set | |
| RAISE_ITEM_CAT_ASSIGN_EVENT | VARCHAR2 | (1) | This flag if for controlling "oracle.apps.ego.item.postCatalogAssignmentChange" business events for a catalog | |
| RAISE_ALT_CAT_HIER_CHG_EVENT | VARCHAR2 | (1) | This flag if for controlling "oracle.apps.ego.item.postValidCategoryChange" business events for a catalog | |
| RAISE_CATALOG_CAT_CHG_EVENT | VARCHAR2 | (1) | This flag if for controlling "oracle.apps.ego.item.postCatalogCategoryChange" business events for a catalog | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_SET_ID
, STRUCTURE_ID
, VALIDATE_FLAG
, CONTROL_LEVEL
, DEFAULT_CATEGORY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, MULT_ITEM_CAT_ASSIGN_FLAG
, CONTROL_LEVEL_UPDATEABLE_FLAG
, MULT_ITEM_CAT_UPDATEABLE_FLAG
, HIERARCHY_ENABLED
, VALIDATE_FLAG_UPDATEABLE_FLAG
, USER_CREATION_ALLOWED_FLAG
, RAISE_ITEM_CAT_ASSIGN_EVENT
, RAISE_ALT_CAT_HIER_CHG_EVENT
, RAISE_CATALOG_CAT_CHG_EVENT
, ZD_EDITION_NAME
FROM INV.MTL_CATEGORY_SETS_B;
INV.MTL_CATEGORY_SETS_B does not reference any database object
INV.MTL_CATEGORY_SETS_B is referenced by following:
APPS
OZF_EARNING_SUMMARY_MV
INV
MTL_CATEGORY_SETS_B#
|
|
|
|