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: EAM.EAM_WORK_ORDER_DETAILS

Object Details

Object Name:	EAM_WORK_ORDER_DETAILS
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_WORK_ORDER_DETAILS
Subobject Name:
Status:	VALID

This table stores the work order detail information specific for eAM

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_WORK_ORDER_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID ORGANIZATION_ID
EAM_WORK_ORDER_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	Work Order Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
USER_DEFINED_STATUS_ID	NUMBER			User defined work order status
PENDING_FLAG	VARCHAR2	(1)		Pending Flag
MATERIAL_SHORTAGE_CHECK_DATE	DATE			Material Shortage check date
MATERIAL_SHORTAGE_FLAG	NUMBER			Material Shortage Flag
WORKFLOW_TYPE	NUMBER			Workflow type
WARRANTY_CLAIM_STATUS	NUMBER			Warrany Claim Status
CYCLE_ID	NUMBER			Cycle Identifier
SEQ_ID	NUMBER			Sequence Number
DS_SCHEDULED_FLAG	VARCHAR2	(1)		Flag to indicate if work order is scheduled by detailed scheduling engine
ASSIGNMENT_COMPLETE	VARCHAR2	(1)		Flag to indicate the assignment completion for work order
WARRANTY_ACTIVE	NUMBER			Flag indicating whether warranty is active for the workorder or not
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			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
PM_SUGGESTED_START_DATE	DATE			Original Scheduled Start date of work order
PM_SUGGESTED_END_DATE	DATE			Original Scheduled end date of work order
PM_BASE_METER_READING	NUMBER			Stores the PM Base Meter Reading based on which work order is generated
PM_BASE_METER	NUMBER			Stores the PM Base Meter Id based on which work order is generated
FAILURE_CODE_REQUIRED	VARCHAR2	(240)		Stores whether a failure informationis required on this work order
ESTIMATE_ID	NUMBER			Unique identifier for estimate id
PLANNER_MAINTENANCE	NUMBER			Planner Maintenance Code

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      USER_DEFINED_STATUS_ID
,      PENDING_FLAG
,      MATERIAL_SHORTAGE_CHECK_DATE
,      MATERIAL_SHORTAGE_FLAG
,      WORKFLOW_TYPE
,      WARRANTY_CLAIM_STATUS
,      CYCLE_ID
,      SEQ_ID
,      DS_SCHEDULED_FLAG
,      ASSIGNMENT_COMPLETE
,      WARRANTY_ACTIVE
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PM_SUGGESTED_START_DATE
,      PM_SUGGESTED_END_DATE
,      PM_BASE_METER_READING
,      PM_BASE_METER
,      FAILURE_CODE_REQUIRED
,      ESTIMATE_ID
,      PLANNER_MAINTENANCE
FROM EAM.EAM_WORK_ORDER_DETAILS;

Dependencies

[top of page]

EAM.EAM_WORK_ORDER_DETAILS does not reference any database object

EAM.EAM_WORK_ORDER_DETAILS is referenced by following:

EAM: EAM_WORK_ORDER_DETAILS#