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

TABLE: EAM.EAM_FORECAST_CEBBA

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


This table stores all of the costs associated with a forecasted work order for eAM maintenance budgeting and forecasting. Costs are striped by work order, operation, account, and the period forwhich the cost was incurred. This mirrors the structure of cst_eam_balance_by_accounts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_FORECAST_CEBBA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_ID
ColumnWIP_ENTITY_ID
ColumnPERIOD_NAME
ColumnCCID
EAM_FORECAST_CEBBA_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_ID
ColumnCCID
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Yes Period Set Name
PERIOD_NAME VARCHAR2 (15) Yes Period Name
ACCT_PERIOD_ID NUMBER

Account Period Id
WIP_ENTITY_ID NUMBER
Yes Wip Entity Id
ORGANIZATION_ID NUMBER
Yes Organization id
OPERATIONS_DEPT_ID NUMBER

Operations Department Id
OPERATION_SEQ_NUM NUMBER

Operations Department Id
MAINT_COST_CATEGORY NUMBER

Maintenance cost category
OWNING_DEPT_ID NUMBER
Yes Owning department id
ACCT_VALUE NUMBER

Amount charged to the account
PERIOD_START_DATE DATE
Yes Period start date
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
FORECAST_ID NUMBER
Yes Forecast Id
CCID NUMBER
Yes WAC acct id
MFG_COST_ELEMENT_ID NUMBER

Mfg Cost Element Id
PERIOD_YEAR NUMBER (15) Yes Year of the Period Costed
PERIOD_NUM NUMBER (15) Yes Period Index of the Forecast
TXN_TYPE NUMBER

Material, Labor or Equipment
Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_NAME
,      ACCT_PERIOD_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATIONS_DEPT_ID
,      OPERATION_SEQ_NUM
,      MAINT_COST_CATEGORY
,      OWNING_DEPT_ID
,      ACCT_VALUE
,      PERIOD_START_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FORECAST_ID
,      CCID
,      MFG_COST_ELEMENT_ID
,      PERIOD_YEAR
,      PERIOD_NUM
,      TXN_TYPE
FROM EAM.EAM_FORECAST_CEBBA;

Dependencies

[top of page]

EAM.EAM_FORECAST_CEBBA does not reference any database object

EAM.EAM_FORECAST_CEBBA is referenced by following:

SchemaAPPS
SynonymEAM_FORECAST_CEBBA