View: EAM_OUTSTANDING_WORK_ORDERS_V

Product:	EAM - Enterprise Asset Management
Description:	View shows work orders forecasted by Preventive Maintenance scheduling.
Implementation/DBA Data:	APPS.EAM_OUTSTANDING_WORK_ORDERS_V

View Text

SELECT FW.GROUP_ID
, DECODE(FW.ACTION_TYPE
, 1
, 3
, DECODE(WDJ.PM_SCHEDULE_ID
, NULL
, 1
, 2)) WORK_ORDER_PM_TYPE
, ML1.MEANING
, FW.ACTION_TYPE ACTION_TYPE
, ML6.MEANING
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, MEAA.ORGANIZATION_ID
, FW.PM_FORECAST_ID
, MEAA.INVENTORY_ITEM_ID
, MEAA.INSTANCE_NUMBER
, MEAA.ASSET_ACTIVITY_ID
, FW.LAST_UPDATE_DATE
, FW.LAST_UPDATED_BY
, FW.CREATION_DATE
, FW.CREATED_BY
, FW.LAST_UPDATE_LOGIN
, WDJ.STATUS_TYPE
, DECODE(WDJ.WIP_ENTITY_ID
, NULL
, MSI.DESCRIPTION
, WDJ.DESCRIPTION) DESCRIPTION
, WDJ.FIRM_PLANNED_FLAG
, FW.SCHEDULED_START_DATE
, FW.SCHEDULED_COMPLETION_DATE
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, TO_NUMBER(MEAA.PRIORITY_CODE)
, ML5.MEANING
, FW.PM_SCHEDULE_ID
, WDJ.WORK_ORDER_TYPE
, ML8.MEANING
, MEAA.ACTIVITY_TYPE_CODE
, ML2.MEANING
, MEAA.ACTIVITY_CAUSE_CODE
, ML3.MEANING
, MEAA.SHUTDOWN_TYPE_CODE
, ML4.MEANING
, MEAA.OWNING_DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, WDJ.NOTIFICATION_REQUIRED
, WDJ.TAGOUT_REQUIRED
, NVL(WDJ.PLAN_MAINTENANCE
, 'N')
, FW.ATTRIBUTE_CATEGORY
, FW.ATTRIBUTE1
, FW.ATTRIBUTE2
, FW.ATTRIBUTE3
, FW.ATTRIBUTE4
, FW.ATTRIBUTE5
, FW.ATTRIBUTE6
, FW.ATTRIBUTE7
, FW.ATTRIBUTE8
, FW.ATTRIBUTE9
, FW.ATTRIBUTE10
, FW.ATTRIBUTE11
, FW.ATTRIBUTE12
, FW.ATTRIBUTE13
, FW.ATTRIBUTE14
, FW.ATTRIBUTE15
, FW.CYCLE_ID
, FW.SEQ_ID
, FW.WO_STATUS
, EWSV.WORK_ORDER_STATUS
, EPS.NAME
, MEAA.EAM_ITEM_TYPE
, DECODE(WDJ.WIP_ENTITY_ID
, NULL
, EWSV.WORK_ORDER_STATUS
, EWODV.WORK_ORDER_STATUS_PENDING) WO_STATUS_DISP
, MEAA.MAINTENANCE_OBJECT_ID
, MEAA.MAINTENANCE_OBJECT_TYPE
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML8
, BOM_DEPARTMENTS BD
, MTL_EAM_ASSET_ACTIVITIES_V MEAA
, EAM_FORECASTED_WORK_ORDERS FW
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, EAM_PM_SCHEDULINGS EPS
, EAM_WO_STATUSES_V EWSV
, MTL_SYSTEM_ITEMS_VL MSI
, EAM_WORK_ORDER_DETAILS_V EWODV
WHERE FW.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID(+) AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+) AND WE.ENTITY_TYPE(+) = 6 AND FW.PROCESS_FLAG <> 'Y' AND FW.ACTIVITY_ASSOCIATION_ID = MEAA.ACTIVITY_ASSOCIATION_ID(+) AND BD.DEPARTMENT_ID (+) = MEAA.OWNING_DEPARTMENT_ID AND BD.ORGANIZATION_ID (+) = MEAA.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MEAA.ASSET_ACTIVITY_ID AND MSI.ORGANIZATION_ID = MEAA.ORGANIZATION_ID AND ML1.LOOKUP_TYPE (+) = 'EAM_WORK_ORDER_PM_TYPE' AND ML1.LOOKUP_CODE = DECODE(FW.ACTION_TYPE
, 1
, 3
, DECODE(WDJ.PM_SCHEDULE_ID
, NULL
, 1
, 2)) AND ML2.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_TYPE' AND ML2.LOOKUP_CODE (+) = MEAA.ACTIVITY_TYPE_CODE AND ML3.LOOKUP_TYPE (+) = 'MTL_EAM_ACTIVITY_CAUSE' AND ML3.LOOKUP_CODE (+) = MEAA.ACTIVITY_CAUSE_CODE AND ML4.LOOKUP_TYPE (+) = 'BOM_EAM_SHUTDOWN_TYPE' AND ML4.LOOKUP_CODE (+) = MEAA.SHUTDOWN_TYPE_CODE AND ML5.LOOKUP_TYPE (+) = 'WIP_EAM_ACTIVITY_PRIORITY' AND ML5.LOOKUP_CODE (+) = MEAA.PRIORITY_CODE AND ML6.LOOKUP_TYPE (+) = 'EAM_WORK_ORDER_PM_ACTION' AND ML6.LOOKUP_CODE (+) = FW.ACTION_TYPE AND ML8.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_ORDER_TYPE' AND ML8.LOOKUP_CODE (+) = WDJ.WORK_ORDER_TYPE AND EWSV.STATUS_ID=FW.WO_STATUS AND FW.PM_SCHEDULE_ID=EPS.PM_SCHEDULE_ID AND FW.WIP_ENTITY_ID = EWODV.WIP_ENTITY_ID(+)

Columns