ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A81BE7BC615891F5E053B46B6358FE3F 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 A7813C36ACADFEBCE053B46B63580ECB US EAM Senfor Intl Work Order Details Extract for multiple activity assignments 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 (iyilmaz@senfor-intl.com.tr) 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). EAM Senfor Intl 1=1 1 10 1=1 ecwo.organization_id=(select organization_id from apps.mtl_parameters where organization_code = :P_ORGANIZATION) LOV Oracle INV_SRS_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description coalesce( (select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')), (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and rownum=1) ) Y US Organization 2 20 1=1 ecwo.scheduled_start_date>=:P_SCHED_START_FROM Date US Scheduled start from 3 30 1=1 ecwo.scheduled_start_date<=:P_SCHED_START_TO Date US Scheduled start to 4 40 1=1 ecwo.user_defined_status_disp = :P_ORDER_STATUS LOV custom Y select EWSV.WORK_ORDER_STATUS value, EWSV.System_status_desc Description from EAM_WO_STATUSES_V EWSV where EWSV.SYSTEM_STATUS in (1,3,4,6,17) and EWSV.ENABLED_FLAG='Y' ORDER BY EWSV.SYSTEM_STATUS, EWSV.WORK_ORDER_STATUS US Order Status