[Home] [Help]
View: MRP_BIS_FORECAST_SET_V
View Text
SELECT FORECAST_SET
, FORECAST_DESIGNATOR
, ORGANIZATION_ID
, SUM(FORECAST_QUANTITY)
, SUM(ORDER_QUANTITY)
, SUM(FORECAST_AMOUNT)
, SUM(ORDER_AMOUNT)
, ABS(MRP_GET_BIS_VALUES.FORECAST_ERROR(SUM(FORECAST_AMOUNT)
, SUM(ORDER_AMOUNT)))
FROM MRP_BIS_FORECAST_TREND_V GROUP BY FORECAST_SET
, ORGANIZATION_ID
, FORECAST_DESIGNATOR
Columns
Name |
FORECAST_SET |
FORECAST |
ORGANIZATION_ID |
FORECAST_QUANTITY |
ORDER_QUANTITY |
FORECAST_AMOUNT |
ORDER_AMOUNT |
FORECAST_ERROR |