VIEW: MRP.MRP_BIS_FORECAST_WB#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, FORECAST_SET FORECAST_SET, FORECAST FORECAST, FORECAST_DESCRIPTION FORECAST_DESCRIPTION, UPDATE_TYPE UPDATE_TYPE, DEMAND_CLASS DEMAND_CLASS, CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_SET CATEGORY_SET, CATEGORY_ID CATEGORY_ID, CATEGORY CATEGORY, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID, PRODUCT_FAMILY_NUMBER PRODUCT_FAMILY_NUMBER, PRODUCT_FAMILY_DESC PRODUCT_FAMILY_DESC, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NUMBER ITEM_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, CUSTOMER_CLASS CUSTOMER_CLASS, CUSTOMER_ID CUSTOMER_ID, CUSTOMER CUSTOMER, SHIP_ID SHIP_ID, SHIP_TO_ADDRESS SHIP_TO_ADDRESS, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TO_ZIP SHIP_TO_ZIP, BILL_ID BILL_ID, BILL_TO_ADDRESS BILL_TO_ADDRESS, BILL_TO_CITY BILL_TO_CITY, BILL_TO_STATE BILL_TO_STATE, BILL_TO_ZIP BILL_TO_ZIP, FORECAST_DATE FORECAST_DATE, FORECAST_QUANTITY FORECAST_QUANTITY, ORDER_QUANTITY ORDER_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, FORECAST_AMOUNT FORECAST_AMOUNT, ORDER_AMOUNT ORDER_AMOUNT, SHIPPED_AMOUNT SHIPPED_AMOUNT, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "MRP"."MRP_BIS_FORECAST_WB"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, FORECAST_SET FORECAST_SET
, FORECAST FORECAST
, FORECAST_DESCRIPTION FORECAST_DESCRIPTION
, UPDATE_TYPE UPDATE_TYPE
, DEMAND_CLASS DEMAND_CLASS
, CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_SET CATEGORY_SET
, CATEGORY_ID CATEGORY_ID
, CATEGORY CATEGORY
, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION
, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID
, PRODUCT_FAMILY_NUMBER PRODUCT_FAMILY_NUMBER
, PRODUCT_FAMILY_DESC PRODUCT_FAMILY_DESC
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, CUSTOMER_CLASS CUSTOMER_CLASS
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER CUSTOMER
, SHIP_ID SHIP_ID
, SHIP_TO_ADDRESS SHIP_TO_ADDRESS
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TO_ZIP SHIP_TO_ZIP
, BILL_ID BILL_ID
, BILL_TO_ADDRESS BILL_TO_ADDRESS
, BILL_TO_CITY BILL_TO_CITY
, BILL_TO_STATE BILL_TO_STATE
, BILL_TO_ZIP BILL_TO_ZIP
, FORECAST_DATE FORECAST_DATE
, FORECAST_QUANTITY FORECAST_QUANTITY
, ORDER_QUANTITY ORDER_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, FORECAST_AMOUNT FORECAST_AMOUNT
, ORDER_AMOUNT ORDER_AMOUNT
, SHIPPED_AMOUNT SHIPPED_AMOUNT
, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "MRP"."MRP_BIS_FORECAST_WB"