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 8E2FF36EDEEB79D2E0530100007F1FF2 EAM Asset Number Y Y select cii.instance_number value, mp.organization_code||': '||msik.concatenated_segments description from mtl_parameters mp, csi_item_instances cii, mtl_system_items_kfv msik where ( :$flex$.organization_code is null and cii.last_vld_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=cii.last_vld_organization_id and sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) and cii.last_vld_organization_id=msik.organization_id and cii.inventory_item_id=msik.inventory_item_id and msik.eam_item_type in (1,3) and msik.serial_number_control_code<>1 order by cii.instance_number US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 558D781C4B2C1039E0530100007FA579 select wdj.organization_code, wdj.wip_entity_name work_order, cii.instance_number asset_number, cii.instance_description, msibk.concatenated_segments asset_group, xxen_util.meaning(msibk.eam_item_type,'MTL_EAM_ASSET_TYPE',700) asset_type, mcbk.concatenated_segments item_category, bd.department_code department, bd.description department_description, mel.location_codes eam_location, --cii.serial_number, wdj.description work_order_description, xxen_util.client_time(wdj.scheduled_start_date) scheduled_start_date, xxen_util.client_time(wdj.scheduled_completion_date) scheduled_completion_date, round((wdj.scheduled_completion_date-wdj.scheduled_start_date)*24,3) duration, decode(ewod.pending_flag,'Y',ewsv.work_order_status||' - '||fnd_message.get_string('EAM','EAM_PENDING_TEXT'),ewsv.work_order_status) work_order_status, &planner_maintenance --xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) status, xxen_util.user_name(wdj.created_by) created_by, xxen_util.client_time(wdj.creation_date) creation_date, xxen_util.user_name(wdj.last_updated_by) last_updated_by, xxen_util.client_time(wdj.last_update_date) last_update_date, xxen_util.meaning(wdj.shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700) shutdown_type, xxen_util.meaning(wdj.priority,'WIP_EAM_ACTIVITY_PRIORITY',700) priority, decode(ewod.pending_flag,'Y','Disabled',decode(wdj.status_type,3,'Complete',4,'Uncomplete','Disabled')) action_code, ppa.segment1 project_number, pt.task_number, wdj.class_code, eps.name pm_schedule_name, xxen_util.meaning(wdj.work_order_type,'WIP_EAM_WORK_ORDER_TYPE',700) work_order_type, xxen_util.meaning(wdj.activity_type,'MTL_EAM_ACTIVITY_TYPE',700) activity_type, xxen_util.meaning(wdj.activity_cause,'MTL_EAM_ACTIVITY_CAUSE',700) activity_cause, xxen_util.meaning(wdj.activity_source,'MTL_EAM_ACTIVITY_SOURCE',700) activity_source, (select msibk.concatenated_segments from mtl_system_items_b_kfv msibk where wdj.primary_item_id=msibk.inventory_item_id and rownum=1) activity_name, decode(efv.failure_code_required,'Y','Y') failure_code_required, efv.failure_description failure, efv.cause_description cause, efv.resolution_description resolution, efv.failure_date, efv.comments, efv.set_name failure_set, nvl(wepb.actual_cost,0) actual_cost, nvl(wepb.estimated_cost,0) estimated_cost, nvl(wepb.variance_cost,0) variance_cost, nvl(wepb.cumulative_actual_cost,0) cumulative_actual_cost, nvl(wepb.cumulative_estimated_cost,0) cumulative_estimated_cost, nvl(wepb.cumulative_variance_cost,0) cumulative_variance_cost, xxen_util.meaning(nvl(wdj.estimation_status,1),'CST_EAM_ESTIMATION_STATUS',700) estimation_status, (select ecm.estimate_number from eam_construction_estimates ecm where ewod.estimate_id=ecm.estimate_id and rownum=1) estimate_number, &columns nvl(sum(wecdv.actual_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) total_cost, nvl(sum(wecdv.actual_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) material_cost, nvl(sum(wecdv.actual_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) labor_cost, nvl(sum(wecdv.actual_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) equipment_cost, nvl(sum(wecdv.estimated_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_total_cost, nvl(sum(wecdv.estimated_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_material_cost, nvl(sum(wecdv.estimated_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_labor_cost, nvl(sum(wecdv.estimated_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_equipment_cost, nvl(sum(wecdv.variance_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_total_cost, nvl(sum(wecdv.variance_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_material_cost, nvl(sum(wecdv.variance_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_labor_cost, nvl(sum(wecdv.variance_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_equipment_cost, wdj.wip_entity_id --ewod.cycle_id, --ewod.seq_id, from ( select mp.organization_code, we.wip_entity_name, mp.maint_organization_id, wdj.* from mtl_parameters mp, wip_entities we, wip_discrete_jobs wdj where 1=1 and wdj.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) and wdj.status_type not in (7,5,12,14,15) and mp.organization_id=we.organization_id and we.entity_type in (6,7) and wdj.maintenance_object_source<>2 and we.wip_entity_id=wdj.wip_entity_id and we.organization_id=wdj.organization_id ) wdj, mtl_system_items_b_kfv msibk, bom_departments bd, pa_projects_all ppa, pa_tasks pt, eam_work_order_details ewod, eam_wo_statuses_v ewsv, eam_pm_schedulings eps, eam_org_maint_defaults eomd, mtl_eam_locations mel, (select cii.* from csi_item_instances cii where sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate)) cii, mtl_categories_b_kfv mcbk, eam_failureinfo_v efv, ( select wepb.organization_id, wepb.wip_entity_id, nvl(sum(wepb.actual_mat_cost)+sum(wepb.actual_lab_cost)+sum(wepb.actual_eqp_cost),0) actual_cost, nvl(sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),0) estimated_cost, nvl(-sum(wepb.actual_mat_cost)-sum(wepb.actual_lab_cost)-sum(wepb.actual_eqp_cost)+sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),0) variance_cost, nvl(sum(wepb.actual_mat_cost )+sum(wepb.actual_lab_cost)+sum(wepb.actual_eqp_cost),nvl(sum(wepb.actual_mat_cost)+sum(wepb.actual_lab_cost)+sum(wepb.actual_eqp_cost),0)) cumulative_actual_cost, nvl(sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),nvl(sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),0)) cumulative_estimated_cost, nvl(-sum(wepb.actual_mat_cost)-sum(wepb.actual_lab_cost)-sum(wepb.actual_eqp_cost)+sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),nvl(-sum(wepb.actual_mat_cost)-sum(wepb.actual_lab_cost)-sum(wepb.actual_eqp_cost)+sum(wepb.system_estimated_mat_cost)+sum(wepb.system_estimated_lab_cost)+sum(wepb.system_estimated_eqp_cost),0)) cumulative_variance_cost from wip_eam_period_balances wepb where (wepb.period_name,wepb.period_set_name) in ( select period_name, to_char(null) period_set_name from org_acct_periods oap where 2=2 union all select gp.period_name, gp.period_set_name from gl_periods gp where 3=3 and gp.adjustment_period_flag='N' ) group by wepb.organization_id, wepb.wip_entity_id ) wepb, ( select distinct wecdv.organization_id, wecdv.wip_entity_id, &columns nvl(sum(wecdv.actual_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) actual_total_cost, nvl(sum(wecdv.actual_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) actual_material_cost, nvl(sum(wecdv.actual_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) actual_labor_cost, nvl(sum(wecdv.actual_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) actual_equipment_cost, nvl(sum(wecdv.estimated_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_total_cost, nvl(sum(wecdv.estimated_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_material_cost, nvl(sum(wecdv.estimated_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_labor_cost, nvl(sum(wecdv.estimated_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) estimated_equipment_cost, nvl(sum(wecdv.variance_total_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_total_cost, nvl(sum(wecdv.variance_material_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_material_cost, nvl(sum(wecdv.variance_labor_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_labor_cost, nvl(sum(wecdv.variance_equipment_cost) over (partition by wecdv.organization_id, wecdv.wip_entity_id &partition_by),0) variance_equipment_cost from wip_eam_cost_details_v wecdv where (wecdv.period_set_name, wecdv.period_name) in ( select to_char(null) period_set_name, period_name from org_acct_periods oap where 2=2 union all select gp.period_set_name, gp.period_name from gl_periods gp where 3=3 and gp.adjustment_period_flag='N' ) ) wecdv where 4=4 and nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msibk.inventory_item_id(+) and wdj.organization_id=msibk.organization_id(+) and wdj.owning_department=bd.department_id(+) and wdj.project_id=ppa.project_id(+) and wdj.task_id=pt.task_id(+) and wdj.wip_entity_id=ewod.wip_entity_id and wdj.organization_id=ewod.organization_id and ewsv.status_id=ewod.user_defined_status_id(+) and wdj.pm_schedule_id=eps.pm_schedule_id(+) and decode(wdj.maintenance_object_type,3,wdj.maintenance_object_id,null)=eomd.object_id(+) and wdj.maint_organization_id=eomd.organization_id(+) and eomd.object_type(+)=50 and eomd.area_id=mel.location_id(+) and decode(wdj.maintenance_object_type,3,wdj.maintenance_object_id,null)=cii.instance_id(+) and cii.category_id=mcbk.category_id(+) and wdj.wip_entity_id=efv.wip_entity_id(+) and wdj.organization_id=wepb.organization_id(+) and wdj.wip_entity_id=wepb.wip_entity_id(+) and wdj.organization_id=wecdv.organization_id(+) and wdj.wip_entity_id=wecdv.wip_entity_id(+) order by wdj.organization_code, wdj.scheduled_start_date desc, wdj.wip_entity_name Y #,##0.00;[Red]-#,##0.00 AR EAM Work Orders أوامر عمل إدارة أصول المؤسسة بما في ذلك معلومات الأصول والتكلفة D EAM Work Orders Enterprise Asset Management Arbeitsaufträge mit Asset- und Kosteninformationen E EAM Work Orders Órdenes de trabajo de gestión de activos de la empresa que incluyen información sobre los activos y los costes F EAM Work Orders Bons de travail pour la gestion des actifs de l'entreprise, y compris les informations sur les actifs et les coûts I EAM Work Orders Ordini di lavoro per la gestione delle risorse aziendali, comprese le informazioni su risorse e costi JA EAM Work Orders 資産とコスト情報を含む企業の資産管理作業指示書 KO EAM Work Orders 자산 및 비용 정보를 포함한 엔터프라이즈 자산 관리 작업 주문 PTB EAM Work Orders Ordens de trabalho de gerenciamento de ativos da empresa, incluindo informações sobre ativos e custos RU EAM Work Orders Рабочие задания по управлению активами предприятия, включая информацию об активах и расходах S EAM Work Orders Arbetsorder för företagshanteringstillgångar inklusive tillgångs- och kostnadsinformation TR EAM Work Orders Varlık ve maliyet bilgileri dahil kurumsal varlık yönetimi iş emirleri US EAM Work Orders Enterprise asset management work orders including asset and cost information ZHS EAM Work Orders 企业资产管理工作单，包括资产和成本信息 Enginatics R12 only &columns &partition_by &planner_maintenance 1=1 2=2 3=3 4=4 1 -10 &planner_maintenance select 'xxen_util.meaning(ewod.planner_maintenance,''EAM_PLANNER'',700) planner,' text from all_tab_columns atc where atc.column_name='PLANNER_MAINTENANCE' and atc.table_name='EAM_WORK_ORDER_DETAILS' and atc.owner='EAM' Char 1 F Colonne de maintenance du planificateur US Planner Maintenance Column 2 10 1=1 mp.organization_code=:organization_code 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 select mp.organization_code from mtl_parameters mp where mp.eam_enabled_flag='Y' and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and mp.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) F Code de l'organisation US Organization Code 3 20 4=4 bd.department_code=:department_code 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 F Département US Department 4 30 1=1 wdj.maintenance_object_type=3 and wdj.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 F Groupe d'actifs US Asset Group 5 40 4=4 wdj.maintenance_object_type=3 and wdj.maintenance_object_id in (select cii0.instance_id from csi_item_instances cii0 where cii0.instance_number like :asset_number) LOV EAM Asset Number 8E2FF36EDEEB79D2E0530100007F1FF2 Y Y select cii.instance_number value, mp.organization_code||': '||msik.concatenated_segments description from mtl_parameters mp, csi_item_instances cii, mtl_system_items_kfv msik where ( :$flex$.organization_code is null and cii.last_vld_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=cii.last_vld_organization_id and sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) and cii.last_vld_organization_id=msik.organization_id and cii.inventory_item_id=msik.inventory_item_id and msik.eam_item_type in (1,3) and msik.serial_number_control_code<>1 order by cii.instance_number F Numéro de l'actif US Asset Number 6 50 1=1 wdj.scheduled_start_date>=:sched_start_date_from Date F Date de début prévue du US Scheduled Start Date From 7 60 1=1 wdj.scheduled_start_date<:sched_start_date_to+1 Date F Date de début prévue jusqu'au US Scheduled Start Date To 8 70 1=1 wdj.creation_date>=:creation_date_from Date F Date de création du bon de travail De US Work Order Creation Date From 9 80 1=1 wdj.creation_date<:creation_date_to+1 Date F Date de création du bon de travail au US Work Order Creation Date To 10 90 4=4 ewsv.work_order_status=:work_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 F Statut du bon de travail US Work Order Status 11 100 4=4 ewod.planner_maintenance=xxen_util.lookup_code(:planner,'EAM_PLANNER',700) LOV custom Y select ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='EAM_PLANNER' order by ml.meaning F Planificateur US Planner 12 110 1=1 wdj.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Bon de travail créé par US Work Order Created By 13 120 2=2 oap.period_start_date>=:period_date_from Date F Période de coût à partir de la date US Cost Period from Date 14 3=3 gp.start_date>=:period_date_from F Période de coût à partir de la date US Cost Period from Date 15 130 2=2 oap.schedule_close_date<=:period_date_to Date F Coût Période à ce jour US Cost Period to Date 16 3=3 gp.end_date<=:period_date_to F Coût Période à ce jour US Cost Period to Date 17 140 &partition_by , wecdv.period_set_name, wecdv.period_name, wecdv.cost_category_meaning LOV custom Y select 'Period' value, '' description from dual union all select 'Cost Category' value, '' description from dual union all select 'Period and Cost Category' value, '' description from dual Period and Cost Category Cost Category F Niveau de détail des coûts US Cost Detail Level 18 &partition_by , wecdv.cost_category_meaning Cost Category F Niveau de détail des coûts US Cost Detail Level 19 &partition_by , wecdv.period_set_name, wecdv.period_name Period F Niveau de détail des coûts US Cost Detail Level 20 &columns wecdv.cost_category_meaning, Cost Category F Niveau de détail des coûts US Cost Detail Level 21 &columns wecdv.period_set_name, wecdv.period_name, Period F Niveau de détail des coûts US Cost Detail Level 22 &columns wecdv.period_set_name, wecdv.period_name, wecdv.cost_category_meaning, Period and Cost Category F Niveau de détail des coûts US Cost Detail Level :$flex$.organization_code Organization Code Asset Group :$flex$.organization_code Organization Code Asset Number :$flex$.organization_code Organization Code Department