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.

VIEW: EGO.EGO_PUB_WS_ENTITIES#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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