EAM Extrait des ordres de travail

➜ Back to Library
Description
Auteur: Ion Yilmaz 13.mai 2019
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 thi ...  Auteur: Ion Yilmaz 13.mai 2019
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.
Revison 1 13.mai 2019 logic change to allow work orders without activities assigned to be included.
Revision 2 6.juin2020 Added disable date control for ''At Risk'' activities
License: Creative Commons CC with Attribution   more

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select distinct
          ecwo.asset_number "Equipement"
        , ecwo.asset_number_description "Equipement designation"
        , ecwo.area "Zone"
        , NVL(ecwo.asset_activity, 'NA') "Activité"
        , NVL(ecwo.asset_activity_description, ' ') "Activité designation"
        , ecwo.scheduled_start_date "Date de début programmé"
        , ecwo.wip_entity_name "Ordre de travail"
        , ecwo.system_status_disp "OT status"
        , NVL((select to_char(msib.cumulative_total_lead_time*24, '999.99') from dual,
          apps.mtl_system_items_b msib
          where ecwo.asset_activity_id = msib.inventory_item_id
          and     ecwo.organization_id = msib.organization_id)
          , ' ') "Temps prévu"
        , ecwo.activity_cause_disp "Cause d'activité" 
        , NVL((select distinct meaa.attribute2
               from apps.mtl_eam_asset_activities_v meaa
               where 1=1
               and ecwo.asset_activity_id = meaa.asset_activity_id
               and ecwo.organization_id = meaa.organization_id
               and NVL(end_date_active,sysdate + 1) > sysdate), ' ') "Activité à risque" -- Rev. 2      
        , ecwo.class_code "Classe en-cours"
        , ecwo.owning_department_code "Département"
        , ecwo.activity_type "Type d'activité"
        , ecwo.priority_disp "Priorité de travail"
        , ecwo.shutdown_type_disp "Arrêt"
from      apps.eam_cfr_work_order_v ecwo
where   1=1
order by 4, 6
Parameter Name SQL text Validation
Organization 
ecwo.organization_id=:P_organization_id
 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
Download
 
Related Blitz Reports
EAM Work Order Details Extract for multiple activity assignments EAM Work Order Details INV Item Upload Senfor eAM Preventative Maintenance Planning - CC BY İon Yılmaz EAM Work Orders EAM Preventative Maintenance Forecast Planning EAM Analyse criticité ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL1 ECC Enterprise Asset Management, Work Order Assets (Maintenance)
Blitz Report™

Blitz Report™ provides multiple benefits: