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

TABLE: EGO.EGO_PUB_WS_OUTPUT

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

This table stores output xml for a webservice call.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000510526C00008$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000510526C00010$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000510526C00011$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes A db generated sequence Id.
ODI_SESSION_ID NUMBER
Yes Unique ODI Session Id.
WEB_SERVICE_NAME VARCHAR2 (100)
SEQUENCE_ID NUMBER
Yes A unique sequnce Id for top level entity, If output xml is chunked for a webservice call
ENTITY_TYPE VARCHAR2 (100)
The Entity to be published.
STATUS VARCHAR2 (100)
Status of a record, Column will be used by AIA to mark it.
XML_ODI XMLTYPE (2000)
Proccessed output xml from odi.
XMLCONTENT XMLTYPE (2000)
Final output xml of xmltype.
XMLCLOB CLOB (4000)
Final output xml of clob type.
CREATION_DATE DATE
Yes Date of record creation.
CREATED_BY NUMBER
Yes Party Id who created record.
Query Text

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


SELECT SESSION_ID
,      ODI_SESSION_ID
,      WEB_SERVICE_NAME
,      SEQUENCE_ID
,      ENTITY_TYPE
,      STATUS
,      XML_ODI
,      XMLCONTENT
,      XMLCLOB
,      CREATION_DATE
,      CREATED_BY
FROM EGO.EGO_PUB_WS_OUTPUT;

Dependencies

[top of page]

EGO.EGO_PUB_WS_OUTPUT references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
EGO.EGO_PUB_WS_OUTPUT is referenced by following:

SchemaEGO
ViewEGO_PUB_WS_OUTPUT#