[Home] [Help] [Dependency Information]
Object Name: | EGO_EXT_SYS_ELEMENTS |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_EXT_SYS_ELEMENTS |
Subobject Name: | |
Status: | VALID |
This table is used to store XML Schema Definitions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_EXT_SYS_ELEMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXTERNAL_ELEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTERNAL_ELEMENT_ID | NUMBER | Yes | Unique identifier for each Schema | |
SOURCE_SYSTEM_ID | NUMBER | Yes | Foreign key to HZ_ORIG_SYSTEMS_VL | |
ELEMENT_TYPE | VARCHAR2 | (1) | Yes | To Determine if the element is an Attribute or an UOM. |
EXT_ATTRIBUTE_NAME | VARCHAR2 | (50) | Contains the External System Attribute Name. | |
EXT_UOM_NAME | VARCHAR2 | (50) | Contains the External System UOM Name. | |
DEFAULT_UOM | VARCHAR2 | (50) | Contains the default UOM for the given 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 | ||
EXT_ATTR_DATA_TYPE | VARCHAR2 | (10) | Datatype of External Attribute. |
Cut, paste (and edit) the following text to query this object:
SELECT EXTERNAL_ELEMENT_ID
, SOURCE_SYSTEM_ID
, ELEMENT_TYPE
, EXT_ATTRIBUTE_NAME
, EXT_UOM_NAME
, DEFAULT_UOM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, EXT_ATTR_DATA_TYPE
FROM EGO.EGO_EXT_SYS_ELEMENTS;
EGO.EGO_EXT_SYS_ELEMENTS does not reference any database object
EGO.EGO_EXT_SYS_ELEMENTS is referenced by following:
|
|
|