MSC_DIM_ATTRIBUTE

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ID NAME LEVEL_ID

Name

ID

NAME

LEVEL_ID

Query

SQL_Statement
SELECT mav.attribute_dest_value_id ID, mav.attribute_value NAME, lmap.level_id LEVEL_ID FROM msc_attribute_values mav, msc_dim_attr_lmap lmap where mav.attribute_number not in (1,2,16) and mav.attribute_id = lmap.attribute_id and mav.plan_id = -1

SQL_Statement

SELECT

mav.attribute_dest_value_id ID,

mav.attribute_value NAME,

lmap.level_id LEVEL_ID

FROM

msc_attribute_values mav, msc_dim_attr_lmap lmap where mav.attribute_number not in (1,2,16) and mav.attribute_id = lmap.attribute_id and mav.plan_id = -1