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

TABLE: EGO.MTL_ITEM_CAT_GRPS_INTERFACE

Object Details
Object Name: MTL_ITEM_CAT_GRPS_INTERFACE
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.MTL_ITEM_CAT_GRPS_INTERFACE
Subobject Name:
Status: VALID

Interface table for Item Catalog Category header information

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ITEM_CATALOG_GROUP_ID NUMBER

Item Catalog Group identifier
ITEM_CATALOG_NAME VARCHAR2 (819)
Item Catalog Name
INACTIVE_DATE DATE

Date catalog group becomes inactive
SUMMARY_FLAG VARCHAR2 (1)
Flexfield segment summary flag
ENABLED_FLAG VARCHAR2 (1)
Flexfield segment enabled flag
START_DATE_ACTIVE DATE

Flexfield segment Start Date
END_DATE_ACTIVE DATE

Flexfield segment End Date
DESCRIPTION VARCHAR2 (240)
Item Catalog Description
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
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
PARENT_CATALOG_GROUP_NAME VARCHAR2 (819)
Item Catalog Group name of parent
PARENT_CATALOG_GROUP_ID NUMBER

Item Catalog Group identifier of parent
ITEM_CREATION_ALLOWED_FLAG VARCHAR2 (1)
Flag indicating that creation of items of a type associated with the catalog group is allowed
ITEM_NUM_GEN_METHOD_TYPE VARCHAR2 (30)
Function Generated (F) , Inherited From Parent (P),Sequence Generated (S), User Defined (U) ( Default)
PREFIX VARCHAR2 (30)
Prefix for the item number only if item_num_gen_method_type is S
STARTING_NUMBER NUMBER

Starting number for the item number only if item_num_gen_method_type is S
INCREMENT_BY NUMBER

Value to Increment with for the item number only if item_num_gen_method_type is S
SUFFIX VARCHAR2 (30)
Suffix for Item Number only if item_num_gen_method_type is S
ITEM_NUM_SEQ_NAME VARCHAR2 (30)
Stores the database sequence name generated, for internal use
ITEM_NUM_GENERATION_FUNCTION VARCHAR2 (60)
Function identifier for Item Number generation
ITEM_NUM_FUNCTION_ID NUMBER

Function id from EGO_FUNCTIONS_V for the function name
ITEM_NUM_ACTION_ID NUMBER

Action id for Function Id for number generation. For internal use.
ENABLE_KEY_ATTRS_NUM VARCHAR2 (1)
Enable Key attributes for number generation
ITEM_DESC_GEN_METHOD_TYPE VARCHAR2 (30)
User defined (U ) ( Default), Function Generated (F)
ITEM_DESC_GENERATION_FUNCTION VARCHAR2 (60)
Function Identifier for item description generation
ITEM_DESC_FUNCTION_ID NUMBER

Function id from EGO_FUNCTIONS_V for the function name
ITEM_DESC_ACTION_ID NUMBER

Action id for Function Id for description generation. For internal use.
ENABLE_KEY_ATTRS_DESC VARCHAR2 (1)
Enable Key attributes for description generation
NEW_ITEM_REQUEST_NAME VARCHAR2 (80)
NIR Type Name
NEW_ITEM_REQ_CHANGE_TYPE_ID NUMBER

Change Type asociated with NIR
NEW_ITEM_REQUEST_TYPE VARCHAR2 (30)
Inherit from Parent , None(Default), Specify for Category
SET_PROCESS_ID NUMBER (15)
Batch identifier in this table
TRANSACTION_ID NUMBER (15)
ID column used to tie back the record from mtl_interface_errors table
PROCESS_STATUS NUMBER (15)
Initial(1) , Error ( 3), Success (7)
TRANSACTION_TYPE VARCHAR2 (10)
Identifies whether the record is for CREATE,UPDATE, OR SYNC
REQUEST_ID NUMBER (15)
Standard concurrent request id
PROGRAM_APPLICATION_ID NUMBER (15)
Standard program application id
PROGRAM_ID NUMBER (15)
Standard program id
PROGRAM_UPDATE_DATE DATE

Standard program update date
CREATED_BY NUMBER (15)
Standard "WHO" column
CREATION_DATE DATE

Standard "WHO" column
LAST_UPDATED_BY NUMBER (15)
Standard "WHO" column
LAST_UPDATE_DATE DATE

Standard "WHO" column
LAST_UPDATE_LOGIN NUMBER (15)
Standard "WHO" column
Query Text

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


SELECT ITEM_CATALOG_GROUP_ID
,      ITEM_CATALOG_NAME
,      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
,      PARENT_CATALOG_GROUP_NAME
,      PARENT_CATALOG_GROUP_ID
,      ITEM_CREATION_ALLOWED_FLAG
,      ITEM_NUM_GEN_METHOD_TYPE
,      PREFIX
,      STARTING_NUMBER
,      INCREMENT_BY
,      SUFFIX
,      ITEM_NUM_SEQ_NAME
,      ITEM_NUM_GENERATION_FUNCTION
,      ITEM_NUM_FUNCTION_ID
,      ITEM_NUM_ACTION_ID
,      ENABLE_KEY_ATTRS_NUM
,      ITEM_DESC_GEN_METHOD_TYPE
,      ITEM_DESC_GENERATION_FUNCTION
,      ITEM_DESC_FUNCTION_ID
,      ITEM_DESC_ACTION_ID
,      ENABLE_KEY_ATTRS_DESC
,      NEW_ITEM_REQUEST_NAME
,      NEW_ITEM_REQ_CHANGE_TYPE_ID
,      NEW_ITEM_REQUEST_TYPE
,      SET_PROCESS_ID
,      TRANSACTION_ID
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EGO.MTL_ITEM_CAT_GRPS_INTERFACE;

Dependencies

[top of page]

EGO.MTL_ITEM_CAT_GRPS_INTERFACE does not reference any database object

EGO.MTL_ITEM_CAT_GRPS_INTERFACE is referenced by following:

SchemaEGO
ViewMTL_ITEM_CAT_GRPS_INTERFACE#