ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 8E2FF36EDEA379D2E0530100007F1FF2 HR Organization Classification Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ORG_CLASS' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDE9979D2E0530100007F1FF2 HR Organization Name Y select haouv.name value, haouv0.name||': '|| (select distinct listagg(flvv.meaning,', ') within group (order by flvv.meaning) over (partition by hoi.organization_id) classification from hr_organization_information hoi, fnd_lookup_values_vl flvv where haouv.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information2='Y' and hoi.org_information1=flvv.lookup_code(+) and flvv.lookup_type(+)='ORG_CLASS' and flvv.view_application_id(+)=3 and flvv.security_group_id(+)=0 ) description from hr_all_organization_units_vl haouv0, hr_all_organization_units_vl haouv where haouv0.organization_id=haouv.business_group_id order by haouv.name US 8E2FF36EDE8779D2E0530100007F1FF2 HR Organization Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ORG_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDE9B79D2E0530100007F1FF2 PER Business Group Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8036A08ACE0530100007FEB91 select haouv0.name business_group, ftv.territory_short_name country, hla.town_or_city city, xxen_util.meaning(haouv.type,'ORG_TYPE',3) type, haouv.name organization, mp.organization_code, decode(haouv.internal_external_flag,'EXT','External','INT','Internal') internal_or_external, &col_classification decode(haouv.head_count,0,null,haouv.head_count) head_count, hla.location_code, nvl2(hla.address_line_1,hla.address_line_1||', ','')|| nvl2(hla.address_line_2,hla.address_line_2||', ','')|| nvl2(hla.address_line_3,hla.address_line_3||', ','')|| nvl2(hla.region_2,hla.region_2||', ','') address, hla.postal_code, &col_attributes haouv.date_to, xxen_util.user_name(haouv.created_by) created_by, xxen_util.client_time(haouv.creation_date) creation_date, xxen_util.user_name(haouv.last_updated_by) last_updated_by, xxen_util.client_time(haouv.last_update_date) last_update_date, haouv.organization_id from ( select (select count(distinct paaf.person_id) from per_all_assignments_f paaf where haouv.organization_id=paaf.organization_id and paaf.assignment_type in ('E','C') and paaf.primary_flag='Y' and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date) head_count, haouv.* from hr_all_organization_units_vl haouv ) haouv, hr_all_organization_units_vl haouv0, hr_locations_all hla, fnd_territories_vl ftv, (select xxen_util.meaning(hoi.org_information1,'ORG_CLASS',3) classification, hoi.* from hr_organization_information hoi where '&show_classification'='Y' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') hoi, ( select fdfcuv.application_id, fdfcuv.descriptive_flexfield_name, fdfcuv.application_column_name, fdfcuv.column_seq_num, fdfcuv.form_left_prompt attribute_name, decode(fdfcuv.application_column_name, 'ORG_INFORMATION1',hoi.org_information1, 'ORG_INFORMATION2',hoi.org_information2, 'ORG_INFORMATION3',hoi.org_information3, 'ORG_INFORMATION4',hoi.org_information4, 'ORG_INFORMATION5',hoi.org_information5, 'ORG_INFORMATION6',hoi.org_information6, 'ORG_INFORMATION7',hoi.org_information7, 'ORG_INFORMATION8',hoi.org_information8, 'ORG_INFORMATION9',hoi.org_information9, 'ORG_INFORMATION10',hoi.org_information10, 'ORG_INFORMATION11',hoi.org_information11, 'ORG_INFORMATION12',hoi.org_information12, 'ORG_INFORMATION13',hoi.org_information13, 'ORG_INFORMATION14',hoi.org_information14, 'ORG_INFORMATION15',hoi.org_information15, 'ORG_INFORMATION16',hoi.org_information16, 'ORG_INFORMATION17',hoi.org_information17, 'ORG_INFORMATION18',hoi.org_information18, 'ORG_INFORMATION19',hoi.org_information19, 'ORG_INFORMATION20',hoi.org_information20 ) system_value, (select distinct listagg(hoi0.classification,', ') within group (order by hoi0.classification) over (partition by hoi.organization_id) info_class from hr_org_info_types_by_class hoitbc, (select xxen_util.meaning(hoi.org_information1,'ORG_CLASS',3) classification, hoi.* from hr_organization_information hoi) hoi0 where hoi.org_information_context=hoitbc.org_information_type and hoi.organization_id=hoi0.organization_id and hoi0.org_information_context='CLASS' and hoi0.org_information2='Y' and hoi0.org_information1=hoitbc.org_classification ) info_class, hoit.displayed_org_information_type information_type, hoi.*, hoi.rowid row_id from hr_organization_information hoi, fnd_descr_flex_col_usage_vl fdfcuv, hr_org_information_types hoit where 2=2 and '&show_attributes'='Y' and hoi.org_information_context<>'CLASS' and hoi.org_information_context=fdfcuv.descriptive_flex_context_code and fdfcuv.application_id=800 and fdfcuv.descriptive_flexfield_name='Org Developer DF' and hoi.org_information_context=hoit.org_information_type(+) ) x, mtl_parameters mp where 1=1 and haouv.business_group_id=haouv0.organization_id(+) and haouv.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and haouv.organization_id=hoi.organization_id(+) and haouv.organization_id=x.organization_id(+) and haouv.organization_id=mp.organization_id(+) order by haouv0.name, ftv.territory_short_name, type, haouv.name, hoi.classification, x.info_class, x.information_type, x.org_information_id, x.column_seq_num Y AR PER Organizations تقرير بيانات رئيسي يوضح المنظمات والتصنيفات وتفاصيل العنوان وسمات المعلومات الإضافية. D PER Organizations Stammdatenbericht mit Organisationen, Klassifizierungen, Adressdetails und zusätzlichen Informationsattributen. E PER Organizations Informe de datos maestros que muestra organizaciones, clasificaciones, detalles de direcciones y atributos de información adicional. F PER Organizations Rapport sur les données de base indiquant les organisations, les classifications, les détails des adresses et les attributs d'informations supplémentaires. I PER Organizations Rapporto sui dati anagrafici che mostra le organizzazioni, le classificazioni, i dettagli degli indirizzi e gli attributi delle informazioni aggiuntive. JA PER Organizations 組織、分類、住所の詳細、追加情報の属性を示すマスターデータレポート。 KO PER Organizations 조직, 분류, 주소 세부 정보 및 추가 정보 속성을 보여주는 마스터 데이터 보고서. PTB PER Organizations Relatório de dados mestre mostrando organizações, classificações, detalhes de endereço e atributos de informações adicionais. RU PER Organizations Отчет об основных данных, показывающий организации, классификации, адресные данные и дополнительные информационные атрибуты. S PER Organizations Huvuddatarapport som visar organisationer, klassificeringar, adressuppgifter och ytterligare attribut för information. TR PER Organizations Kuruluşları, sınıflandırmaları, adres ayrıntılarını ve ek bilgi özelliklerini gösteren ana veri raporu. US PER Organizations Master data report showing organizations, classifications, address details and additional information attributes. ZHS PER Organizations 主数据报告显示组织、分类、地址详情和其他信息属性。 Enginatics &col_attributes &col_classification &show_attributes &show_classification 1=1 2=2 1 10 1=1 haouv0.name=:business_group LOV PER Business Group 8E2FF36EDE9B79D2E0530100007F1FF2 Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name F Groupe d'entreprises US Business Group 2 20 1=1 haouv.name=:org_name LOV HR Organization Name 8E2FF36EDE9979D2E0530100007F1FF2 Y select haouv.name value, haouv0.name||': '|| (select distinct listagg(flvv.meaning,', ') within group (order by flvv.meaning) over (partition by hoi.organization_id) classification from hr_organization_information hoi, fnd_lookup_values_vl flvv where haouv.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information2='Y' and hoi.org_information1=flvv.lookup_code(+) and flvv.lookup_type(+)='ORG_CLASS' and flvv.view_application_id(+)=3 and flvv.security_group_id(+)=0 ) description from hr_all_organization_units_vl haouv0, hr_all_organization_units_vl haouv where haouv0.organization_id=haouv.business_group_id order by haouv.name F Organisation US Organization Name 3 30 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name F Pays US Country 4 40 1=1 haouv.type=xxen_util.lookup_code(:type,'ORG_TYPE',3) LOV HR Organization Type 8E2FF36EDE8779D2E0530100007F1FF2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ORG_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.meaning F Type d'organisation US Organization Type 5 50 1=1 haouv.organization_id in ( select hoi.organization_id from hr_organization_information hoi where hoi.org_information1=xxen_util.lookup_code(:classification,'ORG_CLASS',3) and hoi.org_information_context='CLASS' and hoi.org_information2='Y' ) LOV HR Organization Classification 8E2FF36EDEA379D2E0530100007F1FF2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ORG_CLASS' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.meaning US Classification 6 60 1=1 decode(haouv.internal_external_flag,'EXT','External','INT','Internal')=:internal_external LOV custom Y select 'Internal' value, '' description from dual union all select 'External' value, '' description from dual F Interne ou externe US Internal or External 7 70 &show_attributes Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les attributs US Show Attributes 8 &col_attributes x.info_class, x.information_type, x.attribute_name, decode(x.system_value,null,null,xxen_util.display_flexfield_value(x.application_id,x.descriptive_flexfield_name,x.org_information_context,x.application_column_name,x.row_id,haouv.business_group_id,haouv.organization_id,x.org_information_id)) value, x.application_column_name, x.system_value, F Afficher les attributs US Show Attributes 9 80 2=2 hoit.displayed_org_information_type=:information_type LOV custom Y select hoit.displayed_org_information_type value, hoit.org_information_type description from hr_org_information_types hoit order by hoit.displayed_org_information_type F Type d'information US Information Type 10 &col_attributes x.info_class, x.information_type, x.attribute_name, decode(x.system_value,null,null,xxen_util.display_flexfield_value(x.application_id,x.descriptive_flexfield_name,x.org_information_context,x.application_column_name,x.row_id,haouv.business_group_id,haouv.organization_id,x.org_information_id)) value, x.system_value, F Type d'information US Information Type 11 &show_attributes Y F Type d'information US Information Type 12 1=1 x.information_type=:information_type F Type d'information US Information Type 13 90 2=2 fdfcuv.form_left_prompt=:attribute_name LOV custom Y select fdfcuv.form_left_prompt value, hoit.displayed_org_information_type||': '||fdfcuv.application_column_name description from fnd_descr_flex_col_usage_vl fdfcuv, hr_org_information_types hoit where fdfcuv.application_id=800 and fdfcuv.descriptive_flexfield_name='Org Developer DF' and fdfcuv.descriptive_flex_context_code=hoit.org_information_type order by fdfcuv.form_left_prompt F Nom de l'attribut US Attribute Name 14 &col_attributes x.info_class, x.information_type, x.attribute_name, decode(x.system_value,null,null,xxen_util.display_flexfield_value(x.application_id,x.descriptive_flexfield_name,x.org_information_context,x.application_column_name,x.row_id,haouv.business_group_id,haouv.organization_id,x.org_information_id)) value, x.system_value, F Nom de l'attribut US Attribute Name 15 &show_attributes Y F Nom de l'attribut US Attribute Name 16 1=1 x.attribute_name=:attribute_name F Nom de l'attribut US Attribute Name 17 100 1=1 sysdate between haouv.date_from and nvl(haouv.date_to,sysdate) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher uniquement les actifs US Show active only 18 110 &show_classification Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y F Élargir les classifications US Expand Classifications 19 &col_classification (select 'BG' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='HR_BG' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') bg, (select 'LE' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='HR_LEGAL' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') le, (select 'OU' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='OPERATING_UNIT' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') ou, (select 'INV' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='INV' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') inv, (select mp0.organization_code from mtl_parameters mp, mtl_parameters mp0 where haouv.organization_id=mp.organization_id and mp.master_organization_id=mp0.organization_id) master, (select 'WIP' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='WIP' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') wip, (select 'MRP' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='MRP' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') mrp, (select 'PJM' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='PJM' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') pjm, (select 'FA' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='FA_ORG' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') fa, (select 'HR' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='HR_ORG' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') hr, (select 'CC' from hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information1='CC' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') cc, ( select distinct listagg(hoi.org_class,', ') within group (order by hoi.org_class) over (partition by hoi.organization_id) classification from (select xxen_util.meaning(hoi.org_information1,'ORG_CLASS',3) org_class, hoi.* from hr_organization_information hoi) hoi where haouv.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information2='Y' ) classification, N F Élargir les classifications US Expand Classifications 20 &col_classification hoi.classification, Y F Élargir les classifications US Expand Classifications