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

VIEW: APPS.EDW_FORECAST_FKV

Object Details
Object Name: EDW_FORECAST_FKV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.EDW_FORECAST_FKV
Subobject Name:
Status: VALID

View Type

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


This view builds and returns foreign keys to the Forecast dimension. Forecast foreign keys are based on forecast designators values found in the mrp_forecast_designators table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_FK VARCHAR2 (82)
Forecast foreign key
FORECAST_DESIGNATOR VARCHAR2 (10) Yes Forecast designator
ORGANIZATION_ID NUMBER
Yes Organization Id
Query Text

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


SELECT FORECAST_FK
,      FORECAST_DESIGNATOR
,      ORGANIZATION_ID
FROM APPS.EDW_FORECAST_FKV;

Dependencies

[top of page]

APPS.EDW_FORECAST_FKV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymMRP_FORECAST_DESIGNATORS
SynonymMTL_PARAMETERS

APPS.EDW_FORECAST_FKV is not referenced by any database object