eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EGO.EGO_PUB_WS_FLAT_RECS

Object Details

Object Name:	EGO_PUB_WS_FLAT_RECS
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_PUB_WS_FLAT_RECS
Subobject Name:
Status:	VALID

This table stores all entities to be published as output xml for a given xml input.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000510519C00023$$	LOB	UNIQUE	APPS_TS_TX_DATA
EGO_PUB_WS_FLAT_RECS_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SESSION_ID SEQUENCE_ID PARENT_SEQUENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	It is db generated sequence Id.
ODI_SESSION_ID	NUMBER		Yes	Unique ODI Session Id.
ENTITY_TYPE	VARCHAR2	(100)	Yes	The Entity Tag for a value..
SEQUENCE_ID	NUMBER		Yes	A Unique Identifier, It is db generated sequence Id.
PARENT_SEQUENCE_ID	NUMBER			Parent sequence Id of an Entity if it is a child of another entity.
LEVEL_NUMBER	NUMBER			A number identifying level between entities in a hierarchy.
PAYLOAD_SEQUENCE	NUMBER			Preference Sequence Id among entities at same level.
PK1_VALUE	VARCHAR2	(150)	Yes	Primary key identifier for an entity.
PK2_VALUE	VARCHAR2	(150)		Primary key identifier for an entity.
PK3_VALUE	VARCHAR2	(150)		Primary key identifier for an entity.
PK4_VALUE	VARCHAR2	(150)		Primary key identifier for an entity.
PK5_VALUE	VARCHAR2	(150)		Primary key identifier for an entity.
REF1_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF2_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF3_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF4_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF5_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF6_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF7_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF8_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF9_VALUE	VARCHAR2	(4000)		Reference key for an entity.
REF10_VALUE	VARCHAR2	(4000)		Reference key for an entity.
VALUE	CLOB	(4000)		Detailed information for an entity to be published.
CREATION_DATE	DATE			Creation date for a record.
CREATED_BY	NUMBER

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
FROM EGO.EGO_PUB_WS_FLAT_RECS;

Dependencies

[top of page]

EGO.EGO_PUB_WS_FLAT_RECS does not reference any database object

EGO.EGO_PUB_WS_FLAT_RECS is referenced by following:

EGO: EGO_PUB_WS_FLAT_RECS#