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


TABLE: ECX.ECX_OBJECT_ATTRIBUTES

Object Details
Object Name: ECX_OBJECT_ATTRIBUTES
Object Type: TABLE
Owner: ECX
FND Design Data: TableECX.ECX_OBJECT_ATTRIBUTES
Subobject Name:
Status: VALID


This table contains the source and target objectAttributes


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_OBJECT_ATTRIBUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMAP_ID
ColumnATTRIBUTE_ID
ColumnOBJECTLEVEL_ID
ColumnZD_EDITION_NAME
ECX_OBJECT_ATTRIBUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnXREF_CATEGORY_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

ECX.ECX_OBJECT_ATTRIBUTES does not reference any database object

ECX.ECX_OBJECT_ATTRIBUTES is referenced by following:

SchemaECX
ViewECX_OBJECT_ATTRIBUTES#