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.SERIAL_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
, ML7.MEANING
, 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
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, MFG_LOOKUPS ML8
, BOM_DEPARTMENTS BD
, MTL_EAM_ASSET_ACTIVITIES MEAA
, EAM_FORECASTED_WORK_ORDERS FW
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, MTL_SYSTEM_ITEMS MSI
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 ML7.LOOKUP_TYPE (+) = 'WIP_JOB_STATUS'
AND ML7.LOOKUP_CODE (+) = WDJ.STATUS_TYPE
AND ML8.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_ORDER_TYPE'
AND ML8.LOOKUP_CODE (+) = WDJ.WORK_ORDER_TYPE

Columns