[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
EAM.EAM_WORK_ORDER_DETAILS does not reference any database object
EAM.EAM_WORK_ORDER_DETAILS is referenced by following:
|
|
|