[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_WORK_ORDERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EAM.EAM_WORK_ORDERS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Id of WIP_DISCRETE_JOBS table | |
| SCHED_PARENT_WIP_ENTITY_NAME | VARCHAR2 | (240) | Parent Wip Entity Name | |
| ACTUAL_START_DATE | DATE | Actual Start Date | ||
| WIP_ENTITY_ID | NUMBER | Yes | Wip Entity Id | |
| WIP_ENTITY_NAME | VARCHAR2 | (240) | Yes | Wip Entity Name |
| WE_ROW_ID | ROWID | (10) | Row Id of Wip Entity Table | |
| ENTITY_TYPE | NUMBER | Yes | Entity Type | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
| 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 | ||
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| PRIMARY_ITEM_ID | NUMBER | Primary Item Id - Asset Activity Id | ||
| ASSET_GROUP_ID | NUMBER | Asset Group Id - Inventory Item Id of the Asset | ||
| ASSET_NUMBER | VARCHAR2 | (30) | Asset Number | |
| ASSET_DESCRIPTION | VARCHAR2 | (240) | Asset Description | |
| CLASS_CODE | VARCHAR2 | (10) | Yes | Accounting Class Code |
| STATUS_TYPE | NUMBER | Yes | Work Order Status | |
| PM_SCHEDULE_ID | NUMBER | PM Schedule Id | ||
| MANUAL_REBUILD_FLAG | VARCHAR2 | (1) | Manual Rebuild Flag | |
| WORK_ORDER_TYPE | VARCHAR2 | (30) | Work Order Type - Lookup | |
| WORK_ORDER_TYPE_DISP | VARCHAR2 | (80) | Work Order Type - Meanings from Lookup | |
| MATERIAL_ACCOUNT | NUMBER | Material Account | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Material Overhead Account | ||
| RESOURCE_ACCOUNT | NUMBER | Resource Account | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Outside Processing Account | ||
| MATERIAL_VARIANCE_ACCOUNT | NUMBER | Material Variance Account | ||
| RESOURCE_VARIANCE_ACCOUNT | NUMBER | Resource Variance Account | ||
| OUTSIDE_PROC_VARIANCE_ACCOUNT | NUMBER | Outside Processing Variance Account | ||
| STD_COST_ADJUSTMENT_ACCOUNT | NUMBER | Standard Cost Adjustment Account | ||
| OVERHEAD_ACCOUNT | NUMBER | Overhead Account | ||
| OVERHEAD_VARIANCE_ACCOUNT | NUMBER | Overhead Variance Account | ||
| SCHEDULED_START_DATE | DATE | Yes | Work Order Scheduled Start Date | |
| SCHEDULED_COMPLETION_DATE | DATE | Yes | Work Order Scheduled Completion Date | |
| DATE_RELEASED | DATE | Work Order Release Date | ||
| DATE_COMPLETED | DATE | Completion Date of Work Order | ||
| DATE_CLOSED | DATE | Closing Date of Work Order | ||
| OWNING_DEPARTMENT | NUMBER | Owning Department of Work Order | ||
| OWNING_DEPARTMENT_CODE | VARCHAR2 | (10) | Owning Department Code of Work Order | |
| ACTIVITY_TYPE | VARCHAR2 | (30) | Activity Type - Lookup | |
| ACTIVITY_TYPE_DISP | VARCHAR2 | (80) | Activity Type - Meaning from Lookup | |
| ACTIVITY_CAUSE | VARCHAR2 | (30) | Activity Cause - Lookup | |
| ACTIVITY_CAUSE_DISP | VARCHAR2 | (80) | Activity Cause - Meaning from Lookup | |
| PRIORITY | NUMBER | Priority - from Lookup | ||
| PRIORITY_DISP | VARCHAR2 | (80) | Priority - Meaning from Lookup | |
| REQUESTED_START_DATE | DATE | Requested Start Date | ||
| REQUESTED_DUE_DATE | DATE | Requested Due Date | ||
| ESTIMATION_STATUS | NUMBER | Estimation Status | ||
| NOTIFICATION_REQUIRED | VARCHAR2 | (1) | Notification Required | |
| SHUTDOWN_TYPE | VARCHAR2 | (30) | Shutdown Type - Lookup | |
| SHUTDOWN_TYPE_DISP | VARCHAR2 | (80) | Shutdown Type - Meaning from Lookup | |
| TAGOUT_REQUIRED | VARCHAR2 | (1) | Tagout Required | |
| PLAN_MAINTENANCE | VARCHAR2 | (1) | Planned Maintenance | |
| FIRM_PLANNED_FLAG | NUMBER | Yes | Firm flag | |
| SCHEDULE_GROUP_ID | NUMBER | Schedule Group Id | ||
| SCHEDULE_GROUP_NAME | VARCHAR2 | (30) | Schedule Group Name | |
| PROJECT_NUMBER | VARCHAR2 | (4000) | Project Number | |
| PROJECT_NAME | VARCHAR2 | (4000) | Project Name | |
| PROJECT_ID | NUMBER | Project Id | ||
| TASK_NUMBER | VARCHAR2 | (4000) | Task Number | |
| TASK_NAME | VARCHAR2 | (4000) | Task Name | |
| TASK_ID | NUMBER | Task Id | ||
| PARENT_WIP_ENTITY_ID | NUMBER | Parent Wip Entity Id - Parent Work Order Id | ||
| PARENT_WIP_ENTITY_NAME | VARCHAR2 | (240) | Parent Work Order Name | |
| REBUILD_ITEM_ID | NUMBER | Rebuild Item Id - Inventory Item Id of Rebuild Item | ||
| REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | Rebuild Serial Number | |
| BOM_REFERENCE_ID | NUMBER | Bill of Materials Reference Id | ||
| ROUTING_REFERENCE_ID | NUMBER | Routing Reference Id | ||
| COMMON_BOM_SEQUENCE_ID | NUMBER | Common BOM Sequence Id | ||
| COMMON_ROUTING_SEQUENCE_ID | NUMBER | Common Routing Sequence Id | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate BOM Designator | |
| BOM_REVISION | VARCHAR2 | (3) | Revision of Bill of Materials | |
| BOM_REVISION_DATE | DATE | Revision Date of Bill of Materials | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate Routing Designator | |
| ROUTING_REVISION | VARCHAR2 | (3) | Routing Revision | |
| ROUTING_REVISION_DATE | DATE | Routing Revision Date | ||
| COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Completion Subinventory | |
| COMPLETION_LOCATOR_ID | NUMBER | Completion Locator Id | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| DEMAND_CLASS | VARCHAR2 | (30) | Demand Class | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Segments | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segments | |
| INSTANCE_ID | NUMBER | Instance Id | ||
| INSTANCE_NUMBER | VARCHAR2 | (30) | Instance Number | |
| MAINTENANCE_OBJECT_SOURCE | NUMBER | Maintenance Object Source | ||
| MAINTENANCE_OBJECT_TYPE | NUMBER | Maintenance Object Type | ||
| SOURCE | VARCHAR2 | (80) | Source | |
| MAINTENANCE_OBJECT_ID | NUMBER | Maintenance Object Id - Genealogy Object Id for serialized rebuild items/assets and inventory item id for non-serialized rebuilds | ||
| SERVICE_REQUEST_ID | NUMBER | Service Request Id | ||
| SERVICE_REQUEST | VARCHAR2 | (64) | Service Request | |
| MATERIAL_ISSUE_BY_MO | VARCHAR2 | (1) | Material Issue By Move Order | |
| ACTIVITY_SOURCE | VARCHAR2 | (30) | Activity Source - Lookup | |
| ACTIVITY_SOURCE_MEANING | VARCHAR2 | (80) | Activity Source - Meaning from Lookup | |
| EAM_LINEAR_LOCATION_ID | NUMBER | |||
| PENDING_FLAG | VARCHAR2 | (1) | Stores whether status change has some pending approval.Y indicates status is pending, N or Null indicates not pending | |
| USER_DEFINED_STATUS_ID | NUMBER | Stores the User defined work order status | ||
| WORK_ORDER_STATUS | VARCHAR2 | (80) | Status of work order | |
| 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 | |
| MATERIAL_SHORTAGE_CHECK_DATE | DATE | The date at which the work order was checked for material shortage | ||
| MATERIAL_SHORTAGE_FLAG | NUMBER | Stores the material shortage status of the workorder. 2 if all material is available, 1 if some/all material is not available, null if shortage has not been calculated yet, 3 if an error occurred when calculating the shortage | ||
| MATERIAL_SHORTAGE_DISP | VARCHAR2 | (80) | Description of material shortage | |
| 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. | ||
| 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 the Detailed Scheduler has scheduled the work order. | |
| ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | serial_number | |
| MAINT_ORGANIZATION_ID | NUMBER | Maintenance organization id | ||
| ASSET_REBUILD_GROUP | VARCHAR2 | (40) | Concatenated segments for Asset Group / Rebuild Items | |
| PM_SUGGESTED_START_DATE | DATE | Original Scheduled Start Date | ||
| PM_SUGGESTED_END_DATE | DATE | Original Scheduled End Date | ||
| FAILURE_ID | NUMBER | Failure identifier | ||
| FAILURE_ENTRY_ID | NUMBER | Failure entry identifier | ||
| FAILURE_CODE | VARCHAR2 | (80) | Identifier for failure code | |
| CAUSE_CODE | VARCHAR2 | (80) | Identifier for cause code | |
| RESOLUTION_CODE | VARCHAR2 | (80) | Identifier for resolution code | |
| FAILURE_CODE_REQUIRED | VARCHAR2 | (240) | Flag indicating if failure code entry is required | |
| FAILURE_DATE | DATE | Failure date | ||
| COMMENTS | VARCHAR2 | (2000) | Failure comment | |
| PARENT_INSTANCE_NUMBER | VARCHAR2 | (30) | Asset number of parent work order |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SCHED_PARENT_WIP_ENTITY_NAME
, ACTUAL_START_DATE
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
, WE_ROW_ID
, ENTITY_TYPE
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, PRIMARY_ITEM_ID
, ASSET_GROUP_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, CLASS_CODE
, STATUS_TYPE
, PM_SCHEDULE_ID
, MANUAL_REBUILD_FLAG
, WORK_ORDER_TYPE
, WORK_ORDER_TYPE_DISP
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, MATERIAL_VARIANCE_ACCOUNT
, RESOURCE_VARIANCE_ACCOUNT
, OUTSIDE_PROC_VARIANCE_ACCOUNT
, STD_COST_ADJUSTMENT_ACCOUNT
, OVERHEAD_ACCOUNT
, OVERHEAD_VARIANCE_ACCOUNT
, SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE
, DATE_RELEASED
, DATE_COMPLETED
, DATE_CLOSED
, OWNING_DEPARTMENT
, OWNING_DEPARTMENT_CODE
, ACTIVITY_TYPE
, ACTIVITY_TYPE_DISP
, ACTIVITY_CAUSE
, ACTIVITY_CAUSE_DISP
, PRIORITY
, PRIORITY_DISP
, REQUESTED_START_DATE
, REQUESTED_DUE_DATE
, ESTIMATION_STATUS
, NOTIFICATION_REQUIRED
, SHUTDOWN_TYPE
, SHUTDOWN_TYPE_DISP
, TAGOUT_REQUIRED
, PLAN_MAINTENANCE
, FIRM_PLANNED_FLAG
, SCHEDULE_GROUP_ID
, SCHEDULE_GROUP_NAME
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, TASK_NUMBER
, TASK_NAME
, TASK_ID
, PARENT_WIP_ENTITY_ID
, PARENT_WIP_ENTITY_NAME
, REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER
, BOM_REFERENCE_ID
, ROUTING_REFERENCE_ID
, COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID
, ALTERNATE_BOM_DESIGNATOR
, BOM_REVISION
, BOM_REVISION_DATE
, ALTERNATE_ROUTING_DESIGNATOR
, ROUTING_REVISION
, ROUTING_REVISION_DATE
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, LOT_NUMBER
, DEMAND_CLASS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INSTANCE_ID
, INSTANCE_NUMBER
, MAINTENANCE_OBJECT_SOURCE
, MAINTENANCE_OBJECT_TYPE
, SOURCE
, MAINTENANCE_OBJECT_ID
, SERVICE_REQUEST_ID
, SERVICE_REQUEST
, MATERIAL_ISSUE_BY_MO
, ACTIVITY_SOURCE
, ACTIVITY_SOURCE_MEANING
, EAM_LINEAR_LOCATION_ID
, PENDING_FLAG
, USER_DEFINED_STATUS_ID
, WORK_ORDER_STATUS
, WORK_ORDER_STATUS_PENDING
, MATERIAL_SHORTAGE_CHECK_DATE
, MATERIAL_SHORTAGE_FLAG
, MATERIAL_SHORTAGE_DISP
, WORKFLOW_TYPE
, WARRANTY_CLAIM_STATUS
, CYCLE_ID
, SEQ_ID
, DS_SCHEDULED_FLAG
, ASSET_SERIAL_NUMBER
, MAINT_ORGANIZATION_ID
, ASSET_REBUILD_GROUP
, PM_SUGGESTED_START_DATE
, PM_SUGGESTED_END_DATE
, FAILURE_ID
, FAILURE_ENTRY_ID
, FAILURE_CODE
, CAUSE_CODE
, RESOLUTION_CODE
, FAILURE_CODE_REQUIRED
, FAILURE_DATE
, COMMENTS
, PARENT_INSTANCE_NUMBER
FROM APPS.EAM_WORK_ORDERS_V;
APPS
BOM_DEPARTMENTS
CSI_ITEM_INSTANCES
CS_INCIDENTS_B_SEC
EAM_ASSET_FAILURES
EAM_ASSET_FAILURE_CODES
EAM_JOB_COMPLETION_TXNS
EAM_WORK_ORDER_DETAILS_V
EAM_WO_RELATIONSHIPS
EAM_WO_SERVICE_ASSOCIATION
FND_MESSAGE
- show dependent code
MFG_LOOKUPS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS
MTL_SYSTEM_ITEMS_KFV
PJM_PROJECT
- show dependent code
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_SCHEDULE_GROUPS
APPS
EAM_WORKORDERREP_PVT
- show dependent code
|
|
|
|