VIEW: OSM.AS_MRP_FCT_REPORT#

Source

View Text - Preformatted

select AS_MRP_EXP_ID AS_MRP_EXP_ID, AS_MRP_FCT_ID AS_MRP_FCT_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FORECAST_ID FORECAST_ID, MANAGER_USER_ID MANAGER_USER_ID, MANAGER_ADJUST_DATE MANAGER_ADJUST_DATE, FORECAST_PERIOD FORECAST_PERIOD, EXCESS_SHIP_DATE EXCESS_SHIP_DATE, EXCESS_END_SHIP_DATE EXCESS_END_SHIP_DATE, FORECAST_QUANTITY FORECAST_QUANTITY, UPSIDE_QUANTITY UPSIDE_QUANTITY, PERSON_ID PERSON_ID, SALESGROUP_ID SALESGROUP_ID, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PF_ITEM_ID PF_ITEM_ID, UOM_CODE UOM_CODE, EXCESS_UPSIDE_QUANTITY EXCESS_UPSIDE_QUANTITY, EXCESS_FORECAST_QUANTITY EXCESS_FORECAST_QUANTITY from "OSM"."AS_MRP_FCT_REPORT"

View Text - HTML Formatted

SELECT AS_MRP_EXP_ID AS_MRP_EXP_ID
, AS_MRP_FCT_ID AS_MRP_FCT_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FORECAST_ID FORECAST_ID
, MANAGER_USER_ID MANAGER_USER_ID
, MANAGER_ADJUST_DATE MANAGER_ADJUST_DATE
, FORECAST_PERIOD FORECAST_PERIOD
, EXCESS_SHIP_DATE EXCESS_SHIP_DATE
, EXCESS_END_SHIP_DATE EXCESS_END_SHIP_DATE
, FORECAST_QUANTITY FORECAST_QUANTITY
, UPSIDE_QUANTITY UPSIDE_QUANTITY
, PERSON_ID PERSON_ID
, SALESGROUP_ID SALESGROUP_ID
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PF_ITEM_ID PF_ITEM_ID
, UOM_CODE UOM_CODE
, EXCESS_UPSIDE_QUANTITY EXCESS_UPSIDE_QUANTITY
, EXCESS_FORECAST_QUANTITY EXCESS_FORECAST_QUANTITY
FROM "OSM"."AS_MRP_FCT_REPORT"