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.WIPFV_WIP_OPERATIONS

Object Details

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

View Type

A Business Intelligence System view

This shows information about the operations and intraoperation steps required to complete discrete jobs and repetitive schedules. Operations represent the manufacturing steps at which you perform work to add value to assemblies, while at the same time consuming department resources.

[View Source]

Columns

Name	Datatype	Length	Mandatory
OPERATION_SEQUENCE_NUMBER	NUMBER		Yes
OPERATION_DESCRIPTION	VARCHAR2	(240)
QUEUE_QUANTITY	NUMBER		Yes
RUN_QUANTITY	NUMBER		Yes
WAITING_TO_MOVE_QUANTITY	NUMBER		Yes
REJECTED_QUANTITY	NUMBER		Yes
SCRAPPED_QUANTITY	NUMBER		Yes
COMPLETED_QUANTITY	NUMBER		Yes
FIRST_UNIT_START_DATE	DATE		Yes
FIRST_UNIT_COMPLETION_DATE	DATE		Yes
LAST_UNIT_START_DATE	DATE		Yes
LAST_UNIT_COMPLETION_DATE	DATE		Yes
_LA:COUNT_POINT_TYPE	CHAR	(64)
_LA:BACKFLUSH_FLAG	CHAR	(52)
MINIMUM_TRANSFER_QUANTITY	NUMBER		Yes
LAST_MOVED_DATE	DATE
MFG_ORDER_NAME	VARCHAR2	(240)	Yes
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
OPERATION	VARCHAR2	(4)
DEPARTMENT	VARCHAR2	(10)	Yes
_DF	CHAR	(21)
WIP_ENTITY_ID	NUMBER		Yes
REPETITIVE_SCHEDULE_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
OPERATION_SEQUENCE_ID	NUMBER
STANDARD_OPERATION_ID	NUMBER
DEPARTMENT_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes

Query Text

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


SELECT OPERATION_SEQUENCE_NUMBER
,      OPERATION_DESCRIPTION
,      QUEUE_QUANTITY
,      RUN_QUANTITY
,      WAITING_TO_MOVE_QUANTITY
,      REJECTED_QUANTITY
,      SCRAPPED_QUANTITY
,      COMPLETED_QUANTITY
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      _LA:COUNT_POINT_TYPE
,      _LA:BACKFLUSH_FLAG
,      MINIMUM_TRANSFER_QUANTITY
,      LAST_MOVED_DATE
,      MFG_ORDER_NAME
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      OPERATION
,      DEPARTMENT
,      _DF
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ORGANIZATION_ID
,      OPERATION_SEQUENCE_ID
,      STANDARD_OPERATION_ID
,      DEPARTMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.WIPFV_WIP_OPERATIONS;

Dependencies

[top of page]

APPS.WIPFV_WIP_OPERATIONS references the following:

APPS: BOM_DEPARTMENTS; BOM_OPERATION_SEQUENCES; BOM_STANDARD_OPERATIONS; HR_ALL_ORGANIZATION_UNITS; MTL_PARAMETERS; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_OPERATIONS; WIP_REPETITIVE_SCHEDULES

APPS.WIPFV_WIP_OPERATIONS is not referenced by any database object