ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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. 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 8E2FF36EDEEE79D2E0530100007F1FF2 PER Person Full Name Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name US ABA3B6EE99AC3F82E0530100007F0549 PER Person Type Y select distinct pptv.user_person_type value, pptv.system_person_type description from per_person_types_v pptv order by pptv.user_person_type US 49A8B1A8037608ACE0530100007FEB91 select haouv.name business_group, papf.title, papf.first_name, papf.last_name, papf.full_name, (select distinct listagg(xxen_util.user_name(fu.user_id),', ') within group (order by xxen_util.user_name(fu.user_id)) over (partition by fu.employee_id) user_name from fnd_user fu where papf.person_id=fu.employee_id) user_name, xxen_util.meaning(papf.sex,'SEX',3) gender, pptv.user_person_type person_type, papf.employee_number, papf.national_identifier social_security, papf.date_of_birth birth_date, trunc(months_between(sysdate,papf.date_of_birth)/12) age, xxen_util.meaning(papf.marital_status,'MAR_STATUS',3) marital_status, xxen_util.meaning(papf.nationality,'NATIONALITY',3) nationality, papf.effective_start_date start_date, decode(papf.effective_end_date,to_date('31.12.4712','DD.MM.YYYY'),null,papf.effective_end_date) end_date, papf.original_date_of_hire hire_date, trunc(months_between(sysdate,papf.start_date)/12) service_yrs, round(mod(months_between(sysdate,papf.start_date),12)) service_months, papf.email_address, ( select distinct listagg(xxen_util.meaning(pp.phone_type,'PHONE_TYPE',3)||': '||pp.phone_number,chr(10)) within group (order by pp.phone_type) over (partition by pp.parent_id) phone_number from per_phones pp where papf.person_id=pp.parent_id and pp.parent_table='PER_ALL_PEOPLE_F' and :effective_date between pp.date_from and nvl(pp.date_to,sysdate) ) phone_number, papf2.full_name supervisor_name, papf2.email_address supervisor_email, paaf.assignment_number, decode(paaf.assignment_type, 'A','Applicant', 'B','Benefits Record', 'C','Contingent Worker', 'CT','Contingent Worker Terms Record', 'E','Employee', 'ET','Employee Terms Record', 'N','Non Worker', 'NT','Non Worker Terms Record', 'P','Pending Worker', 'PT','Pending Worker Terms Record', 'O','Offer', 'OT','Offer Terms Record', paaf.assignment_type ) assignment_type, paaf.effective_start_date assignment_start_date, decode(paaf.effective_end_date,to_date('31.12.4712','DD.MM.YYYY'),null,paaf.effective_end_date) assignment_end_date, paaf.normal_hours, xxen_util.meaning(paaf.frequency,'FREQUENCY',3) Frequency, paaf.time_normal_start, paaf.time_normal_finish, pjv.name job, hapft.name position, pgv.name grade, (select ppb.name from per_pay_bases ppb where paaf.pay_basis_id=ppb.pay_basis_id) salary_basis, paypf.payroll_name, haouv2.name assignment_organization, gl.name ledger, xxen_util.concatenated_segments(paaf.default_code_comb_id) expense_account, xxen_util.segments_description(paaf.default_code_comb_id) expense_account_description, hla.location_code, hla.description location_desc, hla.region_1, pastv.user_status assignment_status, xxen_util.meaning(pastv.active_flag,'YES_NO',0) active, xxen_util.meaning(paaf.primary_flag,'YES_NO',0) primary, xxen_util.meaning(paaf.manager_flag,'YES_NO',0) manager, xxen_util.meaning(paaf.employment_category,'EMP_CAT',3) employment_category, xxen_util.meaning(paaf.employee_category,'EMPLOYEE_CATG',3) employee_category, paaf.probation_period, xxen_util.meaning(paaf.probation_unit,'QUALIFYING_UNITS',3) probation_uom, paaf.date_probation_end, paaf.notice_period, xxen_util.meaning(paaf.notice_period_uom,'QUALIFYING_UNITS',3) notice_period_uom, paaf.internal_address_line, xxen_util.meaning(paaf.change_reason,'EMP_ASSIGN_REASON',3) assignment_change_reason, &flexfield_columns xxen_util.meaning(pa.address_type,'ADDRESS_TYPE',3) address_type, pa.address_line1, pa.address_line2, pa.address_line3, pa.postal_code, ftv.territory_short_name country, pa.country country_code, papf.per_information_category, decode(papf.per_information_category,'ZA',papf.per_information1) za_income_tax_number, decode(papf.per_information_category,'ZA',papf.per_information2) za_passport_number, decode(papf.per_information_category,'ZA',papf.per_information10) za_country_of_passport_issue, decode(papf.per_information_category,'ZA',xxen_util.meaning(papf.per_information9,'YES_NO',0)) za_foreign_national, decode(papf.per_information_category,'ZA',papf.per_information3) za_work_permit_number, decode(papf.per_information_category,'ZA',fnd_date.canonical_to_date(papf.per_information8)) za_work_permit_expiry_date, decode(papf.per_information_category,'ZA',fnd_date.canonical_to_date(papf.per_information11)) za_date_of_naturalization, decode(papf.per_information_category,'ZA',xxen_util.meaning(papf.per_information4,'ZA_RACE',3)) za_race, decode(papf.per_information_category,'ZA',papf.per_information5) za_ethnic_origin, decode(papf.per_information_category,'ZA',papf.per_information6) za_language_preference, decode(papf.per_information_category,'ZA',papf.per_information7) za_religion, decode(papf.per_information_category,'ZA',papf.per_information12) za_nature_of_person, xxen_util.user_name(papf.created_by) person_created_by, xxen_util.client_time(papf.creation_date) person_creation_date, xxen_util.user_name(papf.last_updated_by) person_last_updated_by, xxen_util.client_time(papf.last_update_date) person_last_update_date, xxen_util.user_name(paaf.created_by) assignment_created_by, xxen_util.client_time(paaf.creation_date) asssignment_creation_date, xxen_util.user_name(paaf.last_updated_by) asssignment_last_updated_by, xxen_util.client_time(paaf.last_update_date) assignment_last_update_date from hr_all_organization_units_vl haouv, (select papf.* from per_all_people_f papf where :effective_date between papf.effective_start_date and papf.effective_end_date) papf, (select papf.* from per_all_people_f papf where :effective_date between papf.effective_start_date and papf.effective_end_date) papf2, per_person_types_v pptv, (select paaf.* from per_all_assignments_f paaf where :effective_date between paaf.effective_start_date and paaf.effective_end_date) paaf, per_assignment_status_types_v pastv, hr_all_organization_units_vl haouv2, per_jobs_vl pjv, per_all_positions pap, hr_all_positions_f_tl hapft, per_grades_vl pgv, hr_locations_all hla, gl_ledgers gl, (select pa.* from per_addresses pa where pa.primary_flag='Y' and :effective_date between pa.date_from and nvl(pa.date_to,:effective_date)) pa, fnd_territories_vl ftv, (select paypf.* from pay_all_payrolls_f paypf where :effective_date between paypf.effective_start_date and paypf.effective_end_date) paypf where 1=1 and papf.person_type_id=pptv.person_type_id and papf.business_group_id=haouv.organization_id and papf.person_id=paaf.person_id(+) and paaf.assignment_status_type_id=pastv.assignment_status_type_id(+) and paaf.organization_id=haouv2.organization_id(+) and paaf.job_id=pjv.job_id(+) and paaf.position_id=pap.position_id(+) and pap.position_id=hapft.position_id(+) and hapft.language(+)=userenv('lang') and paaf.grade_id=pgv.grade_id(+) and paaf.supervisor_id=papf2.person_id(+) and paaf.location_id=hla.location_id(+) and paaf.set_of_books_id=gl.ledger_id(+) and papf.business_group_id=pa.business_group_id(+) and papf.person_id=pa.person_id(+) and pa.country=ftv.territory_code(+) and paaf.payroll_id=paypf.payroll_id(+) order by haouv.name, papf.last_name, papf.first_name, paaf.assignment_number desc Y AR PER Employee Assignments تقرير بيانات رئيسي يوضح المعلومات الديموغرافية للموظف بما في ذلك الاسم والجنس وتاريخ الميلاد والعمر والجنسية وتاريخ البدء الفعلي ومعلومات الملف الشخصي الإضافية. D PER Employee Assignments Stammdatenbericht, der die demografischen Informationen des Mitarbeiters zeigt, einschließlich Name, Geschlecht, SSN, Geburtsdatum, Alter, Nationalität, effektives Startdatum und zusätzliche Profilinformationen. E PER Employee Assignments Informe de datos maestros que muestra la información demográfica del empleado, incluyendo el nombre, el sexo, el número de seguro social, la fecha de nacimiento, la edad, la nacionalidad, la fecha de inicio efectiva y la información adicional del perfil. F PER Employee Assignments Rapport de données de base indiquant les informations démographiques de l'employé, y compris le nom, le sexe, le numéro de sécurité sociale, la date de naissance, l'âge, la nationalité, la date de début effective et des informations supplémentaires sur le profil. I PER Employee Assignments Rapporto dei dati anagrafici che mostra le informazioni demografiche dei dipendenti tra cui nome, sesso SSN, data di nascita, età, nazionalità, data di inizio effettiva e altre informazioni del profilo. JA PER Employee Assignments 名前、性別SSN、生年月日、年齢、国籍、勤務開始日、その他のプロフィール情報を含む従業員の人口統計学的情報を示すマスターデータレポート。 KO PER Employee Assignments 이름, 성별 SSN, 생년월일, 나이, 국적, 유효 시작일 및 추가 프로필 정보를 포함한 직원 인구 통계 정보를 보여주는 마스터 데이터 보고서. PTB PER Employee Assignments Relatório de dados mestre mostrando as informações demográficas dos funcionários, incluindo nome, sexo SSN, data de nascimento, idade, nacionalidade, data de início efetivo e informações adicionais de perfil. RU PER Employee Assignments Отчет об основных данных, показывающий демографическую информацию о сотруднике, включая имя, пол, SSN, дату рождения, возраст, национальность, дату начала работы, а также дополнительную информацию профиля. S PER Employee Assignments Huvuddatarapport som visar de anställdas demografiska information inklusive namn, kön SSN, födelsedatum, ålder, nationalitet, giltigt startdatum och ytterligare profilinformation. TR PER Employee Assignments Ad, cinsiyet SSN, doğum tarihi, yaş, uyruk, geçerlilik başlangıç tarihi ve ek profil bilgileri dahil olmak üzere çalışan demografik bilgilerini gösteren ana veri raporu. US PER Employee Assignments Master data report showing the employee demographic information including name, gender SSN, birthdate, age, nationality, effective start date, and additional profile information. ZHS PER Employee Assignments 主数据报告显示了雇员的人口信息，包括姓名、性别、SSN、出生日期、年龄、国籍、有效起始日期和其他概况信息。 Enginatics &flexfield_columns 1=1 :effective_date 1 10 1=1 papf.full_name=:full_name LOV PER Person Full Name 8E2FF36EDEEE79D2E0530100007F1FF2 Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name F Nom complet de la personne US Person Full Name 2 20 1=1 papf.person_id in (select fu.employee_id from fnd_user fu where fu.user_name=:user_name) 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 Nom de l'utilisateur US User Name 3 30 1=1 pptv.user_person_type=:person_type LOV PER Person Type ABA3B6EE99AC3F82E0530100007F0549 Y select distinct pptv.user_person_type value, pptv.system_person_type description from per_person_types_v pptv order by pptv.user_person_type F Type de personne US Person Type 4 40 1=1 papf.person_id in ( select paaf.person_id from hr_all_organization_units_vl haouv, per_all_assignments_f paaf where haouv.name=:assignment_organization and haouv.organization_id=paaf.organization_id and sysdate between nvl(paaf.effective_start_date,sysdate) and nvl(paaf.effective_end_date,sysdate) ) LOV custom Y select pou.name value, haou.name||' ('||count(*)||')' description from hr_all_organization_units haou, per_organization_units pou, per_all_assignments_f paaf where haou.organization_id=pou.business_group_id and pou.internal_external_flag='INT' and sysdate between pou.date_from and nvl(pou.date_to,sysdate) and pou.organization_id=paaf.organization_id and sysdate between nvl(paaf.effective_start_date,sysdate) and nvl(paaf.effective_end_date,sysdate) group by pou.name, haou.name order by count(*) desc F Organisation des affectations US Assignment Organization 5 50 1=1 haouv.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 6 60 :effective_date Date sysdate Y F Date d'entrée en vigueur US Effective Date 7 70 &flexfield_columns select 'paaf.'||lower(fdfcuv.application_column_name)||' "'||substrb(fdfcuv.form_left_prompt,1,xxen_report.max_column_length)||'",' column_text from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=800 and fdfcuv.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' and fdfcuv.descriptive_flex_context_code=:descriptive_flex_context_code order by fdfcuv.column_seq_num LOV custom Y select distinct fdfcu.descriptive_flex_context_code value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_column_usages fdfcu where fdfcv.application_id=fdfcu.application_id and fdfcv.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and fdfcv.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and fdfcu.application_id=800 and fdfcu.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfcu.enabled_flag='Y' and fdfcu.display_flag='Y' order by fdfcu.descriptive_flex_context_code select distinct min(fdfcu.descriptive_flex_context_code) keep (dense_rank first order by decode(fdfcu.descriptive_flex_context_code,'Global Data Elements',1,2),fdfcu.descriptive_flex_context_code) over () descriptive_flex_context_code from fnd_descr_flex_column_usages fdfcu where fdfcu.application_id=401 and fdfcu.descriptive_flexfield_name='MTL_SYSTEM_ITEMS' and fdfcu.enabled_flag='Y' and fdfcu.display_flag='Y' F Contexte de Flexfield US Flexfield Context