DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_ITEM_CATALOG_GROUPS_VL

Object Details
Object Name: MTL_ITEM_CATALOG_GROUPS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ITEM_CATALOG_GROUPS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Item Catalog Groups multilingual view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row(MTL_CATALOG_GROUPS_B) identifier
ITEM_CATALOG_GROUP_ID NUMBER
Yes Item catalog group identifier
INACTIVE_DATE DATE

Date group becomes inactive
PARENT_CATALOG_GROUP_ID NUMBER

Parent catalog group identifier
ITEM_CREATION_ALLOWED_FLAG VARCHAR2 (1) Yes Flag indicating that creation of items of a type associated with the catalog group is allowed
ITEM_NUM_GEN_METHOD VARCHAR2 (30)
Flag indicating that creation of items of a type associated with the catalog group is allowed
PREFIX VARCHAR2 (30)
Flag indicating that creation of items of a type associated with the catalog group is allowed
STARTING_NUMBER NUMBER

Starting (Item) Number for Items under this Catalog
INCREMENT_BY NUMBER

Incremental value for sequence genarated Items
SUFFIX VARCHAR2 (30)
Item Name Suffix, incase of sequence generated items
CURRENT_NUMBER NUMBER

Current Item Number - For sequence generated Item names
ITEM_NUM_ACTION_ID NUMBER

Item number action identifier
ITEM_DESC_GEN_METHOD VARCHAR2 (30)
Item decription generation method
ITEM_DESC_ACTION_ID NUMBER

Item description action identifier
NEW_ITEM_REQUEST_REQD VARCHAR2 (30)
Flag indicating Item creation requires NIR
NEW_ITEM_REQ_CHANGE_TYPE_ID NUMBER

New Item Request(NIR) - Associated change type identifier
ITEM_NUM_SEQ_NAME VARCHAR2 (30)
11.5.10 PLM
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Flexfield summary flag
ENABLED_FLAG VARCHAR2 (1) Yes Flexfield segment enabled flag
START_DATE_ACTIVE DATE

Flexfield segment start date
END_DATE_ACTIVE DATE

Flexfield segment end date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent who column
PROGRAM_ID NUMBER

Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
DESCRIPTION VARCHAR2 (240)
Catalog Groups Description
Query Text

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


SELECT ROW_ID
,      ITEM_CATALOG_GROUP_ID
,      INACTIVE_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
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESCRIPTION
FROM APPS.MTL_ITEM_CATALOG_GROUPS_VL;

Dependencies

[top of page]

APPS.MTL_ITEM_CATALOG_GROUPS_VL references the following:

SchemaAPPS
SynonymMTL_ITEM_CATALOG_GROUPS_B
SynonymMTL_ITEM_CATALOG_GROUPS_TL
APPS.MTL_ITEM_CATALOG_GROUPS_VL is referenced by following:

SchemaAPPS
Package BodyEGO_CATALOG_GROUP_UTIL - show dependent code
Package BodyINV_EBI_ITEM_HELPER - show dependent code
SynonymMTL_ITEM_CATALOG_GROUPS