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]

VIEW: APPS.WIP_RES_UNITS_WORKED_VIEW

Object Details

Object Name:	WIP_RES_UNITS_WORKED_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_RES_UNITS_WORKED_VIEW
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_DATE	DATE			Date transaction was performed
WIP_ENTITY_NAME	VARCHAR2	(240)	Yes	WIP job or repetitive assembly name
LINE_CODE	VARCHAR2	(10)		Line name
OPERATION_SEQ_NUM	NUMBER			Operation sequence number within a routing
DEPARTMENT_CODE	VARCHAR2	(10)	Yes	Department code
RESOURCE_CODE	VARCHAR2	(10)	Yes	Resource code
RES_UNITS_WORKED	NUMBER			Total daily resources charges expressed in the primary unit of measure
PRIMARY_UOM	VARCHAR2	(3)		Primary unit of measure for the resource

Query Text

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


SELECT TRANSACTION_DATE
,      WIP_ENTITY_NAME
,      LINE_CODE
,      OPERATION_SEQ_NUM
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      RES_UNITS_WORKED
,      PRIMARY_UOM
FROM APPS.WIP_RES_UNITS_WORKED_VIEW;

Dependencies

[top of page]

APPS.WIP_RES_UNITS_WORKED_VIEW references the following:

APPS: BOM_DEPARTMENTS; BOM_RESOURCES; WIP_ENTITIES; WIP_LINES; WIP_TRANSACTIONS

APPS.WIP_RES_UNITS_WORKED_VIEW is not referenced by any database object