[Home] [Help]
View: 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 |