VIEW: OLAPSYS.ALL$AW_LOAD_CUBES

Source

View Text - Preformatted

select c.owner cube_owner,
         c.name cube_name,
         cl.name load_name,
         clt.name load_type
  from
    cwm2$awcubeload cl,
    cwm2$awcubeloadtype clt,
    cwm2$cube c
  where
    cl.loadtype_irid = clt.irid and
    cl.cube_irid = c.irid and
    cl.version_id = 'CWM2' and
    (c.invalid = 'N' or c.invalid = 'O') and
    (cwm2$security.fact_table_visible(c.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47)))
 union all
  select sch.physicalname cube_owner,
         c.physicalname cube_name,
         cl.name load_name,
         clt.name load_type
  from
    cwm2$awcubeload cl,
    cwm2$awcubeloadtype clt,
    cwm$cube c,
    cwm$model sch
  where
   cl.loadtype_irid = clt.irid and
   cl.cube_irid = c.irid and
   cl.version_id = 'CWM' and
   sch.irid = c.datamodel_irid and
   (cwm$util.fact_table_visible(c.irid) = 'Y'
      OR EXISTS (select null from v$enabledprivs
                 where priv_number in (-47)))
with read only

View Text - HTML Formatted

SELECT C.OWNER CUBE_OWNER
, C.NAME CUBE_NAME
, CL.NAME LOAD_NAME
, CLT.NAME LOAD_TYPE FROM CWM2$AWCUBELOAD CL
, CWM2$AWCUBELOADTYPE CLT
, CWM2$CUBE C WHERE CL.LOADTYPE_IRID = CLT.IRID AND CL.CUBE_IRID = C.IRID AND CL.VERSION_ID = 'CWM2' AND (C.INVALID = 'N' OR C.INVALID = 'O') AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) UNION ALL SELECT SCH.PHYSICALNAME CUBE_OWNER
, C.PHYSICALNAME CUBE_NAME
, CL.NAME LOAD_NAME
, CLT.NAME LOAD_TYPE FROM CWM2$AWCUBELOAD CL
, CWM2$AWCUBELOADTYPE CLT
, CWM$CUBE C
, CWM$MODEL SCH WHERE CL.LOADTYPE_IRID = CLT.IRID AND CL.CUBE_IRID = C.IRID AND CL.VERSION_ID = 'CWM' AND SCH.IRID = C.DATAMODEL_IRID AND (CWM$UTIL.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) WITH READ ONLY