eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_RHX_DAILY_FORECASTS_V

Product:	MRP - Master Scheduling/MRP
Description:	An Integration Toolkit view supporting information regarding forecasted demand for an item
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FCST.INVENTORY_ITEM_ID
, DESIG.ORGANIZATION_ID
, ITEMS.ITEM_NUMBER
, DATES.CALENDAR_DATE
, FCST.ORIGINAL_FORECAST_QUANTITY
, FCST.CURRENT_FORECAST_QUANTITY
, FCST.BUCKET_TYPE
, FCST.TRANSACTION_ID
, FCST.CONFIDENCE_PERCENTAGE
, DESIG.FORECAST_DESIGNATOR
, DESIG.FORECAST_SET
, FCST.ATTRIBUTE_CATEGORY
, FCST.ATTRIBUTE1
, FCST.ATTRIBUTE2
, FCST.ATTRIBUTE3
, FCST.ATTRIBUTE4
, FCST.ATTRIBUTE5
, FCST.ATTRIBUTE6
, FCST.ATTRIBUTE7
, FCST.ATTRIBUTE8
, FCST.ATTRIBUTE9
, FCST.ATTRIBUTE10
, FCST.ATTRIBUTE11
, FCST.ATTRIBUTE12
, FCST.ATTRIBUTE13
, FCST.ATTRIBUTE14
, FCST.ATTRIBUTE15
FROM BOM_CALENDAR_DATES DATES
, MRP_RHX_PLANNED_ITEMS_V ITEMS
, MTL_PARAMETERS P
, MRP_FORECAST_DATES FCST
, MRP_FORECAST_DESIGNATORS DESIG
WHERE ITEMS.ORGANIZATION_ID = FCST.ORGANIZATION_ID
AND ITEMS.INVENTORY_ITEM_ID = FCST.INVENTORY_ITEM_ID
AND DATES.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
AND DATES.CALENDAR_CODE = P.CALENDAR_CODE
AND DATES.SEQ_NUM IS NOT NULL
AND ((DATES.CALENDAR_DATE BETWEEN FCST.FORECAST_DATE
AND LEAST(NVL(DESIG.DISABLE_DATE
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
AND FCST.BUCKET_TYPE = 1) OR (DATES.CALENDAR_DATE BETWEEN FCST.FORECAST_DATE
AND LEAST(NVL(DESIG.DISABLE_DATE
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
AND FCST.BUCKET_TYPE = 2
AND DATES.CALENDAR_DATE IN (SELECT WEEK_START_DATE
FROM BOM_CAL_WEEK_START_DATES
WHERE CALENDAR_CODE = P.CALENDAR_CODE
AND EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
AND P.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID )) OR (DATES.CALENDAR_DATE BETWEEN FCST.FORECAST_DATE
AND LEAST(NVL(DESIG.DISABLE_DATE
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
, NVL(FCST.RATE_END_DATE
, FCST.FORECAST_DATE))
AND FCST.BUCKET_TYPE = 3
AND DATES.CALENDAR_DATE IN (SELECT PERIOD_START_DATE
FROM BOM_PERIOD_START_DATES
WHERE CALENDAR_CODE = P.CALENDAR_CODE
AND EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
AND P.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID)))
AND ITEMS.ORGANIZATION_ID = P.ORGANIZATION_ID
AND FCST.ORGANIZATION_ID = DESIG.ORGANIZATION_ID
AND FCST.FORECAST_DESIGNATOR = DESIG.FORECAST_DESIGNATOR
AND FCST.CURRENT_FORECAST_QUANTITY > 0

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
ITEM_NUMBER
FORECAST_DATE
ORIGINAL_FORECAST_QUANTITY
CURRENT_FORECAST_QUANTITY
BUCKET_TYPE
TRANSACTION_ID
CONFIDENCE_PERCENTAGE
FORECAST_DESIGNATOR
FORECAST_SET
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15