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


TABLE: APPLSYS.WF_ENTITY_CHANGES

Object Details
Object Name: WF_ENTITY_CHANGES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_ENTITY_CHANGES
Subobject Name:
Status: VALID


Stores pending changes for OID


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ENTITY_CHANGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_KEY_VALUE
ColumnENTITY_TYPE
WF_ENTITY_CHANGES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_TYPE VARCHAR2 (50) Yes Specifies entity type
ENTITY_KEY_VALUE VARCHAR2 (256) Yes The identifying key value for this entity
FLAVOR VARCHAR2 (10) Yes Specifies what kind of entity this is
CHANGE_DATE DATE
Yes Specifies when this entity change was 'enqueued'
ENTITY_ID NUMBER

Sequence Number generated for OID at runtime
Query Text

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


SELECT ENTITY_TYPE
,      ENTITY_KEY_VALUE
,      FLAVOR
,      CHANGE_DATE
,      ENTITY_ID
FROM APPLSYS.WF_ENTITY_CHANGES;

Dependencies

[top of page]

APPLSYS.WF_ENTITY_CHANGES does not reference any database object

APPLSYS.WF_ENTITY_CHANGES is referenced by following:

SchemaAPPLSYS
ViewWF_ENTITY_CHANGES#