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: APPS.BOM_ODI_WS_VS_EXCL_V

Source

View Text - Preformatted


select DISTINCT
      session_id,
     --sequence_id,
      pk2_value,
      pk3_value,
      ref5_value,
      ref6_value
   from ego_pub_ws_flat_recs 
   where entity_type = 'VS_EXCLUSION'
   and parent_sequence_id=0

View Text - HTML Formatted

SELECT DISTINCT SESSION_ID
, --SEQUENCE_ID
, PK2_VALUE
, PK3_VALUE
, REF5_VALUE
, REF6_VALUE
FROM EGO_PUB_WS_FLAT_RECS
WHERE ENTITY_TYPE = 'VS_EXCLUSION'
AND PARENT_SEQUENCE_ID=0