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

Object Details

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

WIP_BIS_PROD_INDICATORS is the summary table that contains information about productivity, utilization and yield with reference to a job, assembly, department, or resource. The Capture Production Indicators concurrent program populates this table for a given date range. The WIP Production Efficiency and Resource Utilization reports are based on this table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_BIS_PROD_INDICATORS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE SET_OF_BOOKS_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE LEGAL_ENTITY_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE OPERATING_UNIT_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE ORGANIZATION_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE DEPARTMENT_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INDICATOR_TYPE TRANSACTION_DATE DEPARTMENT_ID RESOURCE_ID CATEGORY_ID AREA_CODE
WIP_BIS_PROD_INDICATORS_N7	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	WIP_ENTITY_ID ORGANIZATION_ID OPERATION_SEQ_NUM DEPARTMENT_ID RESOURCE_ID TRANSACTION_DATE
WIP_BIS_PROD_INDICATORS_N8	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID TRANSACTION_DATE WIP_ENTITY_ID OPERATION_SEQ_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
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 operating unit
ORGANIZATION_ID	NUMBER			Organization Identifier
ORGANIZATION_NAME	VARCHAR2	(240)		Name of organization
DEPARTMENT_ID	NUMBER			Department Identifier
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
DEPARTMENT_CODE	VARCHAR2	(10)		Short code uniquely identifying the department
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
RESOURCE_ID	NUMBER			Resource Identifier
RESOURCE_CODE	VARCHAR2	(10)		Short code that uniquely identifies the resource
LOCATION_ID	NUMBER			Geographic location Identifier
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 in which the organization is located
COUNTRY_NAME	VARCHAR2	(80)		Name of the country
REGION_CODE	VARCHAR2	(30)		Short code that uniquely identifies the region in the country in which the organization is located
REGION_NAME	VARCHAR2	(80)		Name of the region
CATEGORY_ID	NUMBER			Identifier for the category that the item belongs to
CATEGORY_NAME	VARCHAR2	(163)		Name of category item belongs to
INVENTORY_ITEM_ID	NUMBER			Inventory item Identifier for the assembly the job or schedule creates
INVENTORY_ITEM_NAME	VARCHAR2	(40)		Name of assembly
PERIOD_SET_NAME	VARCHAR2	(15)		Accounting Calender
WIP_ENTITY_ID	NUMBER			Discrete Job/Flow Schedule Identifier
TRANSACTION_DATE	DATE			Transaction date
YEAR	VARCHAR2	(15)		Year in which the transaction occurs
QUARTER	VARCHAR2	(15)		Quarter in which the transaction occurs
MONTH	VARCHAR2	(15)		Month in which the transaction takes place
OPERATION_SEQ_NUM	NUMBER			Operation sequence number
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			Column used to differentiate between already 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
PROGRAM_ID	NUMBER			Enhanced Who column
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 SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      DEPARTMENT_CODE
,      PROGRAM_UPDATE_DATE
,      RESOURCE_ID
,      RESOURCE_CODE
,      LOCATION_ID
,      AREA_CODE
,      AREA_NAME
,      COUNTRY_CODE
,      COUNTRY_NAME
,      REGION_CODE
,      REGION_NAME
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      PERIOD_SET_NAME
,      WIP_ENTITY_ID
,      TRANSACTION_DATE
,      YEAR
,      QUARTER
,      MONTH
,      OPERATION_SEQ_NUM
,      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
,      PROGRAM_ID
,      INDICATOR_TYPE
,      SHARE_FROM_DEPT_ID
FROM WIP.WIP_BIS_PROD_INDICATORS;

Dependencies

[top of page]

WIP.WIP_BIS_PROD_INDICATORS does not reference any database object

WIP.WIP_BIS_PROD_INDICATORS is referenced by following:

WIP: WIP_BIS_PROD_INDICATORS#