MSC_ANALYTIC_FACT_DM_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID CUSTOMER_SITE_ID DEMAND_DATE DEMAND_CLASS_ID SHIP_HISTORY SHIP_FCST FINAL_SHIP_FCST SHIP_HISTORY_VALUE SHIP_FCST_VALUE BOOK_HISTORY BOOK_FCST FINAL_BOOK_FCST BOOK_HISTORY_VALUE FINAL_CONS_FCST FINAL_CONS_HISTORY

Query

SQL_Statement

select dmFactVO.PLAN_ID ,dmFactVO.CREATED_BY ,dmFactVO.CREATION_DATE ,dmFactVO.LAST_UPDATED_BY ,dmFactVO.LAST_UPDATE_DATE ,dmFactVO.LAST_UPDATE_LOGIN ,dmFactVO.OBJECT_VERSION_NUMBER ,dmFactVO.INVENTORY_ITEM_ID ,dmFactVO.ORGANIZATION_ID ,dmFactVO.CUSTOMER_SITE_ID ,dmFactVO.DEMAND_DATE ,dmFactVO.DEMAND_CLASS_ID ,dmFactVO.SHIP_HISTORY ,dmFactVO.SHIP_FCST ,dmFactVO.FINAL_SHIP_FCST ,dmFactVO.SHIP_HISTORY_VALUE ,dmFactVO.SHIP_FCST_VALUE ,dmFactVO.BOOK_HISTORY ,dmFactVO.BOOK_FCST ,dmFactVO.FINAL_BOOK_FCST ,dmFactVO.BOOK_HISTORY_VALUE ,dmFactVO.FINAL_CONS_FCST ,dmFactVO.FINAL_CONS_HISTORY from msc_analytic_private_plan_v planVO,msc_analytic_fact_dm dmFactVO where planVO.plan_id = dmFactVO.plan_id