ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDC79D2E0530100007F1FF2 BOM Department Y select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null and bd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or bd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by bd.department_code US 8E2FF36EDEEC79D2E0530100007F1FF2 EAM Asset Group Y Y select msiv.concatenated_segments value, mp.organization_code||': '||msiv.description description from mtl_parameters mp, mtl_system_items_vl msiv where ( :$flex$.organization_code is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=msiv.organization_id and msiv.eam_item_type in (1,3) and msiv.serial_number_control_code<>1 and (msiv.organization_id, msiv.inventory_item_id) in (select cii.last_vld_organization_id, cii.inventory_item_id from csi_item_instances cii where sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate)) order by msiv.concatenated_segments, mp.organization_code US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 A6A2412E58EBF30BE053B46B6358C178Y select distinct ow.organization_id, (select msib.segment1 from inv.mtl_system_items_b msib where msib.inventory_item_id = ow.asset_activity_id and msib.organization_id = ow.organization_id) "Activity" ,OW.WORK_ORDER_PM_ACTION_MEANING Action ,OW.WORK_ORDER_PM_TYPE_MEANING "PM Type" ,(select mean.area from apps.mtl_eam_asset_numbers_all_v mean where ow.asset_number = mean.instance_number) Area ,OW.ASSET_NUMBER Asset ,(select mean.concatenated_segments from apps.mtl_eam_asset_numbers_all_v mean where ow.asset_number = mean.instance_number) "Group" ,DECODE(ow.SCHEDULED_START_DATE, NULL,' ',ow.SCHEDULED_START_DATE) "Scheduled Start" ,DECODE(ow.SCHEDULED_COMPLETION_DATE, NULL, ow.WORK_ORDER_COMPLETION_DATE,ow.SCHEDULED_COMPLETION_DATE) "Scheduled Completion" ,NVL(ow.WIP_ENTITY_NAME, ' ') "Work Order" ,OW.DESCRIPTION "Description" ,OW.WO_STATUS_DISP "Order Status" ,OW.PM_NAME "PM Schedule" ,DECODE(ow.WORK_ORDER_START_DATE, NULL, ' ', ow.WORK_ORDER_START_DATE) "Order Start Date" ,DECODE(ow.WORK_ORDER_COMPLETION_DATE, NULL, ' ', ow.WORK_ORDER_COMPLETION_DATE) "Order Completion Date" ,NVL(ow.OWNING_DEPARTMENT_CODE, ' ') "Owning Department" ,OW.PRIORITY_MEANING Priority ,NVL(ow.SHUTDOWN_TYPE_MEANING, ' ') "Shutdown" ,NVL(ow.WORK_ORDER_TYPE_MEANING, ' ') "Order Type" ,OW.ACTIVITY_TYPE_MEANING "Activity Type" from apps.eam_outstanding_work_orders_v ow left join apps.eam_outstanding_work_orders_v ow1 on (ow.asset_activity_id = ow1.asset_activity_id and ow.forecast_id < ow1.forecast_id and OW.SCHEDULED_START_DATE = OW1.SCHEDULED_START_DATE) where 1=1 --and ow.organization_id in (:P_Organization) order by 1,2,8 US EAM Senfor Intl Preventative Maintenance Forecast Planning This program extracts the latest preventative maintenance forecast from the EAM Outstanding Work Orders view for planning purposes. These include details of maintenance orders both in process and completed with order start and end dates. The report can be run by any combination of organization, department, scheduled start dates, asset group and asset; see below. Additional parameters may be added as required. Version Modified on Modified  by   Description  ===== ======== == ====== ========   1.0     04 Feb 2020 Ion Yılmaz     Initial Release Copyright 2020 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). Department: Select the specific owning departments(s) required (optional). Scheduled start from/to: Enter the scheduled start date range (Optional). Asset Group: Select the asset group(s) to be included (Optional). Asset: Select the asset(s) to be included (Optional). 1=1 1 10 1=1 ow.organization_id = :Organization LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code 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 ow.owning_department_code = :DEPARTMENT LOV BOM Department 8E2FF36EDEDC79D2E0530100007F1FF2 Y select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null and bd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or bd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by bd.department_code US Department 3 30 1=1 ow.scheduled_start_date >= :P_SCHED_START_FROM Date US Scheduled start from 4 40 1=1 ow.scheduled_start_date <= :P_SCHED_START_TO Date US Scheduled start to 5 50 1=1 ow.maintenance_object_type=3 and ow.maintenance_object_id in ( select cii0.instance_id from mtl_system_items_b_kfv msibk0, csi_item_instances cii0 where msibk0.concatenated_segments = :asset_group and msibk0.organization_id = cii0.last_vld_organization_id and msibk0.inventory_item_id = cii0.inventory_item_id(+) ) LOV EAM Asset Group 8E2FF36EDEEC79D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, mp.organization_code||': '||msiv.description description from mtl_parameters mp, mtl_system_items_vl msiv where ( :$flex$.organization_code is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=msiv.organization_id and msiv.eam_item_type in (1,3) and msiv.serial_number_control_code<>1 and (msiv.organization_id, msiv.inventory_item_id) in (select cii.last_vld_organization_id, cii.inventory_item_id from csi_item_instances cii where sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate)) order by msiv.concatenated_segments, mp.organization_code US Asset Group 6 60 1=1 ow.asset_number=:Asset LOV Oracle EAM_SRS_IB_ASSET_NUMBER Y select instance_number id, instance_number value, instance_description description from csi_item_instances where last_vld_organization_id in (select organization_id from mtl_parameters mp where mp.maint_organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) and nvl(maintainable_flag,'Y')='Y' and inventory_item_id in (select inventory_item_id from mtl_system_items where eam_item_type in (1,3)) order by instance_number US Asset