[Home] [Help] [Dependency Information]
Object Name: | WIP_INDICATORS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | WIP |
FND Design Data: | WIP.WIP_INDICATORS_TEMP |
Subobject Name: | |
Status: | VALID |
WIP_INDICATORS_TEMP is the temporary table that is used to calculate production indicators, such as productivity, utilization, and yield, from transaction information. The table is used as a transient table by the Capture Production Indicators concurrent program for a given date range.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_INDICATORS_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
INDICATOR_TYPE
PROCESS_PHASE ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID TRANSACTION_DATE |
WIP_INDICATORS_TEMP_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORGANIZATION_ID
DEPARTMENT_ID RESOURCE_ID PROCESS_PHASE TRANSACTION_DATE |
WIP_INDICATORS_TEMP_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORGANIZATION_ID
WIP_ENTITY_ID OPERATION_SEQ_NUM DEPARTMENT_ID RESOURCE_ID TRANSACTION_DATE PROCESS_PHASE INDICATOR_TYPE |
WIP_INDICATORS_TEMP_N4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
WIP_ENTITY_ID
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Yes | Identifies the set of records created for and used by a particular report instance | |
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
WIP_ENTITY_ID | NUMBER | Discrete Job/Flow Schedule Identifier | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number for the wip entity. | ||
DEPARTMENT_ID | NUMBER | Department Identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Short code uniquely identifying the department | |
RESOURCE_ID | NUMBER | Resource Identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Short code uniquely identifying the resource | |
TRANSACTION_DATE | DATE | Transaction date | ||
SHIFT_NUM | NUMBER | Shift information for Production Control Board | ||
STANDARD_QUANTITY | NUMBER | Number of distinct assemblies worked on by the department | ||
TOTAL_QUANTITY | NUMBER | Total number of distinct assemblies worked on by the department/resource combination | ||
SCRAP_QUANTITY | NUMBER | Total number of distinct assemblies scrapped by the department/resource combination | ||
STANDARD_UNITS | NUMBER | Number of standard units required for a resource in the department on the transaction date | ||
APPLIED_UNITS_PRD | NUMBER | Number of actual units worked by the resource in the department on the transaction date from productivity perspective | ||
APPLIED_UNITS_UTZ | NUMBER | Number of actual units worked by the resource in the department on the transaction date from utilization perspective | ||
AVAILABLE_UNITS | NUMBER | Number of units available for the resource in the department on the transaction date | ||
RESOURCE_COST | NUMBER | Hourly rate of the resource | ||
RESOURCE_BASIS | NUMBER | Temporary column for calculating the Lot based resource charges for productivity | ||
INDICATOR_TYPE | NUMBER | Indicator column that holds information about the type of indicator that is being calculated: 1 - Productivity, 2 - Utilization, and 3 - Yield | ||
PROCESS_PHASE | NUMBER | Temporary column that is used for internal calculations of productivity, utilization and yield | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Enhanced Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who column | ||
PROGRAM_ID | NUMBER | Enhanced Who column | ||
PROGRAM_UPDATE_DATE | DATE | Enhanced Who column | ||
LINE_ID | NUMBER | WIP line Identifier | ||
AVAILABLE_QUANTITY | NUMBER | Available production rate for the line | ||
REQUIRED_QUANTITY | NUMBER | Required Production rate for the line | ||
REQUIRED_HOURS | NUMBER | Number of units required for the resource in the department on the transaction date | ||
SHARE_FROM_DEPT_ID | NUMBER | Department from which the resource is shared, if any. |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, ORGANIZATION_ID
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, DEPARTMENT_ID
, DEPARTMENT_CODE
, RESOURCE_ID
, RESOURCE_CODE
, TRANSACTION_DATE
, SHIFT_NUM
, STANDARD_QUANTITY
, TOTAL_QUANTITY
, SCRAP_QUANTITY
, STANDARD_UNITS
, APPLIED_UNITS_PRD
, APPLIED_UNITS_UTZ
, AVAILABLE_UNITS
, RESOURCE_COST
, RESOURCE_BASIS
, INDICATOR_TYPE
, PROCESS_PHASE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LINE_ID
, AVAILABLE_QUANTITY
, REQUIRED_QUANTITY
, REQUIRED_HOURS
, SHARE_FROM_DEPT_ID
FROM WIP.WIP_INDICATORS_TEMP;
WIP.WIP_INDICATORS_TEMP does not reference any database object
WIP.WIP_INDICATORS_TEMP is referenced by following:
|
|
|