[Home] [Help] [Dependency Information]

TABLE: INV.MTL_ITEM_CATALOG_GROUPS_B

Object Details

Object Name:	MTL_ITEM_CATALOG_GROUPS_B
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ITEM_CATALOG_GROUPS_B
Subobject Name:
Status:	VALID

MTL_ITEM_CATALOG_GROUPS_B is the code combinations table for item catalog groups.
An item catalog group consists of items that can be described by the
same set of descriptive elements or item properties. When an item is
associated with an item catalog group, the item inherits the
descriptive elements for that group which then behave like additional
item attributes. The user can specify values for the descriptive
elements and can use that information to search for items using the
Item Search window.
.
The item catalog group assignment for an item is done at the item
master organization level.
.
The item catalog group is a key flexfield with a flex code MICG.
This flexfield has been set up to support a single flexfield structure, therefore there is no flexfield structure identifier column in this table.
.
Item Catalog Groups now support multilingual description. MLS is implemented with a pair of tables: MTL_ITEM_CATALOG_GROUPS_B and MTL_ITEM_CATALOG_GROUPS_TL. The MTL_ITEM_CATALOG_GROUPS_TL table stores translated Description for a catalog group.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ITEM_CATALOG_GROUPS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_CATALOG_GROUP_ID PARENT_CATALOG_GROUP_ID ZD_EDITION_NAME
MTL_ITEM_CATALOG_GROUPS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ITEM_CATALOG_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INACTIVE_DATE
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARENT_CATALOG_GROUP_ID
,      ITEM_CREATION_ALLOWED_FLAG
,      ITEM_NUM_GEN_METHOD
,      PREFIX
,      STARTING_NUMBER
,      INCREMENT_BY
,      SUFFIX
,      CURRENT_NUMBER
,      ITEM_NUM_ACTION_ID
,      ITEM_DESC_GEN_METHOD
,      ITEM_DESC_ACTION_ID
,      NEW_ITEM_REQUEST_REQD
,      NEW_ITEM_REQ_CHANGE_TYPE_ID
,      ITEM_NUM_SEQ_NAME
,      ZD_EDITION_NAME
FROM INV.MTL_ITEM_CATALOG_GROUPS_B;

Dependencies

[top of page]

INV.MTL_ITEM_CATALOG_GROUPS_B does not reference any database object

INV.MTL_ITEM_CATALOG_GROUPS_B is referenced by following:

INV

MTL_ITEM_CATALOG_GROUPS_B#