VIEW: OLAPSYS.ALL$AW_LOAD_DIM

Source

View Text - Preformatted

select
    ldm.owner owner,
    ldm.dimension_name dimension_name,
    ldm.load_name load_name,
    lt.name load_type
  from olapsys.all$aw_load_dim_map ldm,
       olapsys.cwm2$awdimload l,
       olapsys.cwm2$awdimloadtype lt
  where ldm.dim_irid = l.dim_irid and
        ldm.load_irid = l.irid and
        l.loadtype_irid = lt.irid
  with read only

View Text - HTML Formatted

SELECT LDM.OWNER OWNER
, LDM.DIMENSION_NAME DIMENSION_NAME
, LDM.LOAD_NAME LOAD_NAME
, LT.NAME LOAD_TYPE
FROM OLAPSYS.ALL$AW_LOAD_DIM_MAP LDM
, OLAPSYS.CWM2$AWDIMLOAD L
, OLAPSYS.CWM2$AWDIMLOADTYPE LT
WHERE LDM.DIM_IRID = L.DIM_IRID AND LDM.LOAD_IRID = L.IRID AND L.LOADTYPE_IRID = LT.IRID WITH READ ONLY