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: TableEAM.EAM_WORK_ORDER_DETAILS
Subobject Name:
Status: VALID


This table stores the work order detail information specific for eAM


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_WORK_ORDER_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnORGANIZATION_ID
EAM_WORK_ORDER_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_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

Estimate id reference If the work order was created from Construction Estimate
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
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:

SchemaAPPS
SynonymEAM_WORK_ORDER_DETAILS