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 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 559FD59BFCB967CBE0530100007F047F select cii.organization_code, cii.instance_number asset_number, cii.instance_description, msiv.concatenated_segments asset_group, msiv.description asset_group_description, cii0.instance_number parent_asset_number, msibk0.concatenated_segments parent_asset_group, fab.asset_number fixed_asset_number, mcbk.concatenated_segments category, eomd.accounting_class_code accounting_class, nvl(cii.maintainable_flag,'Y') maintainable, msn2.serial_number equipment_serial_number, null asset_route, cii.supplier_warranty_exp_date, efs.set_name failure_set, cii.inv_subinventory_name subinventory, milk.concatenated_segments locator, mel.location_codes area, case when cii.location_type_code in ('HZ_LOCATIONS','PO','WIP','PROJECT','IN_TRANSIT','HZ_PARTY_SITES','VENDOR_SITE') then hl.address1||','||hl.address2||','||hl.address3||','||hl.address4||','||hl.city||','||hl.state||','||hl.postal_code||','||hl.country else hla.address_line_1||','||hla.address_line_2||','||hla.address_line_3||','||hla.region_1||','||hla.postal_code||','||hla.country end location, xxen_util.meaning(cii.asset_criticality_code,'MTL_EAM_ASSET_CRITICALITY',700) criticality, bd.department_code owning_department, pla.location_code, pla.location_alias from ( select mp.organization_code, mp.maint_organization_id, case when cii.location_type_code in ('HZ_LOCATIONS','PO','WIP','PROJECT','IN_TRANSIT') then cii.location_id when cii.location_type_code='HZ_PARTY_SITES' then (select hps.location_id from hz_party_sites hps where cii.location_id=hps.party_site_id) when cii.location_type_code='VENDOR_SITE' then (select assa.location_id from ap_supplier_sites_all assa where cii.location_id=assa.vendor_site_id) end hl_location_id, cii.* from mtl_parameters mp, csi_item_instances cii where 1=1 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) and mp.organization_id=cii.last_vld_organization_id ) cii, mtl_system_items_vl msiv, mtl_item_locations_kfv milk, eam_org_maint_defaults eomd, bom_departments bd, mtl_eam_locations mel, mtl_categories_b_kfv mcbk, (select cia.* from csi_i_assets cia where sysdate<=nvl(cia.active_end_date,sysdate)) cia, fa_additions_b fab, pn_locations_all pla, mtl_serial_numbers msn, (select mog.* from mtl_object_genealogy mog where mog.genealogy_type=5 and sysdate between mog.start_date_active and nvl(mog.end_date_active,sysdate)) mog, mtl_serial_numbers msn0, mtl_serial_numbers msn2, csi_item_instances cii0, mtl_system_items_b_kfv msibk0, ( select efsa.inventory_item_id, efs.set_name from eam_failure_set_associations efsa, eam_failure_sets efs where efsa.set_id=efs.set_id and sysdate<=nvl(efsa.effective_end_date,sysdate) and sysdate<=nvl(efs.effective_end_date,sysdate) ) efs, hz_locations hl, hr_locations_all hla where 2=2 and sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) and cii.last_vld_organization_id=msiv.organization_id and cii.inventory_item_id=msiv.inventory_item_id and msiv.eam_item_type in (1,3) and msiv.serial_number_control_code<>1 and cii.inv_locator_id=milk.inventory_location_id(+) and cii.instance_id=eomd.object_id(+) and maint_organization_id=eomd.organization_id(+) and eomd.object_type(+)=50 and eomd.owning_department_id=bd.department_id(+) and eomd.area_id=mel.location_id(+) and cii.category_id=mcbk.category_id(+) and cii.instance_id=cia.instance_id(+) and cia.fa_asset_id=fab.asset_id(+) and cii.pn_location_id=pla.location_id(+) and cii.serial_number=msn.serial_number(+) and cii.inventory_item_id=msn.inventory_item_id(+) and msn.gen_object_id=mog.object_id(+) and mog.parent_object_id=msn0.gen_object_id(+) and msn0.inventory_item_id=cii0.inventory_item_id(+) and msn0.serial_number=cii0.serial_number(+) and cii0.last_vld_organization_id=msibk0.organization_id(+) and cii0.inventory_item_id=msibk0.inventory_item_id(+) and cii.equipment_gen_object_id=msn2.gen_object_id(+) and cii.inventory_item_id=efs.inventory_item_id(+) and case when cii.location_type_code in ('HZ_LOCATIONS','PO','WIP','PROJECT','IN_TRANSIT','HZ_PARTY_SITES','VENDOR_SITE') then cii.hl_location_id end=hl.location_id(+) and case when cii.location_type_code in ('INVENTORY','INTERNAL_SITE') then cii.location_id end=hla.location_id(+) Y AR EAM Assets تفاصيل أصول إدارة أصول المؤسسة مثل الموقع والقسم وما إلى ذلك. D EAM Assets Enterprise Asset Management Asset-Details wie Standort, Abteilung usw. E EAM Assets Gestión de activos de la empresa detalles de los activos como la ubicación, el departamento, etc. F EAM Assets Gestion des actifs de l'entreprise : détails sur les actifs tels que le lieu, le département, etc. I EAM Assets Gestione delle risorse aziendali dettagli delle risorse come la posizione, il dipartimento, ecc. JA EAM Assets 場所、部門などのエンタープライズ資産管理資産の詳細 KO EAM Assets 위치, 부서 등과 같은 엔터프라이즈 자산 관리 자산 세부 정보 PTB EAM Assets Detalhes do patrimônio de gestão de ativos da empresa, tais como localização, departamento, etc. RU EAM Assets Подробности управления активами предприятия, такие как местоположение, отдел и т.д. S EAM Assets Information om tillgångsförvaltning för företag som plats, avdelning etc. TR EAM Assets Konum, departman vb. Gibi kurumsal varlık yönetimi varlık ayrıntıları US EAM Assets Enterprise asset management asset details such as location, department etc. ZHS EAM Assets 企业资产管理资产详情，如位置、部门等。 Enginatics R12 only 1=1 2=2 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 2=2 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 3 30 2=2 msiv.concatenated_segments=:asset_group 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 4 40 1=1 cii.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 :$flex$.organization_code Organization Code Asset Group :$flex$.organization_code Organization Code Asset Number :$flex$.organization_code Organization Code Department