[Home] [Help] [Dependency Information]
Object Name: | EGO_ATTR_MAPPING_ROWS |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_ATTR_MAPPING_ROWS |
Subobject Name: | |
Status: | VALID |
This table is used to store Mapping row for each attribute.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_ATTR_MAPPING_ROWS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTR_MAPPING_ROW_ID |
EGO_ATTR_MAPPING_ROWS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTR_MAPPING_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_MAPPING_ROW_ID | NUMBER | Yes | Unique identifier for each attr mapping row. | |
ATTR_MAPPING_ID | NUMBER | Yes | Foreign key to EGO_ATTR_MAPPING_MASTER table. | |
ATTR_GROUP_ID | NUMBER | Yes | Attribute Group Id | |
ATTR_ID | NUMBER | Yes | Attribute Id | |
PK1_VALUE | VARCHAR2 | (256) | PK Value to uniquely identify the Source System Attribute | |
PK2_VALUE | VARCHAR2 | (256) | PK Value to uniquely identify the Source System Attribute | |
PK3_VALUE | VARCHAR2 | (256) | PK Value to uniquely identify the Source System Attribute | |
PK4_VALUE | VARCHAR2 | (256) | PK Value to uniquely identify the Source System Attribute | |
PK5_VALUE | VARCHAR2 | (256) | PK Value to uniquely identify the Source System Attribute | |
LAST_UPDATE_DATE | DATE | Yes | Date record was last modified | |
LAST_UPDATED_BY | NUMBER | Yes | User id of last person modifying the record | |
CREATION_DATE | DATE | Yes | Date record was created | |
CREATED_BY | NUMBER | Yes | User id of Person who created record | |
LAST_UPDATE_LOGIN | NUMBER | Login of last person who updated record | ||
DEFAULT_UOM | VARCHAR2 | (50) | Default UOM of the Attribute | |
EXT_ATTR_DATA_TYPE | VARCHAR2 | (10) | Data Type of the External Attribute | |
ATTRIBUTE_NAME | VARCHAR2 | (256) | The PDH Attribute Internal Name | |
SOURCE_ATTRIBUTE_NAME | VARCHAR2 | (256) | The Source System Attribute Name |
Cut, paste (and edit) the following text to query this object:
SELECT ATTR_MAPPING_ROW_ID
, ATTR_MAPPING_ID
, ATTR_GROUP_ID
, ATTR_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DEFAULT_UOM
, EXT_ATTR_DATA_TYPE
, ATTRIBUTE_NAME
, SOURCE_ATTRIBUTE_NAME
FROM EGO.EGO_ATTR_MAPPING_ROWS;
EGO.EGO_ATTR_MAPPING_ROWS does not reference any database object
EGO.EGO_ATTR_MAPPING_ROWS is referenced by following:
|
|
|