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

TABLE: EAM.EAM_FORECASTS

Object Details
Object Name: EAM_FORECASTS
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_FORECASTS
Subobject Name:
Status: VALID


This table stores the criteria for forecasts and templates used in EAM maintenance budgeting and forecasting. Forecasts are created as a set of criteria used to extract historical work orders or predict future work orders that match that criteria.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FORECAST_ID NUMBER
Yes Unique identifier of the forecast
ORGANIZATION_ID NUMBER
Yes Organization that created this forecast
TEMPLATE_FLAG VARCHAR2 (1)
Flag indicating a forecast template
REQUEST_ID NUMBER

The concurrent request id created when the forecast is generated
FORECAST_NAME VARCHAR2 (50) Yes Forecast name
DESCRIPTION VARCHAR2 (240) Yes Forecast description
PERIOD_FROM VARCHAR2 (15) Yes The lower bound of the time frame, by accounting period, the forecast is applied to.
PERIOD_TO VARCHAR2 (15) Yes The upper bound of the time frame, by accounting period, the forecast is applied to.
PERIOD_SET_NAME_FROM VARCHAR2 (15) Yes Period set name for GL_PERIODS for "Period From"
FORECAST_TYPE NUMBER (1) Yes Forecast type. 1 indicates historical planned work. 2 indicates historical non-planned work. 3 indicates all historical work. 4 indicates forecasted work.
ACCOUNT_FROM VARCHAR2 (50)
GL account to consider. Lower bound alphabetically.
ACCOUNT_TO VARCHAR2 (50)
GL account to consider. Upper bound alphabetically.
WIP_ACCT_CLASS_FROM VARCHAR2 (50)
WIP accounting class to consider. Lower bound alphabetically.
WIP_ACCT_CLASS_TO VARCHAR2 (50)
WIP accounting class to consider. Upper bound alphabetically.
ACTIVITY_FROM VARCHAR2 (50)
Activity to consider. Lower bound alphabetically
ACTIVITY_TO VARCHAR2 (50)
Activity to consider. Upper bound alphabetically
DEPARTMENT_FROM VARCHAR2 (50)
Owning department to consider. Lower bound alphabetically.
DEPARTMENT_TO VARCHAR2 (50)
Owning department to consider. Upper bound alphabetically
PROJECT_FROM VARCHAR2 (50)
Project to consider. Lower bound alphabetically
PROJECT_TO VARCHAR2 (50)
Project to consider. Upper bound alphabetically
ASSET_NUM_FROM VARCHAR2 (50)
Asset number to consider. Lower bound alphabetically
ASSET_NUM_TO VARCHAR2 (50)
Asset number to consider. upper bound alphabetically
ASSET_SERIAL_NUM_FROM VARCHAR2 (50)
Asset serial number to consider. Lower bound alphabetically
ASSET_SERIAL_NUM_TO VARCHAR2 (50)
Asset serial number to consider. Upper bound alphabetically
ASSET_GROUP_FROM VARCHAR2 (50)
Asset group to consider. Lower bound alphabetically
ASSET_GROUP_TO VARCHAR2 (50)
Asset group to consider. Upper bound alphabetically
WORK_ORDER_FROM VARCHAR2 (50)
Work order to consider. Lower bound alphabetically
WORK_ORDER_TO VARCHAR2 (50)
Work order to consider. Upper bound alphabetically
WORK_ORDER_TYPE_FROM VARCHAR2 (50)
Work order type to consider. Lower bound alphabetically
WORK_ORDER_TYPE_TO VARCHAR2 (50)
Work order type to consider. Upper bound alphabetically
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
AREA_FROM VARCHAR2 (30)
Asset area
AREA_TO VARCHAR2 (30)
Asset area
SOURCE_TEMPLATE_ID NUMBER

Parent template if this forecast was generated from a template
PERIOD_SET_NAME_TO VARCHAR2 (15) Yes Period set name for the "Period To"
INCLUDE_TRANSACTED VARCHAR2 (1) Yes Flag indicating a forecast should include work orders from other orgs for which the current organization is now responsible.
COMPLETION_DATE DATE

Date forecast was last generated
Query Text

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


SELECT FORECAST_ID
,      ORGANIZATION_ID
,      TEMPLATE_FLAG
,      REQUEST_ID
,      FORECAST_NAME
,      DESCRIPTION
,      PERIOD_FROM
,      PERIOD_TO
,      PERIOD_SET_NAME_FROM
,      FORECAST_TYPE
,      ACCOUNT_FROM
,      ACCOUNT_TO
,      WIP_ACCT_CLASS_FROM
,      WIP_ACCT_CLASS_TO
,      ACTIVITY_FROM
,      ACTIVITY_TO
,      DEPARTMENT_FROM
,      DEPARTMENT_TO
,      PROJECT_FROM
,      PROJECT_TO
,      ASSET_NUM_FROM
,      ASSET_NUM_TO
,      ASSET_SERIAL_NUM_FROM
,      ASSET_SERIAL_NUM_TO
,      ASSET_GROUP_FROM
,      ASSET_GROUP_TO
,      WORK_ORDER_FROM
,      WORK_ORDER_TO
,      WORK_ORDER_TYPE_FROM
,      WORK_ORDER_TYPE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AREA_FROM
,      AREA_TO
,      SOURCE_TEMPLATE_ID
,      PERIOD_SET_NAME_TO
,      INCLUDE_TRANSACTED
,      COMPLETION_DATE
FROM EAM.EAM_FORECASTS;

Dependencies

[top of page]

EAM.EAM_FORECASTS does not reference any database object

EAM.EAM_FORECASTS is referenced by following:

SchemaEAM
ViewEAM_FORECASTS#