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_BIS_EFF_TEMP

Object Details

Object Name:	WIP_BIS_EFF_TEMP
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_BIS_EFF_TEMP
Subobject Name:
Status:	VALID

Temporary table that holds data from wip_indicators_temp for efficiency for faster data manipulation based on indicator (group_id = 1).

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_BIS_EFF_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID WIP_ENTITY_ID DEPARTMENT_ID RESOURCE_ID TRANSACTION_DATE OPERATION_SEQ_NUM

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 the 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			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			Standard Who column.
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column.
PROGRAM_ID	NUMBER			Standard Who column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
LINE_ID	NUMBER			WIP line Identifier.
AVAILABLE_QUANTITY	NUMBER			Available production quantity for the line.
REQUIRED_QUANTITY	NUMBER			Required Production quantity 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_BIS_EFF_TEMP;

Dependencies

[top of page]

WIP.WIP_BIS_EFF_TEMP does not reference any database object

WIP.WIP_BIS_EFF_TEMP is referenced by following:

WIP: WIP_BIS_EFF_TEMP#