View: EAM_WORK_ORDERS_V

Product:	EAM - Enterprise Asset Management
Description:	View shows all maintenance work orders alongwith the service requests associated to them
Implementation/DBA Data:	APPS.EAM_WORK_ORDERS_V

View Text

SELECT WEO.ROW_ID
, WEO.WIP_ENTITY_ID
, WEO.WIP_ENTITY_NAME
, WEO.WE_ROW_ID AS WE_ROW_ID
, WEO.ENTITY_TYPE
, WEO.ORGANIZATION_ID
, WEO.LAST_UPDATE_DATE
, WEO.LAST_UPDATED_BY
, WEO.CREATION_DATE
, WEO.CREATED_BY
, WEO.LAST_UPDATE_LOGIN
, WEO.DESCRIPTION
, WEO.PRIMARY_ITEM_ID
, WEO.ASSET_GROUP_ID
, WEO.ASSET_NUMBER
, WEO.ASSET_DESCRIPTION
, WEO.CLASS_CODE
, WEO.STATUS_TYPE
, WEO.STATUS_TYPE_DISP
, WEO.PM_SCHEDULE_ID
, WEO.MANUAL_REBUILD_FLAG
, WEO.WORK_ORDER_TYPE
, WEO.WORK_ORDER_TYPE_DISP
, WEO.MATERIAL_ACCOUNT
, WEO.MATERIAL_OVERHEAD_ACCOUNT
, WEO.RESOURCE_ACCOUNT
, WEO.OUTSIDE_PROCESSING_ACCOUNT
, WEO.MATERIAL_VARIANCE_ACCOUNT
, WEO.RESOURCE_VARIANCE_ACCOUNT
, WEO.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WEO.STD_COST_ADJUSTMENT_ACCOUNT
, WEO.OVERHEAD_ACCOUNT
, WEO.OVERHEAD_VARIANCE_ACCOUNT
, WEO.SCHEDULED_START_DATE
, WEO.SCHEDULED_COMPLETION_DATE
, WEO.DATE_RELEASED
, WEO.DATE_COMPLETED
, WEO.DATE_CLOSED
, WEO.OWNING_DEPARTMENT
, WEO.OWNING_DEPARTMENT_CODE
, WEO.ACTIVITY_TYPE
, WEO.ACTIVITY_TYPE_DISP
, WEO.ACTIVITY_CAUSE
, WEO.ACTIVITY_CAUSE_DISP
, WEO.PRIORITY
, WEO.PRIORITY_DISP
, WEO.REQUESTED_START_DATE
, WEO.REQUESTED_DUE_DATE
, WEO.ESTIMATION_STATUS
, WEO.NOTIFICATION_REQUIRED
, WEO.SHUTDOWN_TYPE
, WEO.SHUTDOWN_TYPE_DISP
, WEO.TAGOUT_REQUIRED
, WEO.PLAN_MAINTENANCE
, WEO.FIRM_PLANNED_FLAG
, WEO.SCHEDULE_GROUP_ID
, WEO.SCHEDULE_GROUP_NAME
, WEO.PROJECT_NUMBER
, WEO.PROJECT_NAME
, WEO.PROJECT_ID
, WEO.TASK_NUMBER
, WEO.TASK_NAME
, WEO.TASK_ID
, WEO.PARENT_WIP_ENTITY_ID
, WEO.PARENT_WIP_ENTITY_NAME
, WEO.REBUILD_ITEM_ID
, WEO.REBUILD_SERIAL_NUMBER
, WEO.BOM_REFERENCE_ID
, WEO.ROUTING_REFERENCE_ID
, WEO.COMMON_BOM_SEQUENCE_ID
, WEO.COMMON_ROUTING_SEQUENCE_ID
, WEO.ALTERNATE_BOM_DESIGNATOR
, WEO.BOM_REVISION
, WEO.BOM_REVISION_DATE
, WEO.ALTERNATE_ROUTING_DESIGNATOR
, WEO.ROUTING_REVISION
, WEO.ROUTING_REVISION_DATE
, WEO.COMPLETION_SUBINVENTORY
, WEO.COMPLETION_LOCATOR_ID
, WEO.LOT_NUMBER
, WEO.DEMAND_CLASS
, WEO.ATTRIBUTE_CATEGORY
, WEO.ATTRIBUTE1
, WEO.ATTRIBUTE2
, WEO.ATTRIBUTE3
, WEO.ATTRIBUTE4
, WEO.ATTRIBUTE5
, WEO.ATTRIBUTE6
, WEO.ATTRIBUTE7
, WEO.ATTRIBUTE8
, WEO.ATTRIBUTE9
, WEO.ATTRIBUTE10
, WEO.ATTRIBUTE11
, WEO.ATTRIBUTE12
, WEO.ATTRIBUTE13
, WEO.ATTRIBUTE14
, WEO.ATTRIBUTE15
, WEO.MAINTENANCE_OBJECT_ID AS INSTANCE_ID
, NULL AS INSTANCE_NUMBER
, WEO.MAINTENANCE_OBJECT_SOURCE
, WEO.MAINTENANCE_OBJECT_TYPE
, WEO.SOURCE
, WEO.MAINTENANCE_OBJECT_ID
, EWSA.SERVICE_REQUEST_ID
, CIAB.INCIDENT_NUMBER AS SERVICE_REQUEST
, WEO.MATERIAL_ISSUE_BY_MO
, WEO.ACTIVITY_SOURCE
, WEO.ACTIVITY_SOURCE_MEANING
FROM WIP_EAM_WORK_ORDERS_V WEO
, EAM_WO_SERVICE_ASSOCIATION EWSA
, CS_INCIDENTS_ALL_B CIAB
WHERE EWSA.WIP_ENTITY_ID(+) = WEO.WIP_ENTITY_ID
AND CIAB.INCIDENT_ID(+) = EWSA.SERVICE_REQUEST_ID

Columns