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 8E2FF36EDF0E79D2E0530100007F1FF2 BOM Resource Code Y select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 A5D28E233AA6C051E053B46B635851C7Y select distinct mp.organization_code, we.wip_entity_name, xxen_util.meaning(wdj.firm_planned_flag,'SYS_YES_NO',700) firm_planned_flag, bd2.department_code owning_department, we.description, cii.instance_number asset, cii.instance_description descriptive_text, msib.concatenated_segments asset_group, xxen_util.meaning(wdj.priority,'WIP_EAM_ACTIVITY_PRIORITY',700) priority, mel.location_codes area, worp.op_seq_num, bd.department_code assigned_department, xxen_util.meaning(worp.shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700) shutdown_type, br.resource_code, worp.assigned_units, xxen_util.meaning(ewod.material_shortage_flag,'EAM_MATERIAL_SHORTAGE',700) material_shortage_flag, xxen_util.meaning(ewod.workflow_type,'EAM_WORKFLOW_TYPE',700) workflow_type, xxen_util.meaning(ewod.warranty_claim_status,'EAM_WARRANTY_STATUS',700) warranty_status, ((select papf.full_name from per_all_people_f papf,bom_resource_employees bre,bom_resources br1 where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.person_id=bre.person_id and bre.instance_id=worp.instance_id and bre.resource_id=br.resource_id and br1.resource_id=bre.resource_id and br1.organization_id=worp.organization_id and bre.organization_id=worp.organization_id and br1.resource_type=2) union (select msik.concatenated_segments from mtl_system_items_b_kfv msik, bom_resource_equipments bre,bom_resources br2 where bre.inventory_item_id=msik.inventory_item_id and msik.item_type='EQ' and bre.instance_id =worp.instance_id and bre.resource_id=br.resource_id and br2.resource_id=bre.resource_id and br2.organization_id=worp.organization_id and bre.organization_id=worp.organization_id and br2.resource_type=1)) instance_name, worp.res_start_date, worp.res_completion_date, round((worp.res_completion_date- worp.res_start_date)*24) duration, round((wdj.scheduled_completion_date-wdj.scheduled_start_date)*24) workorder_duration, eam_eamwsrep_xmlp_pkg.days(res_start_date,res_completion_date) days, eam_eamwsrep_xmlp_pkg.cp_1_p cp_1, eam_eamwsrep_xmlp_pkg.cp_2_p cp_2, eam_eamwsrep_xmlp_pkg.cp_3_p cp_3, eam_eamwsrep_xmlp_pkg.cp_4_p cp_4, eam_eamwsrep_xmlp_pkg.cp_5_p cp_5, eam_eamwsrep_xmlp_pkg.cp_6_p cp_6, eam_eamwsrep_xmlp_pkg.cp_7_p cp_7, eam_eamwsrep_xmlp_pkg.cp_8_p cp_8, wdj.scheduled_start_date, wdj.scheduled_completion_date, worp.op_start_date, worp.op_end_date, decode(:p_sort_by,1,we.wip_entity_name,2,wdj.scheduled_start_date,3,wdj.scheduled_completion_date,4,round(wdj.scheduled_completion_date-wdj.scheduled_start_date),5,wdj.asset_number,6,msib.concatenated_segments,7,xxen_util.meaning(wdj.priority,'WIP_EAM_ACTIVITY_PRIORITY',700),8,mel.location_codes,we.wip_entity_name) sort_by from wip_entities we, wip_discrete_jobs wdj, ( select distinct wo.wip_entity_id wip_entity_id, wo.operation_seq_num op_seq_num, wo.department_id, wo.organization_id, wo.first_unit_start_date op_start_date, wo.last_unit_completion_date op_end_date, wor.assigned_units, wor.resource_id, wor.start_date res_start_date, wor.completion_date res_completion_date, wor.resource_seq_num,wori.instance_id,wo.operation_completed,wo.shutdown_type from wip_operations wo, wip_operation_resources wor, wip_op_resource_instances wori where wo.wip_entity_id=wor.wip_entity_id(+) and wo.organization_id=wor.organization_id(+) and wo.operation_seq_num=wor.operation_seq_num(+) and wor.operation_seq_num=wori.operation_seq_num(+) and wor.resource_seq_num=wori.resource_seq_num(+) and wor.wip_entity_id=wori.wip_entity_id(+) ) worp, eam_work_order_details ewod, bom_resources br, bom_departments bd, bom_departments bd2, mtl_parameters mp, mtl_system_items_b_kfv msib, csi_item_instances cii, eam_org_maint_defaults eomd, mtl_eam_locations mel 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 we.wip_entity_id=wdj.wip_entity_id and we.organization_id=wdj.organization_id and wdj.status_type=3 and /*released*/ wdj.wip_entity_id=worp.wip_entity_id(+) and nvl(worp.operation_completed,'N')='N' and wdj.organization_id=ewod.organization_id and wdj.wip_entity_id=ewod.wip_entity_id and worp.organization_id=br.organization_id(+) and worp.resource_id=br.resource_id(+) and worp.department_id=bd.department_id and wdj.owning_department=bd2.department_id(+) and wdj.organization_id=mp.maint_organization_id and mp.organization_id=msib.organization_id and nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msib.inventory_item_id and decode(wdj.maintenance_object_type,3,wdj.maintenance_object_id, null)=cii.instance_id(+) and eomd.object_type(+)=50 and (eomd.organization_id is null or eomd.organization_id=wdj.organization_id) and cii.instance_id=eomd.object_id(+) and eomd.area_id=mel.location_id(+) order by organization_code, sort_by, wip_entity_name, owning_department, firm_planned_flag, description, asset EAM EAMWSREP_XML AR EAM Weekly Schedule Application: إدارة أصول المؤسسات Source: تقرير الجدول الأسبوعي في EAM (بتنسيق XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG D EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM Wochenplan (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG E EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM: Programa Semanal (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG F EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM - Programme hebdomadaire (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG I EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM: rapporto Programma settimanale (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG JA EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM週次スケジュール・レポート(XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG KO EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM 주간 스케줄 보고서(XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG PTB EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM - Relatório da Programação Semanal (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG RU EAM Weekly Schedule Application: Управление активами предприятия Source: Еженедельный график УАП (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG S EAM Weekly Schedule Application: Enterprise Asset Management Source: EAM: Veckoplan - rapport (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG TR EAM Weekly Schedule Application: Kurumsal Varlık Yönetimi Source: EAM Haftalık Çizelge Raporu (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG US EAM Weekly Schedule Based on Oracle standard's EAM Weekly Schedule report Application: Enterprise Asset Management Source: EAM Weekly Schedule report (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG ZHS EAM Weekly Schedule Application: 企业资产管理系统 Source: EAM 每周计划报表 (XML) Short Name: EAMWSREP_XML DB package: EAM_EAMWSREP_XMLP_PKG Enginatics R12 only 1=1 :cp_1 :cp_11 :cp_12 :cp_13 :cp_14 :cp_15 :cp_16 :cp_17 :cp_2 :cp_3 :cp_4 :cp_5 :cp_6 :cp_7 :cp_8 :p_area :p_asset :p_assigned_dept :p_conc_request_id :p_dis_rbitem :p_dis_sort_by :p_dis_start_date :p_instance :p_org_id :p_org_name :p_owning_department :p_rebuild_item :p_resource :p_shutdown_type :p_sort_by :p_week_start_date :p_week_starting 1 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 2 20 1=1 bd2.department_code=:owning_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 AR القسم D Verantwortliche Abteilung E Departamento Propietario F Département propriétaire I Reparto responsabile JA 所有部門 KO 소유 부서 PTB Depto. Responsável RU Отдел-владелец S Ägande avdelning TR Sahip Olan Departman US Owning Department ZHS 所属部门 3 30 1=1 bd.department_code=:assigned_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 AR القسم المخصص D Zugeordnete Abteilung E Departamento Asignado F Département assigné I Reparto assegnato JA 割当部門 KO 지정 부서 PTB Departamento Atribuído RU Назн. отдел S Tilldelad avdelning TR Atanan Departman US Assigned Department ZHS 分配的部门 4 40 1=1 wdj.scheduled_start_date<fnd_date.displaydt_to_date(:p_week_start_date)+7 and wdj.scheduled_completion_date>=fnd_date.displaydt_to_date(:p_week_start_date) and worp.op_start_date<fnd_date.displaydt_to_date(:p_week_start_date)+7 and worp.op_end_date>=fnd_date.displaydt_to_date(:p_week_start_date) and worp.res_start_date<fnd_date.displaydt_to_date(:p_week_start_date)+7 and worp.res_completion_date>=fnd_date.displaydt_to_date(:p_week_start_date) LOV custom Y select bcwsd.week_start_date-1 value, null description from bom_cal_week_start_dates bcwsd where :$flex$.date_from is null and :$flex$.date_to is null and bcwsd.calendar_code=( select mp.calendar_code from mtl_parameters mp where mp.organization_code=:$flex$.organization_code or :$flex$.organization_code is null and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) order by value desc select week_start_date-1 from bom_cal_week_start_dates where calendar_code= (select calendar_code from mtl_parameters where organization_id =fnd_profile.value('MFG_ORGANIZATION_ID'))and week_start_date <=sysdate and week_start_date >sysdate-7 AR بداية الأسبوع D Woche ab E Inicio de Semana F Début de la semaine I Inizio settimana JA 週開始 KO 시작 주 PTB Início da Semana RU Начало недели S Veckan börjar TR Hafta Başlangıcı US Week Starting ZHS 周起始日期 5 50 1=1 wdj.scheduled_completion_date>=:date_from and worp.op_end_date>=:date_from and nvl(worp.res_completion_date,:date_from)>=:date_from Date F Date du US Date from 6 60 1=1 wdj.scheduled_start_date<:date_to+1 and worp.op_start_date<:date_to+1 and nvl(worp.res_start_date,:date_to)<:date_to+1 Date last_day(:$flex$.date_from) F Date à US Date to 7 70 1=1 mel.location_codes=:area LOV Oracle EAM_SRS_LOCATION_CODE_OPT Y select location_codes id, location_codes value, description description from mtl_eam_locations where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by location_codes AR المنطقة D Bereich E Área F Zone JA エリア KO 지역 PTB Área RU Область S Område TR Alan US Area ZHS 地区 8 80 1=1 cii.instance_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 AR الأصل D Anlage E Activo F Actif JA 資産 KO 자산 PTB Ativo RU Актив S Anläggning TR Varlık US Asset ZHS 资产 9 90 1=1 wdj.rebuild_item_id=:rebuild_item LOV Oracle EAM_SRS_REBUILD_ITEM Y select inventory_item_id id, concatenated_segments value, null description from mtl_system_items_b_kfv where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and eam_item_type=3 order by concatenated_segments AR صنف إعادة البناء D Umbauartikel E Artículo de Regeneración F Poste de reconstruction I Articolo ricostruzione JA 再作成品目 KO 재구성 품목 PTB Item Reparável RU Ремонтируемая позиция S Återskapa artikel TR Yenilenebilir Kalem US Rebuild Item ZHS 修复件 10 100 1=1 worp.shutdown_type=xxen_util.lookup_code(:shutdown_type,'BOM_EAM_SHUTDOWN_TYPE',700) LOV Oracle EAM_OPN_SHUTDOWNTYPE_OPT Y select meaning id, meaning value, meaning description from mfg_lookups where lookup_type='BOM_EAM_SHUTDOWN_TYPE' order by lookup_code AR نوع الإغلاق D Art der Außerbetriebnahme E Tipo de Cierre F Type d'arrêt I Tipo di fermo JA 停止タイプ KO 종료 유형 PTB Tipo de Desativação RU Тип завершения S Avstängningstyp TR Kapatma Tipi US Shutdown Type ZHS 关闭类型 11 110 1=1 br.resource_code=:resource LOV BOM Resource Code 8E2FF36EDF0E79D2E0530100007F1FF2 Y select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code AR المورد D Ressource E Recurso F Ressources I Risorsa JA 生産資源 KO 자원 PTB Recurso RU Ресурс S Resurs TR Kaynak US Resource ZHS 资源 12 120 1=1 worp.instance_id = ((select bre.instance_id from per_all_people_f papf,bom_resource_employees bre,bom_resources br1 where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.person_id = bre.person_id and bre.instance_id =worp.instance_id and bre.resource_id =br.resource_id and br1.resource_id=bre.resource_id and br1.organization_id=worp.organization_id and bre.organization_id = worp.organization_id and papf.full_name = :instance and br1.resource_type=2) union (select bre.instance_id from mtl_system_items_kfv msik, bom_resource_equipments bre,bom_resources br2 where bre.inventory_item_id = msik.inventory_item_id and msik.item_type = 'EQ' and bre.instance_id =worp.instance_id and bre.resource_id = br.resource_id and br2.resource_id=bre.resource_id and br2.organization_id=worp.organization_id and bre.organization_id = worp.organization_id and br2.resource_type=1 and msik.concatenated_segments =:instance)) LOV Oracle EAM_RES_INSTANCE_NAME Y select instance id, instance value, null description from eam_instances where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by instance AR الطبعة D Instanz E Instancia I Istanza JA インスタンス KO 인스턴스 PTB Instância RU Экземпляр S Instans TR Örnek US Instance ZHS 例程 13 130 :p_sort_by LOV Oracle EAM_WSREP_SORT_BY Y select m2.lookup_code id, m2.meaning value, null description from mfg_lookups m2 where m2.lookup_type='EAM_WSREP_SORT_BY' order by lookup_code 1 AR فرز بواسطة D Sortieren nach E Ordenar por F Trier par I Ordina per JA ソート・キー KO 정렬 기준 PTB Classificar por RU Сортировка S Sortera efter TR Sıralama Esası US Sort By ZHS 排序依据 :$flex$.date_from Date from Y Date to :$flex$.date_from Date from Y Week Starting :$flex$.date_to Date to Y Week Starting :$flex$.organization_code Organization Code Assigned Department :$flex$.organization_code Organization Code Owning Department :$flex$.organization_code Organization Code Resource :$flex$.organization_code Organization Code Week Starting