eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WIP.WIP_INDICATORS_TEMP

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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.

Query Text

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;

Dependencies

[top of page]

WIP.WIP_INDICATORS_TEMP does not reference any database object

WIP.WIP_INDICATORS_TEMP is referenced by following:

APPS: WIP_INDICATORS_TEMP