VIEW: MSC.MSC_FORECAST_UPDATES#

Source

View Text - Preformatted

select FORECAST_DEMAND_ID FORECAST_DEMAND_ID, SALES_ORDER_ID SALES_ORDER_ID, PLAN_ID PLAN_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, DESIGNATOR_ID DESIGNATOR_ID, SHIP_ID SHIP_ID, BILL_ID BILL_ID, CUSTOMER_ID CUSTOMER_ID, SALES_ORDER_QTY SALES_ORDER_QTY, CONSUMED_QTY CONSUMED_QTY, OVERCONSUMPTION_QTY OVERCONSUMPTION_QTY, FORECAST_QTY FORECAST_QTY, SALES_ORDER_DATE SALES_ORDER_DATE, CONSUMPTION_DATE CONSUMPTION_DATE, DEMAND_CLASS DEMAND_CLASS, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, PARENT_ITEM_ID PARENT_ITEM_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, USAGE_QUANTITY USAGE_QUANTITY, ZONE_ID ZONE_ID from "MSC"."MSC_FORECAST_UPDATES"

View Text - HTML Formatted

SELECT FORECAST_DEMAND_ID FORECAST_DEMAND_ID
, SALES_ORDER_ID SALES_ORDER_ID
, PLAN_ID PLAN_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, DESIGNATOR_ID DESIGNATOR_ID
, SHIP_ID SHIP_ID
, BILL_ID BILL_ID
, CUSTOMER_ID CUSTOMER_ID
, SALES_ORDER_QTY SALES_ORDER_QTY
, CONSUMED_QTY CONSUMED_QTY
, OVERCONSUMPTION_QTY OVERCONSUMPTION_QTY
, FORECAST_QTY FORECAST_QTY
, SALES_ORDER_DATE SALES_ORDER_DATE
, CONSUMPTION_DATE CONSUMPTION_DATE
, DEMAND_CLASS DEMAND_CLASS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, PARENT_ITEM_ID PARENT_ITEM_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, USAGE_QUANTITY USAGE_QUANTITY
, ZONE_ID ZONE_ID
FROM "MSC"."MSC_FORECAST_UPDATES"