EAM Work Order Details Extract for multiple activity assignments
Description
Author: Ion Yilmaz 15.jun 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 ... more
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 ... more
Run
EAM Work Order Details Extract for multiple activity assignments and other Oracle EBS reports with Blitz Report™ on our demo environment
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 2=2 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 Name | SQL text | Validation | |
---|---|---|---|
Organization |
|
LOV Oracle | |
Scheduled start from |
|
Date | |
Scheduled start to |
|
Date | |
Order Status |
|
LOV |