MSC_ANALYTIC_FACT_CTO_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PLAN_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER INVENTORY_ITEM_ID TOP_MODEL_ITEM_ID ORGANIZATION_ID CUSTOMER_SITE_ID DEMAND_DATE DEMAND_CLASS_ID OPTION_DEMAND_FCST FINAL_OPTION_DEMAND_FCST FINAL_PLANNING_PERCENT CTO_LVL_MEMBER_ID |
問合せ
| SQL_Statement |
|---|
|
select ctoFactVO.PLAN_ID ,ctoFactVO.CREATED_BY ,ctoFactVO.CREATION_DATE ,ctoFactVO.LAST_UPDATED_BY ,ctoFactVO.LAST_UPDATE_DATE ,ctoFactVO.LAST_UPDATE_LOGIN ,ctoFactVO.OBJECT_VERSION_NUMBER ,ctoFactVO.INVENTORY_ITEM_ID ,ctoFactVO.TOP_MODEL_ITEM_ID ,ctoFactVO.ORGANIZATION_ID ,ctoFactVO.CUSTOMER_SITE_ID ,ctoFactVO.DEMAND_DATE ,ctoFactVO.DEMAND_CLASS_ID ,ctoFactVO.OPTION_DEMAND_FCST ,ctoFactVO.FINAL_OPTION_DEMAND_FCST ,ctoFactVO.FINAL_PLANNING_PERCENT, ctoFactVO.CTO_LVL_MEMBER_ID from msc_analytic_private_plan_v planVO,msc_analytic_fact_cto ctoFactVO where planVO.plan_id = ctoFactVO.plan_id |