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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MSD_MFG_FCST_V

Object Details

Object Name:	MSD_MFG_FCST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_MFG_FCST_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view specifies the Manufacturing Forecast. This is not stripped by the demand plan id.

It has a forecast designator that could be used along with the demand plan parameter's name
to strip this information by the demand plan. 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_QUANTITY stores the current quantity of the forecast, including forecast consumptions. The ORIGINAL_QUANTITY stores the quantity of the forecast before any consumption has taken place.
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 day, 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. When both the FORECAST_DATE and the RATE_END_DATE are populated, it will for all the days between these two days (inclusive of both the dates). Thus it represents only the contiguous chunks of dates.
Each forecast entry may be forecasted to varying degrees of granularity: by item INVENTORY_ITEM_ID), by customer (CUSTOMER_ID), customer ship to addresses(SHIP_ID).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_DESIGNATOR	VARCHAR2	(320)	Yes	Forecast designator that could be used along with the demand plan parameter's name to strip mfg forecast information by the demand plan. This information is not stripped by the demand plan ID.
INV_ORG	VARCHAR2	(240)	Yes	Inventory organization.
INV_ORG_PK	NUMBER		Yes	Primary key for the inventory organization.
ITEM	VARCHAR2	(240)	Yes	Item
ITEM_PK	NUMBER		Yes	Primary key for the item.
CUSTOMER	VARCHAR2	(240)		Customer
CUSTOMER_PK	NUMBER			Primary key for the customer.
SALES_CHANNEL	VARCHAR2	(240)		Sales channel.
SALES_CHANNEL_PK	NUMBER			Primary key for the sales channel.
SHIP_TO_LOC	VARCHAR2	(240)		Ship to location.
SHIP_TO_LOC_PK	NUMBER			Primary key for the Ship to location.
USER_DEFINED1	VARCHAR2	(320)		First User Defined Dimension Value.
USER_DEFINED1_PK	VARCHAR2	(0)		Primary key for the first User Defined Dimension.
USER_DEFINED2	VARCHAR2	(320)		Second User Defined Dimension Value.
USER_DEFINED2_PK	VARCHAR2	(0)		Primary key for the second User Defined Dimension.
BUCKET_TYPE	VARCHAR2	(30)	Yes	The forecast bucket type to specify the time period (days, weeks, periods) that a manufacturing forecast entry covers. The value could be daily, weekly, or periodic, based on which a forecast entry is represented.
FORECAST_DATE	DATE		Yes	Start date of the time period that a forecast entry covers. The value must be a valid day, week start date, or period start date depending on the value of bucket type.
RATE_END_DATE	DATE			End date of the time period that a forecast entry covers. NULL value represents a single bucket entry. For multiple bucket entry, the value must be a valid day, week start date, or period start date depending on the value of bucket type.
ORIGINAL_QUANTITY	NUMBER		Yes	Expected (forecast) quantity due to customer orders.
CURRENT_QUANTITY	NUMBER		Yes	Expected quantity net of customer orders that have been already received. ( Original quantiry - customer orders)

Query Text

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


SELECT FORECAST_DESIGNATOR
,      INV_ORG
,      INV_ORG_PK
,      ITEM
,      ITEM_PK
,      CUSTOMER
,      CUSTOMER_PK
,      SALES_CHANNEL
,      SALES_CHANNEL_PK
,      SHIP_TO_LOC
,      SHIP_TO_LOC_PK
,      USER_DEFINED1
,      USER_DEFINED1_PK
,      USER_DEFINED2
,      USER_DEFINED2_PK
,      BUCKET_TYPE
,      FORECAST_DATE
,      RATE_END_DATE
,      ORIGINAL_QUANTITY
,      CURRENT_QUANTITY
FROM APPS.MSD_MFG_FCST_V;

Dependencies

[top of page]

APPS.MSD_MFG_FCST_V references the following:

APPS: MSD_LEVEL_VALUES; MSD_MFG_FORECAST

APPS.MSD_MFG_FCST_V is not referenced by any database object