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.EDW_MRP_FCDM_SET_LCV

Object Details

Object Name:	EDW_MRP_FCDM_SET_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.EDW_MRP_FCDM_SET_LCV
Subobject Name:
Status:	VALID

View Type

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

This view is used by the Forecast collection program to retrieve Forecast Set level information from the mrp_forecast_designators table.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_SET_PK	VARCHAR2	(82)		Unique identifier
CONSUMPTION_LEVEL	VARCHAR2	(80)	Yes	Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Shipto level, etc.
CREATION_DATE	DATE		Yes	Standard Who column
DESCRIPTION	VARCHAR2	(50)		Forecast Set description
DISABLE_DATE	DATE			Date on which the Forecast Set is disabled
FORECAST_SET_DP	VARCHAR2	(45)		Unique Forecast Set name
FORECAST_SET_NAME	VARCHAR2	(15)		Forecast Set name
INSTANCE_CODE	VARCHAR2	(30)		Instance code refering to the source application
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
NAME	VARCHAR2	(15)		Alternate Forecast Set name
USER_ATTRIBUTE1	VARCHAR2	(0)		User Attribute
USER_ATTRIBUTE2	VARCHAR2	(0)		User Attribute
USER_ATTRIBUTE3	VARCHAR2	(0)		User Attribute
USER_ATTRIBUTE4	VARCHAR2	(0)		User Attribute
USER_ATTRIBUTE5	VARCHAR2	(0)		User Attribute

Query Text

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


SELECT FORECAST_SET_PK
,      CONSUMPTION_LEVEL
,      CREATION_DATE
,      DESCRIPTION
,      DISABLE_DATE
,      FORECAST_SET_DP
,      FORECAST_SET_NAME
,      INSTANCE_CODE
,      LAST_UPDATE_DATE
,      NAME
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_MRP_FCDM_SET_LCV;

Dependencies

[top of page]

APPS.EDW_MRP_FCDM_SET_LCV references the following:

APPS: EDW_LOCAL_INSTANCE; MFG_LOOKUPS; MRP_FORECAST_DESIGNATORS; MTL_PARAMETERS

APPS.EDW_MRP_FCDM_SET_LCV is not referenced by any database object