MSC_DIM_ATTRIBUTE_V

詳細

スキーマ: FUSION
オブジェクト所有者: MSC
オブジェクト・タイプ: VIEW

列

名前
ID NAME LEVEL_ID

名前

NAME

LEVEL_ID

問合せ

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