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: OLAPSYS.ALL$AW_LOAD_CUBE_FILT

Source

View Text - Preformatted


select
   lcm.owner owner,
   lcm.cube_name cube_name,
   lcm.load_name load_name,
   lf.Fact_Table_Owner table_owner,
   lf.Fact_Table_Name  table_name,
   lf.filtercondition filter_condition
 from olapsys.all$aw_load_cube_map lcm,
      olapsys.cwm2$awcubeloadfilter lf
 where lcm.load_irid = lf.cubeload_irid
with read only

View Text - HTML Formatted

SELECT LCM.OWNER OWNER
, LCM.CUBE_NAME CUBE_NAME
, LCM.LOAD_NAME LOAD_NAME
, LF.FACT_TABLE_OWNER TABLE_OWNER
, LF.FACT_TABLE_NAME TABLE_NAME
, LF.FILTERCONDITION FILTER_CONDITION
FROM OLAPSYS.ALL$AW_LOAD_CUBE_MAP LCM
, OLAPSYS.CWM2$AWCUBELOADFILTER LF
WHERE LCM.LOAD_IRID = LF.CUBELOAD_IRID WITH READ ONLY