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]

TABLE: ISC.EDW_MRP_FORECAST_M

Object Details

Object Name:	EDW_MRP_FORECAST_M
Object Type:	TABLE
Owner:	ISC
FND Design Data:	BIS.EDW_MRP_FORECAST_M ISC.EDW_MRP_FORECAST_M
Subobject Name:
Status:	VALID

This is the denormalized star table for the Forecast dimension. It contains records for the lowest level of the Forecast dimension and their parentage up to the top level, across all hierarchies.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_MRP_FORECAST_M_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	FCST_FORECAST_PK FCST_FORECAST_PK_KEY
EDW_MRP_FORECAST_M_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	FCST_FORECAST_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
FCST_FORECAST_PK	VARCHAR2	(40)		Unique identifier
FCST_FORECAST_PK_KEY	NUMBER		Yes	System generated Forecast unique identifier
FSTS_FORECAST_SET_PK	VARCHAR2	(40)		Unique identifier for the Forecast Set
FSTS_FORECAST_SET_PK_KEY	NUMBER		Yes	System generated unique identifier for the Forecast Set
CREATION_DATE	DATE		Yes	Standard Who column
FCST_DESCRIPTION	VARCHAR2	(240)		Forecast description
FCST_DISABLE_DATE	DATE			Date on which that Forecast was disabled
FCST_FORECAST_DP	VARCHAR2	(240)		Unique Forecast name
FCST_FORECAST_NAME	VARCHAR2	(80)		Forecast name
FCST_INSTANCE_CODE	VARCHAR2	(40)		Instance code refering to the source application for the Forecast
FCST_NAME	VARCHAR2	(80)		Alternate Forecast name
FCST_USER_ATTRIBUTE1	VARCHAR2	(240)		User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE2	VARCHAR2	(240)		User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE3	VARCHAR2	(240)		User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE4	VARCHAR2	(240)		User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE5	VARCHAR2	(240)		User defined attribute (Forecast level)
FSTS_CONSUMPTION_LEVEL	VARCHAR2	(80)		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 Ship-to level, etc.
FSTS_DESCRIPTION	VARCHAR2	(240)		Forecast Set description
FSTS_DISABLE_DATE	DATE			Date on which that Forecast Set was disabled
FSTS_FORECAST_SET_DP	VARCHAR2	(240)		Unique Forecast Set name
FSTS_FORECAST_SET_NAME	VARCHAR2	(80)		Forecast Set name
FSTS_INSTANCE_CODE	VARCHAR2	(40)		Instance code refering to the source application for the Forecast Set
FSTS_NAME	VARCHAR2	(80)		Alternate Forecast Set name
FSTS_USER_ATTRIBUTE1	VARCHAR2	(240)		User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE2	VARCHAR2	(240)		User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE3	VARCHAR2	(240)		User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE4	VARCHAR2	(240)		User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE5	VARCHAR2	(240)		User defined attribute (Forecast Set level)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT FCST_FORECAST_PK
,      FCST_FORECAST_PK_KEY
,      FSTS_FORECAST_SET_PK
,      FSTS_FORECAST_SET_PK_KEY
,      CREATION_DATE
,      FCST_DESCRIPTION
,      FCST_DISABLE_DATE
,      FCST_FORECAST_DP
,      FCST_FORECAST_NAME
,      FCST_INSTANCE_CODE
,      FCST_NAME
,      FCST_USER_ATTRIBUTE1
,      FCST_USER_ATTRIBUTE2
,      FCST_USER_ATTRIBUTE3
,      FCST_USER_ATTRIBUTE4
,      FCST_USER_ATTRIBUTE5
,      FSTS_CONSUMPTION_LEVEL
,      FSTS_DESCRIPTION
,      FSTS_DISABLE_DATE
,      FSTS_FORECAST_SET_DP
,      FSTS_FORECAST_SET_NAME
,      FSTS_INSTANCE_CODE
,      FSTS_NAME
,      FSTS_USER_ATTRIBUTE1
,      FSTS_USER_ATTRIBUTE2
,      FSTS_USER_ATTRIBUTE3
,      FSTS_USER_ATTRIBUTE4
,      FSTS_USER_ATTRIBUTE5
,      LAST_UPDATE_DATE
FROM ISC.EDW_MRP_FORECAST_M;

Dependencies

[top of page]

ISC.EDW_MRP_FORECAST_M does not reference any database object

ISC.EDW_MRP_FORECAST_M is referenced by following:

APPS: EDW_MRP_FORECAST_M