MSC_XTR_MEASURE_MAP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
GRANULARITY_ID POSITION MEASURE_CODE MEASURE_ID NAME DESCRIPTION DATA_TYPE EXPRESSION AGGR_ORDER AGGR_METHOD_OTHER AGGR_METHOD_TIME WEIGHTED_BY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

select mm.granularity_id, mm.position, mm.measure_code, m0.measure_id, mt.name, mt.description, m0.data_type, decode(ma.usr_expression, 'ExprIsDeleted', null, nvl(ma.usr_expression, m0.expression)) expression, m0.aggr_order, m0.aggr_method_other, m0.aggr_method_time, m0.weighted_by, mm.created_by, mm.creation_date, mm.last_updated_by, mm.last_update_date, mm.last_update_login from msc_xtr_measure_map mm, msc_measures_b m0, msc_measures_tl mt, msc_measures_addl_def ma where mm.measure_code = m0.measure_code and m0.measure_id = mt.measure_id and mt.language = userenv('LANG') and m0.measure_id = ma.measure_id