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

VIEW: APPS.EDW_MRP_FCDM_FCS_LCV

Object Details
Object Name: EDW_MRP_FCDM_FCS_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.EDW_MRP_FCDM_FCS_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 level information from the mrp_forecast_designators table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_PK VARCHAR2 (82)
Unique identifier for the Forecast
FORECAST_SET_FK VARCHAR2 (82)
Foreign key to the Forecast Set level of the Forecast dimension
CREATION_DATE DATE
Yes Standard Who column
DESCRIPTION VARCHAR2 (50)
Forecast description
DISABLE_DATE DATE

Date on which the Forecast is disabled
FORECAST_DP VARCHAR2 (45)
Unique Forecast name
FORECAST_NAME VARCHAR2 (15)
Forecast 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 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_PK
,      FORECAST_SET_FK
,      CREATION_DATE
,      DESCRIPTION
,      DISABLE_DATE
,      FORECAST_DP
,      FORECAST_NAME
,      INSTANCE_CODE
,      LAST_UPDATE_DATE
,      NAME
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_MRP_FCDM_FCS_LCV;

Dependencies

[top of page]

APPS.EDW_MRP_FCDM_FCS_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymMRP_FORECAST_DESIGNATORS
SynonymMTL_PARAMETERS

APPS.EDW_MRP_FCDM_FCS_LCV is not referenced by any database object