VIEW: APPS.MSC_DEMANTRA_ODS_V

Source

View Text - Preformatted

SELECT to_number(-1) plan_id, to_number(-1) plan_run_id, to_number(-1) ods_plan_id, od.sr_instance_id, od.organization_id, od.inventory_item_id, od.customer_id, od.customer_site_id, od.region_id, od.demand_class, od.end_date forecast_date, od.sales_fcst, od.sales_fcst_value, od.sales_fcst_value2, od.sales_fcst_cum, od.mktg_fcst, od.mktg_fcst_value, od.mktg_fcst_value2, od.mktg_fcst_cum, od.budget, od.budget2, od.budget_cum, od.budget2_cum, od.booking_fcst, od.booking_fcst_value, od.booking_fcst_value2, od.booking_fcst_cum, od.shipment_fcst, od.shipment_fcst_value, od.shipment_fcst_value2, od.shipment_fcst_cum, od.projected_backlog, od.actual_backlog, od.production_history, od.shipment_history, od.shipment_history_value, od.shipment_history_value2, od.booking_history, od.booking_history_value, od.booking_history_value2, od.consen_fcst_accrcy_mape_4week, od.consen_fcst_accrcy_mape_8week, od.consen_fcst_accrcy_mape_13week, od.price from msd_dem_obi_demantra_syn od

View Text - HTML Formatted

SELECT TO_NUMBER(-1) PLAN_ID
, TO_NUMBER(-1) PLAN_RUN_ID
, TO_NUMBER(-1) ODS_PLAN_ID
, OD.SR_INSTANCE_ID
, OD.ORGANIZATION_ID
, OD.INVENTORY_ITEM_ID
, OD.CUSTOMER_ID
, OD.CUSTOMER_SITE_ID
, OD.REGION_ID
, OD.DEMAND_CLASS
, OD.END_DATE FORECAST_DATE
, OD.SALES_FCST
, OD.SALES_FCST_VALUE
, OD.SALES_FCST_VALUE2
, OD.SALES_FCST_CUM
, OD.MKTG_FCST
, OD.MKTG_FCST_VALUE
, OD.MKTG_FCST_VALUE2
, OD.MKTG_FCST_CUM
, OD.BUDGET
, OD.BUDGET2
, OD.BUDGET_CUM
, OD.BUDGET2_CUM
, OD.BOOKING_FCST
, OD.BOOKING_FCST_VALUE
, OD.BOOKING_FCST_VALUE2
, OD.BOOKING_FCST_CUM
, OD.SHIPMENT_FCST
, OD.SHIPMENT_FCST_VALUE
, OD.SHIPMENT_FCST_VALUE2
, OD.SHIPMENT_FCST_CUM
, OD.PROJECTED_BACKLOG
, OD.ACTUAL_BACKLOG
, OD.PRODUCTION_HISTORY
, OD.SHIPMENT_HISTORY
, OD.SHIPMENT_HISTORY_VALUE
, OD.SHIPMENT_HISTORY_VALUE2
, OD.BOOKING_HISTORY
, OD.BOOKING_HISTORY_VALUE
, OD.BOOKING_HISTORY_VALUE2
, OD.CONSEN_FCST_ACCRCY_MAPE_4WEEK
, OD.CONSEN_FCST_ACCRCY_MAPE_8WEEK
, OD.CONSEN_FCST_ACCRCY_MAPE_13WEEK
, OD.PRICE
FROM MSD_DEM_OBI_DEMANTRA_SYN OD