FND Design Data [Home] [Help]

View: MRP_BIS_FORECAST_WB_V

Product: MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data: ViewAPPS.MRP_BIS_FORECAST_WB_V
View Text

SELECT ORGANIZATION_CODE
, ORGANIZATION_NAME
, FORECAST_SET
, NULL
, DEMAND_CLASS
, NULL
, CATEGORY_SET
, CATEGORY
, CATEGORY_DESCRIPTION
, NULL
, PRODUCT_FAMILY_NUMBER
, PRODUCT_FAMILY_DESC
, ITEM_NUMBER
, ITEM_DESCRIPTION
, NULL
, CUSTOMER_CLASS
, CUSTOMER
, SHIP_TO_ADDRESS
, SHIP_TO_CITY
, SHIP_TO_STATE
, SHIP_TO_ZIP
, BILL_TO_ADDRESS
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_ZIP
, FORECAST_DATE
, FORECAST_QUANTITY
, ORDER_QUANTITY
, SHIPPED_QUANTITY
, FORECAST_AMOUNT
, ORDER_AMOUNT
, SHIPPED_AMOUNT
FROM MRP_BIS_FORECAST_WB

Columns

Name
ORGANIZATION_CODE
ORGANIZATION_NAME
FORECAST_SET
ALL_DEMAND_CLASSES
DEMAND_CLASS
ALL_CATEGORY_SETS
CATEGORY_SET
CATEGORY
CATEGORY_DESCRIPTION
ALL_PRODUCT_FAMILIES
PRODUCT_FAMILY_NUMBER
PRODUCT_FAMILY_DESC
ITEM_NUMBER
ITEM_DESCRIPTION
ALL_CUSTOMER_CLASSES
CUSTOMER_CLASS
CUSTOMER
SHIP_TO_ADDRESS
SHIP_TO_CITY
SHIP_TO_STATE
SHIP_TO_ZIP
BILL_TO_ADDRESS
BILL_TO_CITY
BILL_TO_STATE
BILL_TO_ZIP
FORECAST_DATE
FORECAST_QUANTITY
ORDER_QUANTITY
SHIPPED_QUANTITY
FORECAST_AMOUNT
ORDER_AMOUNT
SHIPPED_AMOUNT