VIEW: APPS.BOM_ODI_WS_CTX_PATHS_V

Source

View Text - Preformatted

SELECT DISTINCT 
     hdrs.session_id,
     hdrs.sequence_id,
     ctx.ref5_value,
     ctx.ref6_value
   FROM ego_pub_ws_flat_recs hdrs,
     ego_pub_ws_flat_recs ctx
   WHERE hdrs.entity_type = 'SH'
   AND ctx.entity_type IN('COMP_EXCLUSION', 'COMP_OVR_AG', 'VS_EXCLUSION')
   AND ctx.ref6_value = hdrs.pk1_value
   AND ctx.session_id = hdrs.session_id
   

View Text - HTML Formatted

SELECT DISTINCT HDRS.SESSION_ID
, HDRS.SEQUENCE_ID
, CTX.REF5_VALUE
, CTX.REF6_VALUE
FROM EGO_PUB_WS_FLAT_RECS HDRS
, EGO_PUB_WS_FLAT_RECS CTX
WHERE HDRS.ENTITY_TYPE = 'SH'
AND CTX.ENTITY_TYPE IN('COMP_EXCLUSION'
, 'COMP_OVR_AG'
, 'VS_EXCLUSION')
AND CTX.REF6_VALUE = HDRS.PK1_VALUE
AND CTX.SESSION_ID = HDRS.SESSION_ID