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

VIEW: APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ITEM_CATALOG_GROUP_ID NUMBER
Yes Item Catalog Group identifier
CONCATENATED_SEGMENTS VARCHAR2 (40)
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
The concatenation of segments enabled for this flexfield. Padded to enable correct sorting.
NEW_ITEM_REQ_CHANGE_TYPE_ID NUMBER

Item Catalog Group identifier
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ITEM_DESC_ACTION_ID NUMBER

Item Catalog Group identifier
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
PREFIX VARCHAR2 (30)
This is a dummy column to accomodate Item Catalog Group key flexfield view
PROGRAM_ID NUMBER

Standard Who column
ITEM_NUM_ACTION_ID NUMBER

Item Catalog Group identifier
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
ENABLED_FLAG VARCHAR2 (1) Yes Flexfield segment enabled flag
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
END_DATE_ACTIVE DATE

Flexfield segment end date
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SUFFIX VARCHAR2 (30)
This is a dummy column to accomodate Item Catalog Group key flexfield view
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
REQUEST_ID NUMBER

Standard Who column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
ITEM_NUM_SEQ_NAME VARCHAR2 (30)
11.5.10 PLM
ITEM_NUM_GEN_METHOD VARCHAR2 (30)
This is a dummy column to accomodate Item Catalog Group key flexfield view
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
LAST_UPDATED_BY NUMBER
Yes Standard Who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
INCREMENT_BY NUMBER

Item Catalog Group identifier
LAST_UPDATE_LOGIN NUMBER

Standard Who column
NEW_ITEM_REQUEST_REQD VARCHAR2 (30)
This is a dummy column to accomodate Item Catalog Group key flexfield view
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
CURRENT_NUMBER NUMBER

Item Catalog Group identifier
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
ITEM_CREATION_ALLOWED_FLAG VARCHAR2 (1) Yes
CREATED_BY NUMBER
Yes Standard Who column
PARENT_CATALOG_GROUP_ID NUMBER

STARTING_NUMBER NUMBER

Item Catalog Group identifier
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
DESCRIPTION VARCHAR2 (240)
This is a dummy column to accomodate Item Catalog Group key flexfield view
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ITEM_DESC_GEN_METHOD VARCHAR2 (30)
This is a dummy column to accomodate Item Catalog Group key flexfield view
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
INACTIVE_DATE DATE

Date group becomes inactive
START_DATE_ACTIVE DATE

Flexfield segment start date
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
PROGRAM_UPDATE_DATE DATE

Standard Who column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Flexfield summary flag
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
Query Text

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


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

Dependencies

[top of page]

APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV references the following:

SchemaAPPS
SynonymMTL_ITEM_CATALOG_GROUPS_B
APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV is referenced by following:

SchemaAPPS
Package BodyEGO_IMPORT_PVT - show dependent code
Package BodyINVPOPIF - show dependent code
SynonymMTL_ITEM_CATALOG_GROUPS_KFV
ViewMTL_ITEM_CATALOG_GROUPS_V