[Home] [Help] [Dependency Information]
Object Name: | WIP_EAM_PERIOD_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | WIP |
FND Design Data: | WIP.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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_EAM_PERIOD_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
WIP_ENTITY_ID PERIOD_SET_NAME PERIOD_NAME ACCT_PERIOD_ID MAINT_COST_CATEGORY OPERATION_SEQ_NUM OPERATIONS_DEPT_ID OWNING_DEPT_ID |
WIP_EAM_PERIOD_BALANCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
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 |
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;
WIP.WIP_EAM_PERIOD_BALANCES does not reference any database object
WIP.WIP_EAM_PERIOD_BALANCES is referenced by following:
|
|
|