VIEW: APPS.ZPB_OS_MEAS_DIMS_V

Source

View Text - Preformatted

SELECT meas.instance_id, meas.name measure_name, dims.name dimension_name, tabl.table_name dim_table_name, meas.measure_id from zpb_measures meas, zpb_cubes cube, zpb_cube_dims cudi, zpb_dimensions_vl dims, zpb_tables tabl WHERE meas.cube_id = cube.cube_id and cube.cube_id = cudi.cube_id and cudi.dimension_id = dims.dimension_id and dims.shar_table_id = tabl.table_id and cube.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id') and cube.type='MEASCUBE'

View Text - HTML Formatted

SELECT MEAS.INSTANCE_ID
, MEAS.NAME MEASURE_NAME
, DIMS.NAME DIMENSION_NAME
, TABL.TABLE_NAME DIM_TABLE_NAME
, MEAS.MEASURE_ID
FROM ZPB_MEASURES MEAS
, ZPB_CUBES CUBE
, ZPB_CUBE_DIMS CUDI
, ZPB_DIMENSIONS_VL DIMS
, ZPB_TABLES TABL
WHERE MEAS.CUBE_ID = CUBE.CUBE_ID
AND CUBE.CUBE_ID = CUDI.CUBE_ID
AND CUDI.DIMENSION_ID = DIMS.DIMENSION_ID
AND DIMS.SHAR_TABLE_ID = TABL.TABLE_ID
AND CUBE.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')
AND CUBE.TYPE='MEASCUBE'