MSC_ANALYTIC_FACT_SOP_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 CONSENSUS_FCST SALES_FCST FINAL_SALES_FCST CONSENSUS_FCST_VALUE SALES_FCST_VALUE FINAL_SALES_FCST_VALUE

Query

SQL_Statement

select sopFactVO.PLAN_ID ,sopFactVO.CREATED_BY ,sopFactVO.CREATION_DATE ,sopFactVO.LAST_UPDATED_BY ,sopFactVO.LAST_UPDATE_DATE ,sopFactVO.LAST_UPDATE_LOGIN ,sopFactVO.OBJECT_VERSION_NUMBER ,sopFactVO.INVENTORY_ITEM_ID ,sopFactVO.ORGANIZATION_ID ,sopFactVO.CUSTOMER_SITE_ID ,sopFactVO.DEMAND_DATE ,sopFactVO.DEMAND_CLASS_ID ,sopFactVO.CONSENSUS_FCST ,sopFactVO.SALES_FCST ,sopFactVO.FINAL_SALES_FCST ,sopFactVO.CONSENSUS_FCST_VALUE ,sopFactVO.SALES_FCST_VALUE ,sopFactVO.FINAL_SALES_FCST_VALUE from msc_analytic_private_plan_v planVO,msc_analytic_fact_sop sopFactVO where planVO.plan_id = sopFactVO.plan_id