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


TABLE: WIP.WIP_EAM_PERIOD_BALANCES

Object Details
Object Name: WIP_EAM_PERIOD_BALANCES
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_EAM_PERIOD_BALANCES
Subobject Name:
Status: VALID


This table stores summary accounting information for EAM jobs. Each row represents job charges within a given accounting period, and contains the summary values for each cost element. Oracle Work in Process uses this information to report job and schedule values and to calculate job and period variances


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_EAM_PERIOD_BALANCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnWIP_ENTITY_ID
ColumnPERIOD_SET_NAME
ColumnPERIOD_NAME
ColumnACCT_PERIOD_ID
ColumnMAINT_COST_CATEGORY
ColumnOPERATION_SEQ_NUM
ColumnOPERATIONS_DEPT_ID
ColumnOWNING_DEPT_ID
WIP_EAM_PERIOD_BALANCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
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

Accounting Period Identifier
WIP_ENTITY_ID NUMBER
Yes WIP Job Identifier
ORGANIZATION_ID NUMBER
Yes Manufacturing Organization Identifier
OPERATIONS_DEPT_ID NUMBER

Operations Department Identifier
OPERATION_SEQ_NUM NUMBER

Operations Sequence Number
MAINT_COST_CATEGORY NUMBER
Yes Maintenance Cost Category
OWNING_DEPT_ID NUMBER
Yes Owning Department Identifier
ACTUAL_MAT_COST NUMBER

Actual Material Cost
ACTUAL_LAB_COST NUMBER

Actual Labor Cost
ACTUAL_EQP_COST NUMBER

Actual Equipment Cost
SYSTEM_ESTIMATED_MAT_COST NUMBER

System Estimated Material Cost
SYSTEM_ESTIMATED_LAB_COST NUMBER

System Estimated Labor Cost
SYSTEM_ESTIMATED_EQP_COST NUMBER

System Estimated Equipment Cost
MANUAL_ESTIMATED_MAT_COST NUMBER

Manual Estimated Material Cost
MANUAL_ESTIMATED_LAB_COST NUMBER

Manual Estimated Labor Cost
MANUAL_ESTIMATED_EQP_COST NUMBER

Manual Estimated Equipment Cost
PERIOD_START_DATE DATE
Yes Period Start Date for calculated costs
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
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
,      ACTUAL_MAT_COST
,      ACTUAL_LAB_COST
,      ACTUAL_EQP_COST
,      SYSTEM_ESTIMATED_MAT_COST
,      SYSTEM_ESTIMATED_LAB_COST
,      SYSTEM_ESTIMATED_EQP_COST
,      MANUAL_ESTIMATED_MAT_COST
,      MANUAL_ESTIMATED_LAB_COST
,      MANUAL_ESTIMATED_EQP_COST
,      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
FROM WIP.WIP_EAM_PERIOD_BALANCES;

Dependencies

[top of page]

WIP.WIP_EAM_PERIOD_BALANCES does not reference any database object

WIP.WIP_EAM_PERIOD_BALANCES is referenced by following:

SchemaAPPS
SynonymWIP_EAM_PERIOD_BALANCES