[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 |