VIEW: APPS.ZPB_OS_MEASURES_V

Source

View Text - Preformatted

SELECT meas.measure_id measure_id, meas.instance_id instance_id, meas.name measure_name, meas.type measure_type, meas.currency_type currency_type, meas.selected_cur selected_currency, cube.name olap_fact_table, cols.column_name olap_fact_table_column from zpb_measures meas, zpb_cubes cube, zpb_columns cols where meas.cube_id = cube.cube_id and cube.type = 'MEASCUBE' and meas.type in ('SHARED_DATA', 'SHARED_CALC', 'SHARED_ANNOTATION', 'SHARED_CALC_ANNOTATION') and meas.column_id = cols.column_id and cube.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id')

View Text - HTML Formatted

SELECT MEAS.MEASURE_ID MEASURE_ID
, MEAS.INSTANCE_ID INSTANCE_ID
, MEAS.NAME MEASURE_NAME
, MEAS.TYPE MEASURE_TYPE
, MEAS.CURRENCY_TYPE CURRENCY_TYPE
, MEAS.SELECTED_CUR SELECTED_CURRENCY
, CUBE.NAME OLAP_FACT_TABLE
, COLS.COLUMN_NAME OLAP_FACT_TABLE_COLUMN
FROM ZPB_MEASURES MEAS
, ZPB_CUBES CUBE
, ZPB_COLUMNS COLS
WHERE MEAS.CUBE_ID = CUBE.CUBE_ID
AND CUBE.TYPE = 'MEASCUBE'
AND MEAS.TYPE IN ('SHARED_DATA'
, 'SHARED_CALC'
, 'SHARED_ANNOTATION'
, 'SHARED_CALC_ANNOTATION')
AND MEAS.COLUMN_ID = COLS.COLUMN_ID
AND CUBE.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')