EAM Senfor Intl Work Order Details Extract for multiple activity assignments

➜ Back to Library
Description
Categories: EAM Senfor Intl
This report extracts eAM work order details from the eAM Work Order View.
The particularity of this report is that it will also search for any valid attributes from the eAM asset activities view. For example, in this case the asset activity attribute2 is used to identify if the asset activity is an ''At Risk'' activity. This attribute is also extracted in this report.
The cumulative total lead time, if present, of the activities is also output.
The primary usage of this report is in the tracking and planning of eAM maintenance work orders.

The report can be run by any combination of organization, scheduled start dates, work order status; see below. Additional parameters may be added as required.

Version Modified on Modified  by   Description 
===== ======== == ====== ========
  1.0     15 Jun 2019 Ion Yılmaz     Initial Release
2.0 15 Jun 2020 Ion Yılmaz Modified version of EAM Work Order Details Extract to ensure that multiple activity assignments are correctly output.

Copyright 2019 Senfor International Yönetim Danışmanlık Hizmetleri Ltd. Şti.

Original Author: İon Yılmaz ([email protected]) Senfor International, www.senfor-intl.eu ...  This report extracts eAM work order details from the eAM Work Order View.
The particularity of this report is that it will also search for any valid attributes from the eAM asset activities view. For example, in this case the asset activity attribute2 is used to identify if the asset activity is an ''At Risk'' activity. This attribute is also extracted in this report.
The cumulative total lead time, if present, of the activities is also output.
The primary usage of this report is in the tracking and planning of eAM maintenance work orders.

The report can be run by any combination of organization, scheduled start dates, work order status; see below. Additional parameters may be added as required.

Version Modified on Modified  by   Description 
===== ======== == ====== ========
  1.0     15 Jun 2019 Ion Yılmaz     Initial Release
2.0 15 Jun 2020 Ion Yılmaz Modified version of EAM Work Order Details Extract to ensure that multiple activity assignments are correctly output.

Copyright 2019 Senfor International Yönetim Danışmanlık Hizmetleri Ltd. Şti.

Original Author: İon Yılmaz ([email protected]) Senfor International, www.senfor-intl.eu
All rights reserved. Permission to use this code is granted provided the original author is acknowledged.

This code is made available on an "As-Is" basis and may require modification depending upon the configuration of the system it is being used on.

The author does not assume or hereby disclaim any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from negligence, accident, or any other cause.   |

Parameters:
===========
Organization:  Select the specific inventory organization(s) to be extracted (Mandatory).
Scheduled start from/to: Enter the scheduled start date range (Optional).
Order Status: Select the work order status(es) to be included (Optional).
   more 
select distinct 
          ecwo.asset_number "Equipement"
        , ecwo.asset_number_description "Equipement designation"
        , NVL(ecwo.area, ' ') "Zone"
        , NVL(ecwo.asset_activity, 'NA') "Activité"
        , NVL(ecwo.asset_activity_description, ' ') "Designation activité"
        , ecwo.scheduled_start_date "Date de début programmé"
        , ecwo.wip_entity_name "Ordre de travail"
        , ecwo.system_status_disp "OT status"
        , NVL(to_char(msib.cumulative_total_lead_time*24, '999.99'), ' ') "Temps prévu"
        , NVL(ecwo.activity_cause_disp, ' ') "Cause d'activité"
        , NVL(meaa.attribute2, ' ') "Activité à risque"
        , ecwo.class_code "Classe en-cours"
        , ecwo.owning_department_code "Département"
        , ecwo.activity_type "Type d'activité"
        , NVL(ecwo.priority_disp, ' ') "Priorité de travail"
        , ecwo.shutdown_type_disp "Arrét"
from  apps.eam_cfr_work_order_v ecwo
     ,apps.mtl_eam_asset_activities_v meaa
     ,apps.mtl_system_items_b msib
     ,dual
where 1=1
and     ecwo.asset_activity_id = meaa.asset_activity_id
and     ecwo.organization_id = meaa.organization_id
and     NVL(meaa.end_date_active,sysdate + 1) > sysdate
and     ecwo.asset_activity_id = msib.inventory_item_id
order by 4, 3
Parameter NameSQL textValidation
Organization
ecwo.organization_id=(select organization_id from apps.mtl_parameters where organization_code = :P_ORGANIZATION)
LOV Oracle
Scheduled start from
ecwo.scheduled_start_date>=:P_SCHED_START_FROM
Date
Scheduled start to
ecwo.scheduled_start_date<=:P_SCHED_START_TO
Date
Order Status
ecwo.user_defined_status_disp = :P_ORDER_STATUS
LOV
Download
Related Blitz Reports
EAM Senfor Intl Extrait des Ordres de Travail EAM Senfor Intl Work Order Details EAM PM Schedule Upload INV Item Upload INV Items EAM Senfor Intl - eAM Preventative Maintenance Planning EAM Work Orders EAM Senfor Intl Preventative Maintenance Forecast Planning EAM Senfor Intl Analyse Criticité
Blitz Report™