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_DS_V

Object Details

Object Name:	MSD_MFG_FCST_DS_V
Object Type:	VIEW
Owner:	APPS
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 striped by the demand plan id. It has a forecast designator that could be used along with the demand plan parameter's nameto 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
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Id
FORECAST_DESIGNATOR	VARCHAR2	(320)	Yes	Forecast name.
PRD_LEVEL_ID	NUMBER	(15)		Product Level ID.
PRD_LEVEL_VALUE_PK	NUMBER		Yes	Product Level Value Primary Key.
GEO_LEVEL_ID	NUMBER			Geography Level ID.
GEO_LEVEL_VALUE_PK	NUMBER			Geography Level Value Primary Key.
ORG_LEVEL_ID	NUMBER			Organization Level ID.
ORG_LEVEL_VALUE_PK	NUMBER		Yes	Organization Level Value Primary Key.
CHN_LEVEL_ID	NUMBER			Sales Channel Level ID.
CHN_LEVEL_VALUE_PK	NUMBER		Yes	Sales Channel Level Value Primary Key.
UD1_LEVEL_ID	VARCHAR2	(0)		User Dimension 1 Level ID.
UD1_LEVEL_VALUE_PK	VARCHAR2	(0)		User Dimension 1 Level Value Primary Key.
UD2_LEVEL_ID	VARCHAR2	(0)		User Dimension 2 Level ID.
UD2_LEVEL_VALUE_PK	VARCHAR2	(0)		User Dimension 2 Level Value Primary Key.
TIME_LEVEL_ID	VARCHAR2	(30)	Yes	Time Level ID.
END_DATE	DATE		Yes	Forecast Date.
ORIGINAL_QUANTITY	NUMBER		Yes	Original Quantity
CURRENT_QUANTITY	NUMBER		Yes	Current Quantity.
CREATION_DATE	DATE		Yes	Who columns
CREATED_BY	NUMBER		Yes	Who columns
LAST_UPDATE_DATE	DATE		Yes	Who columns
LAST_UPDATED_BY	NUMBER		Yes	Who columns
LAST_UPDATE_LOGIN	NUMBER		Yes	Who columns
LAST_REFRESH_NUM	NUMBER			last refresh number
CREATED_BY_REFRESH_NUM	NUMBER			created by refresh number
ACTION_CODE	VARCHAR2	(30)		DML action code
PRD_PARENT_LEVEL_ID	NUMBER			Product Parent Level Id
PRD_PARENT_LEVEL_VALUE_PK	NUMBER			Product Parent Level value Pk
DCS_LEVEL_ID	NUMBER			Demand Class Level ID
DCS_LEVEL_VALUE_PK	NUMBER			Demand Class Level Value PK

Query Text

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


SELECT DEMAND_PLAN_ID
,      FORECAST_DESIGNATOR
,      PRD_LEVEL_ID
,      PRD_LEVEL_VALUE_PK
,      GEO_LEVEL_ID
,      GEO_LEVEL_VALUE_PK
,      ORG_LEVEL_ID
,      ORG_LEVEL_VALUE_PK
,      CHN_LEVEL_ID
,      CHN_LEVEL_VALUE_PK
,      UD1_LEVEL_ID
,      UD1_LEVEL_VALUE_PK
,      UD2_LEVEL_ID
,      UD2_LEVEL_VALUE_PK
,      TIME_LEVEL_ID
,      END_DATE
,      ORIGINAL_QUANTITY
,      CURRENT_QUANTITY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      PRD_PARENT_LEVEL_ID
,      PRD_PARENT_LEVEL_VALUE_PK
,      DCS_LEVEL_ID
,      DCS_LEVEL_VALUE_PK
FROM APPS.MSD_MFG_FCST_DS_V;

Dependencies

[top of page]

APPS.MSD_MFG_FCST_DS_V references the following:

APPS: MSD_DP_SESSION; MSD_LEVEL_VALUES_DS; MSD_MFG_FORECAST

APPS.MSD_MFG_FCST_DS_V is not referenced by any database object