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

TABLE: EGO.EGO_ATTR_GROUP_COLS_INTF

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

EGO_ATTR_GROUP_COLS_INTF temporarily stores the definitions for
attributes before loading this information into Oracle Advanced
Product Catalog.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Advanced Product Catalog will default column values you do not enter, after
performing the proper validation. For example, you enter the
ATTR_GROUP_NAME, and Oracle Advanced Product Catalog will fill in the corresponding
ATTR_GROUP_ID for you.

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

Unique identifier for the subset of data. Each of the lines that are newly uploaded in the interface table, need to be given a unique ID, that will be used during the Concurrent program request submission. It is suggested to retrieve the values from EGO_IPI_DATASET_ID_S.
ATTR_ID NUMBER

Attribute Id
APPLICATION_ID NUMBER

Application Id
ATTR_GROUP_TYPE VARCHAR2 (40)
Attribute Group Type to which the Attribute Group belongs (part of the foreign key to FND_DESCR_FLEX_CONTEXTS). Eg. EGO_ITEMMGMT_GROUP
ATTR_GROUP_ID NUMBER

Attribute Group ID
ATTR_GROUP_NAME VARCHAR2 (30)
Internal name of the Attribute Group (part of the foreign key to FND_DESCR_FLEX_CONTEXTS)
INTERNAL_NAME VARCHAR2 (140)
Internal Name of Attributes
DISPLAY_NAME VARCHAR2 (240)
Attribute Display Name
DESCRIPTION VARCHAR2 (240)
Description
SEQUENCE NUMBER

Sequence
APPLICATION_COLUMN_NAME VARCHAR2 (30)
Database Column name
DATA_TYPE VARCHAR2 (30)
Data type of Attribute
SEARCH_FLAG VARCHAR2 (1)
Searchable or Not
UNIQUE_KEY_FLAG VARCHAR2 (1)
Flag to indicate if this attribute is a part of Unique Key in case of Multi Row Attribute group
INFO_1 VARCHAR2 (2048)
URL incase of attribute type Dynamic URL
UOM_CLASS VARCHAR2 (10)
Unit Of Measure in case of Number Attribute
CONTROL_LEVEL NUMBER

Used to determine whether all the attribute properties of the attribute are updateble or not
VIEW_IN_HIERARCHY_CODE VARCHAR2 (30)
Determines the extent to which this Attribute is viewable in whatever hierarchy is defined for the customer object (e.g., the Item or Project or Change). Only used by some customer objects.
EDIT_IN_HIERARCHY_CODE VARCHAR2 (30)
Determines the extent to which this Attribute is editable in whatever hierarchy is defined for the customer object (e.g., the Item or Project or Change). Only used by some customer objects.
CUSTOMIZATION_LEVEL VARCHAR2 (1)
Determines if the attribute can be customized
READ_ONLY_FLAG VARCHAR2 (1)
Indicates Attribute should be read only in AG region or not.
ENABLED_FLAG VARCHAR2 (1)
Flag to indicate if the descriptive flexfield segment is enabled
REQUIRED_FLAG VARCHAR2 (1)
Flag to indicate whether a value must be entered for this segment
SECURITY_ENABLED_FLAG VARCHAR2 (1)
Flag to tell if security is enabled for this segment
DISPLAY_CODE VARCHAR2 (1)
Values correspond to the lookup_type = EGO_EF_DISPLAY_TYPE Allowed values are C - Checkbox D - Dynamic URL H - Hidden L - Text Area R - Radio Group S - Static URL T - Text field
DEFAULT_VALUE VARCHAR2 (2000)
Default value
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code
MAXIMUM_DESCRIPTION_LEN NUMBER

The maximum size of the segment value description in flexfield window
CONCATENATION_DESCRIPTION_LEN NUMBER

The number of characters in the segment value description
FLEX_VALUE_SET_ID NUMBER

Value Set ID
FLEX_VALUE_SET_NAME VARCHAR2 (40)
Value set name
TRANSACTION_ID NUMBER

Unique identifier for the line. It is suggested to retrieve the value for this from mtl_system_items_interface_s.
PROCESS_STATUS NUMBER

Indicates the status of the line. Valid values are : 1 (To be processed), 3 (Error), 7 (Success).
TRANSACTION_TYPE VARCHAR2 (10)
Transaction Type
REQUEST_ID NUMBER

Concurrent Program Submission Request ID.
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Application ID.
PROGRAM_ID NUMBER

Concurrent Program ID.
PROGRAM_UPDATE_DATE DATE

Concurrent Program update date. When the concurrent program finishes processing this line, the SYSDATE at that time can be set to this column.
CREATED_BY NUMBER

standard "WHO" column.
CREATION_DATE DATE

standard "WHO" column.
LAST_UPDATED_BY NUMBER

standard "WHO" column.
LAST_UPDATE_DATE DATE

standard "WHO" column.
LAST_UPDATE_LOGIN NUMBER

standard "WHO" column.
Query Text

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


SELECT SET_PROCESS_ID
,      ATTR_ID
,      APPLICATION_ID
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_ID
,      ATTR_GROUP_NAME
,      INTERNAL_NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      SEQUENCE
,      APPLICATION_COLUMN_NAME
,      DATA_TYPE
,      SEARCH_FLAG
,      UNIQUE_KEY_FLAG
,      INFO_1
,      UOM_CLASS
,      CONTROL_LEVEL
,      VIEW_IN_HIERARCHY_CODE
,      EDIT_IN_HIERARCHY_CODE
,      CUSTOMIZATION_LEVEL
,      READ_ONLY_FLAG
,      ENABLED_FLAG
,      REQUIRED_FLAG
,      SECURITY_ENABLED_FLAG
,      DISPLAY_CODE
,      DEFAULT_VALUE
,      ATTRIBUTE_CODE
,      MAXIMUM_DESCRIPTION_LEN
,      CONCATENATION_DESCRIPTION_LEN
,      FLEX_VALUE_SET_ID
,      FLEX_VALUE_SET_NAME
,      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.EGO_ATTR_GROUP_COLS_INTF;

Dependencies

[top of page]

EGO.EGO_ATTR_GROUP_COLS_INTF does not reference any database object

EGO.EGO_ATTR_GROUP_COLS_INTF is referenced by following:

SchemaEGO
ViewEGO_ATTR_GROUP_COLS_INTF#