[Home] [Help] [Dependency Information]

TABLE: MRP.MRP_FORECAST_DATES

Object Details

Object Name:	MRP_FORECAST_DATES
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_FORECAST_DATES
Subobject Name:
Status:	VALID

MRP_FORECAST_DATES stores the forecast entries for items in a
forecast. Each row represents a forecasted quantity or forecasted
rate for an item on a given date.
.
The CURRENT_FORECAST_QUANTITY stores the current quantity of the
forecast, including forecast consumptions. The
ORIGINAL_FORECAST_QUANTITY stores the quantity of the forecast before
any consumption has taken place. The difference between the
CURRENT_FORECAST_QUANTITY and ORIGINAL_FORECAST_QUANTITY columns
should be equal to the sum of the corresponding entries in
MRP_FORECAST_UPDATES.
.
A forecast entry may represent a forecast for a day, week or period,
depending on the value of BUCKET_TYPE. The value of FORECAST_DATE
must be a valid workday, week start date or period start date if the
value of BUCKET_TYPE is Daily, Weekly, or Periodic, respectively. A
forecast entry may be a single bucket entry or a multiple bucket
entry. If RATE_END_DATE is NULL, then the entry is considered a
single bucket entry, and represents a forecast for the specific date
represented in FORECAST_DATE. An entry with a RATE_END_DATE
represents a forecast for the forecast quantity for each day, week or
period between the FORECAST_DATE and the RATE_END_DATE. Like
FORECAST_DATE, the value of RATE_END_DATE must be a valid workday,
week start date or period start date if the value of BUCKET_TYPE is
Daily, Weekly, or Periodic, respectively.
.
Each forecast entry may be forecasted to varying degrees of
granularity: by item (INVENTORY_ITEM_ID), by customer (CUSTOMER_ID),
by customer bill to (BILL_ID) and customer ship to addresses
(SHIP_ID). These different degrees of granularity affect how the
forecast is consumed. Likewise, you may divide your forecast by
demand class.
.
Normally, demand class information and information regarding customer
or customer billing/shipping addresses is carried at the forecast
designator level, and stored in MRP_FORECAST_DESIGNATORS. However,
each over-consumption record that is created includes that information
as well.
.
END_ITEM_ID stores the end item from which the forecast was exploded.
END_PLANNING_BOM_PERCENT is the end usage from that exploded end item.
.
This table is populated by the Enter Forecast Entries form, by a
forecast autoload, from a forecast import, or from Inventory
forecasting methods (Focus forecasting & Statistical Forecasting).
ORIGINATION_TYPE indicates how the entry was created. If the entries
were derived from a forecast autoload, the column
SOURCE_FORECAST_DESIGNATOR and SOURCE_ORGANIZATION_ID will hold the
source forecast and source organization that generated the entry. If
the entries were created from an import from an outside system,
SOURCE_CODE and SOURCE_LINE_ID may optionally be populated to provide
information on how and where the entries were generated from. If the
entries were created from Inventory forecasting, the columns
FORECAST_TREND, FOCUS_TYPE and FORECAST_MAD may be populated.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_FORECAST_DATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MRP_FORECAST_DATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID FORECAST_DESIGNATOR INVENTORY_ITEM_ID FORECAST_DATE
MRP_FORECAST_DATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_TRANSACTION_ID
MRP_FORECAST_DATES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
MRP_FORECAST_DATES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGINATION_TYPE

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      FORECAST_DESIGNATOR
,      FORECAST_DATE
,      ORIGINAL_FORECAST_QUANTITY
,      CURRENT_FORECAST_QUANTITY
,      CONFIDENCE_PERCENTAGE
,      BUCKET_TYPE
,      RATE_END_DATE
,      ORIGINATION_TYPE
,      CUSTOMER_ID
,      SHIP_ID
,      BILL_ID
,      COMMENTS
,      SOURCE_ORGANIZATION_ID
,      SOURCE_FORECAST_DESIGNATOR
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      END_ITEM_ID
,      END_PLANNING_BOM_PERCENT
,      FORECAST_RULE_ID
,      DEMAND_USAGE_START_DATE
,      FORECAST_TREND
,      FOCUS_TYPE
,      FORECAST_MAD
,      DEMAND_CLASS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OLD_TRANSACTION_ID
,      TO_UPDATE
,      DDF_CONTEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROJECT_ID
,      TASK_ID
,      LINE_ID
FROM MRP.MRP_FORECAST_DATES;

Dependencies

[top of page]

MRP.MRP_FORECAST_DATES does not reference any database object

MRP.MRP_FORECAST_DATES is referenced by following:

MRP

MRP_FORECAST_DATES#