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.

[Home] [Help]

View: BOM_ODI_WS_CTX_PATHS_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.BOM_ODI_WS_CTX_PATHS_V

View Text

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