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

TABLE: EGO.EGO_PUB_WS_ENTITIES

Object Details
Object Name: EGO_PUB_WS_ENTITIES
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_PUB_WS_ENTITIES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000521299C00023$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes
ODI_SESSION_ID NUMBER
Yes
ENTITY_TYPE VARCHAR2 (100) Yes
SEQUENCE_ID NUMBER
Yes
PARENT_SEQUENCE_ID NUMBER

LEVEL_NUMBER NUMBER

PAYLOAD_SEQUENCE NUMBER

PK1_VALUE VARCHAR2 (150) Yes
PK2_VALUE VARCHAR2 (150)
PK3_VALUE VARCHAR2 (150)
PK4_VALUE VARCHAR2 (150)
PK5_VALUE VARCHAR2 (150)
REF1_VALUE VARCHAR2 (4000)
REF2_VALUE VARCHAR2 (4000)
REF3_VALUE VARCHAR2 (4000)
REF4_VALUE VARCHAR2 (4000)
REF5_VALUE VARCHAR2 (4000)
REF6_VALUE VARCHAR2 (4000)
REF7_VALUE VARCHAR2 (4000)
REF8_VALUE VARCHAR2 (4000)
REF9_VALUE VARCHAR2 (4000)
REF10_VALUE VARCHAR2 (4000)
VALUE CLOB (4000)
CREATION_DATE DATE

CREATED_BY NUMBER

USER_ENTERED VARCHAR2 (1)
Query Text

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


SELECT SESSION_ID
,      ODI_SESSION_ID
,      ENTITY_TYPE
,      SEQUENCE_ID
,      PARENT_SEQUENCE_ID
,      LEVEL_NUMBER
,      PAYLOAD_SEQUENCE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      REF1_VALUE
,      REF2_VALUE
,      REF3_VALUE
,      REF4_VALUE
,      REF5_VALUE
,      REF6_VALUE
,      REF7_VALUE
,      REF8_VALUE
,      REF9_VALUE
,      REF10_VALUE
,      VALUE
,      CREATION_DATE
,      CREATED_BY
,      USER_ENTERED
FROM EGO.EGO_PUB_WS_ENTITIES;

Dependencies

[top of page]

EGO.EGO_PUB_WS_ENTITIES does not reference any database object

EGO.EGO_PUB_WS_ENTITIES is referenced by following:

SchemaEGO
ViewEGO_PUB_WS_ENTITIES#