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

TABLE: ENG.ENG_CHANGE_OBJECTS

Object Details
Object Name: ENG_CHANGE_OBJECTS
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_CHANGE_OBJECTS
Subobject Name:
Status: VALID


Engineering Change Objects (Base MLS Table)


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_CHANGE_OBJECTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnENTITY_NAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

Object ID
QUERY_OBJECT_NAME VARCHAR2 (30) Yes Query Object Name
QUERY_COLUMN1_NAME VARCHAR2 (30) Yes Query Column1 Name
QUERY_COLUMN2_NAME VARCHAR2 (30)
Query Column2 Name
QUERY_COLUMN3_NAME VARCHAR2 (30)
Query Column3 Name
QUERY_COLUMN4_NAME VARCHAR2 (30)
Query Column4 Name
QUERY_COLUMN5_NAME VARCHAR2 (30)
Query Column5 Name
QUERY_COLUMN1_TYPE VARCHAR2 (8)
Query Column1 Type
QUERY_COLUMN2_TYPE VARCHAR2 (8)
Query Column2 Type
QUERY_COLUMN3_TYPE VARCHAR2 (8)
Query Column3 Type
QUERY_COLUMN4_TYPE VARCHAR2 (8)
Query Column4 Type
QUERY_COLUMN5_TYPE VARCHAR2 (8)
Query Column5 Type
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
ENTITY_NAME VARCHAR2 (30) Yes Name of the entity
PK1_COLUMN_NAME VARCHAR2 (30)
Primary key of the entity
PK2_COLUMN_NAME VARCHAR2 (30)
Primary key of the entity
PK3_COLUMN_NAME VARCHAR2 (30)
Primary key of the entity
PK4_COLUMN_NAME VARCHAR2 (30)
Primary key of the entity
PK5_COLUMN_NAME VARCHAR2 (30)
Primary key of the entity
ENTITY_URL VARCHAR2 (2000)
URL of the entity
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT OBJECT_ID
,      QUERY_OBJECT_NAME
,      QUERY_COLUMN1_NAME
,      QUERY_COLUMN2_NAME
,      QUERY_COLUMN3_NAME
,      QUERY_COLUMN4_NAME
,      QUERY_COLUMN5_NAME
,      QUERY_COLUMN1_TYPE
,      QUERY_COLUMN2_TYPE
,      QUERY_COLUMN3_TYPE
,      QUERY_COLUMN4_TYPE
,      QUERY_COLUMN5_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENTITY_NAME
,      PK1_COLUMN_NAME
,      PK2_COLUMN_NAME
,      PK3_COLUMN_NAME
,      PK4_COLUMN_NAME
,      PK5_COLUMN_NAME
,      ENTITY_URL
,      ZD_EDITION_NAME
FROM ENG.ENG_CHANGE_OBJECTS;

Dependencies

[top of page]

ENG.ENG_CHANGE_OBJECTS does not reference any database object

ENG.ENG_CHANGE_OBJECTS is referenced by following:

SchemaENG
ViewENG_CHANGE_OBJECTS#