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_PROD_INDICATORS_TEMP

Object Details

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

Temporary table that contains information about productivity, utilization and yield with reference to a job, assembly, department, or resource.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization Identifier.
WIP_ENTITY_ID	NUMBER			Discrete job or flow schedule Identifier.
INVENTORY_ITEM_ID	NUMBER			Inventory item Identifier for the assembly the job or schedule creates.
OPERATION_SEQ_NUM	NUMBER			Operation sequence number.
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 that uniquely identifies the resource.
TRANSACTION_DATE	DATE			Transaction date.
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_HOURS	NUMBER			Number of standard units required for a resource in the department on the transaction date.
APPLIED_HOURS_PRD	NUMBER			Number of actual units worked by the resource in the department on the transaction date from productivity perspective.
APPLIED_HOURS_UTZ	NUMBER			Number of actual units worked by the resource in the department on the transaction date from utilization perspective.
AVAILABLE_HOURS	NUMBER			Number of units available for the resource in the department on the transaction date.
EXISTING_FLAG	NUMBER			Flag to differenciate between existing data and newly generated data.
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.
SET_OF_BOOKS_ID	NUMBER			Set of books Identifier.
SET_OF_BOOKS_NAME	VARCHAR2	(30)		Name of set of books.
LEGAL_ENTITY_ID	NUMBER			Legal entity Identifier.
LEGAL_ENTITY_NAME	VARCHAR2	(240)		Name of legal entity.
OPERATING_UNIT_ID	NUMBER			Operating unit Identifier.
OPERATING_UNIT_NAME	VARCHAR2	(240)		Name of the operating unit.
ORGANIZATION_NAME	VARCHAR2	(240)		Name of the organization.
LOCATION_ID	NUMBER			Identifies the geographic location.
AREA_CODE	VARCHAR2	(30)		Short code that uniquely identifies the geographic area.
AREA_NAME	VARCHAR2	(80)		Name of geographic area.
COUNTRY_CODE	VARCHAR2	(60)		Short code that uniquely identifies the country that the organization is located in.
COUNTRY_NAME	VARCHAR2	(80)		Name of the country.
REGION_CODE	VARCHAR2	(30)		Short code that uniquely identifies the region of the country in which the organization is located.
REGION_NAME	VARCHAR2	(80)		Name of the region in which the organization is located.
CATEGORY_ID	NUMBER			Identifier for the category that the item belongs to.
CATEGORY_NAME	VARCHAR2	(163)		Name of the category for which the item belongs to.
INVENTORY_ITEM_NAME	VARCHAR2	(40)		Name of assembly.
PERIOD_SET_NAME	VARCHAR2	(15)		Accounting calendar.
YEAR	VARCHAR2	(15)		Period name for period type accounting calendar year.
QUARTER	VARCHAR2	(15)		Period name for period type accounting calendar quarter.
MONTH	VARCHAR2	(15)		Period name for period type accounting calendar month.
INDICATOR_TYPE	NUMBER			The indicator type that this record represents.
SHARE_FROM_DEPT_ID	NUMBER			The department from which the resource is shared, if any.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      WIP_ENTITY_ID
,      INVENTORY_ITEM_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      TRANSACTION_DATE
,      TOTAL_QUANTITY
,      SCRAP_QUANTITY
,      STANDARD_HOURS
,      APPLIED_HOURS_PRD
,      APPLIED_HOURS_UTZ
,      AVAILABLE_HOURS
,      EXISTING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORGANIZATION_NAME
,      LOCATION_ID
,      AREA_CODE
,      AREA_NAME
,      COUNTRY_CODE
,      COUNTRY_NAME
,      REGION_CODE
,      REGION_NAME
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_NAME
,      PERIOD_SET_NAME
,      YEAR
,      QUARTER
,      MONTH
,      INDICATOR_TYPE
,      SHARE_FROM_DEPT_ID
FROM WIP.WIP_BIS_PROD_INDICATORS_TEMP;

Dependencies

[top of page]

WIP.WIP_BIS_PROD_INDICATORS_TEMP does not reference any database object

WIP.WIP_BIS_PROD_INDICATORS_TEMP is referenced by following:

APPS: WIP_BIS_PROD_INDICATORS_TEMP