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

Object Details

Object Name:	EAM_WORK_ORDER_DETAILS_V
Object Type:	VIEW
Owner:	APPS
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
ROW_ID	ROWID	(10)		Row Id
WIP_ENTITY_ID	NUMBER		Yes	Work order identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
USER_DEFINED_STATUS_ID	NUMBER			Stores the User defined work order status
PENDING_FLAG	VARCHAR2	(1)		Stores whether status change has some pending approval.Y indicates status is pending, N or Null indicates not pending
MATERIAL_SHORTAGE_CHECK_DATE	DATE			The date at which the work order was checked for material shortage
MATERIAL_SHORTAGE_FLAG	NUMBER
MATERIAL_SHORTAGE_DISP	VARCHAR2	(80)		Displays the description of material shortage status
WORKFLOW_TYPE	NUMBER			Stores the Workflow Type to find the workflow process to be followed. Maps to lookup_code for EAM_WORKFLOW_TYPE lookup type
WARRANTY_CLAIM_STATUS	NUMBER			The status of the warranty claim. This will be a lookup
CYCLE_ID	NUMBER			Used by Multiple Asset Activity PM
SEQ_ID	NUMBER			Used by Multiple Asset Activity PM
DS_SCHEDULED_FLAG	VARCHAR2	(1)		Identify if theDetailed Scheduler has scheduled the work order.
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
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
WORK_ORDER_STATUS	VARCHAR2	(80)
WORK_ORDER_STATUS_PENDING	VARCHAR2	(4000)		Concatenates Pending flag with user defined status if the work order is in pending status else shows the user defined status
PM_SUGGESTED_START_DATE	DATE			Original Scheduled Start Date
PM_SUGGESTED_END_DATE	DATE			Original Scheduled End Date
FAILURE_CODE_REQUIRED	VARCHAR2	(240)		Flag indicating if failure code entry is required
WARRANTY_ACTIVE	NUMBER			Flag indicating if warranty is active or not for the work order
ESTIMATE_ID	NUMBER
ESTIMATE_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT ROW_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      USER_DEFINED_STATUS_ID
,      PENDING_FLAG
,      MATERIAL_SHORTAGE_CHECK_DATE
,      MATERIAL_SHORTAGE_FLAG
,      MATERIAL_SHORTAGE_DISP
,      WORKFLOW_TYPE
,      WARRANTY_CLAIM_STATUS
,      CYCLE_ID
,      SEQ_ID
,      DS_SCHEDULED_FLAG
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WORK_ORDER_STATUS
,      WORK_ORDER_STATUS_PENDING
,      PM_SUGGESTED_START_DATE
,      PM_SUGGESTED_END_DATE
,      FAILURE_CODE_REQUIRED
,      WARRANTY_ACTIVE
,      ESTIMATE_ID
,      ESTIMATE_NUMBER
FROM APPS.EAM_WORK_ORDER_DETAILS_V;