[Home] [Help] [Dependency Information]
Object Name: | ECX_OBJECT_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | ECX |
FND Design Data: | ECX.ECX_OBJECT_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
This table contains the source and target objectAttributes
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECX_OBJECT_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
MAP_ID
ATTRIBUTE_ID OBJECTLEVEL_ID ZD_EDITION_NAME |
ECX_OBJECT_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | XREF_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Yes | Attribute Identifier | |
OBJECTLEVEL_ID | NUMBER | Yes | Object Level Identifier | |
ATTRIBUTE_NAME | VARCHAR2 | (255) | Attribute Name | |
OBJECT_COLUMN_FLAG | VARCHAR2 | (2) | Database Column Flag | |
DATA_TYPE | NUMBER | Data Type | ||
PARENT_ATTRIBUTE_ID | NUMBER | Yes | Parent Attribute Identifier | |
POSITION | NUMBER | No longer used | ||
WIDTH | NUMBER | No longer used | ||
XREF_CATEGORY_ID | NUMBER | Code Conversion Category Identifier | ||
STAGING_COLUMN | VARCHAR2 | (30) | No longer used | |
DEFAULT_VALUE | VARCHAR2 | (255) | Attribute Default Value | |
ATTRIBUTE_TYPE | VARCHAR2 | (20) | Attribute Type | |
HAS_ATTRIBUTES | VARCHAR2 | (20) | Number of Attributes | |
LEAF_NODE | VARCHAR2 | (1) | Attribute is a Leaf Node Indicator | |
REQUIRED_FLAG | VARCHAR2 | (1) | No longer used | |
MAP_ID | NUMBER | Yes | Map Identifier | |
COND_NODE | VARCHAR2 | (50) | Condition Node Name | |
COND_VALUE | VARCHAR2 | (50) | Condition Node Value | |
COND_NODE_TYPE | VARCHAR2 | (25) | Condition Node Type | |
OCCURRENCE | NUMBER | (15) | No longer used | |
IS_MAPPED | VARCHAR2 | (20) | Attribute is Mapped Indicator | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_ID
, OBJECTLEVEL_ID
, ATTRIBUTE_NAME
, OBJECT_COLUMN_FLAG
, DATA_TYPE
, PARENT_ATTRIBUTE_ID
, POSITION
, WIDTH
, XREF_CATEGORY_ID
, STAGING_COLUMN
, DEFAULT_VALUE
, ATTRIBUTE_TYPE
, HAS_ATTRIBUTES
, LEAF_NODE
, REQUIRED_FLAG
, MAP_ID
, COND_NODE
, COND_VALUE
, COND_NODE_TYPE
, OCCURRENCE
, IS_MAPPED
, ZD_EDITION_NAME
FROM ECX.ECX_OBJECT_ATTRIBUTES;
ECX.ECX_OBJECT_ATTRIBUTES does not reference any database object
ECX.ECX_OBJECT_ATTRIBUTES is referenced by following:
|
|
|