ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F27C3869E053B46B63588994Y select res.resource_id, res.name, ou.resource_organization_id, substr(hrorg.name,1,60) name1, ou.resource_effective_start_date, decode(ou.resource_effective_end_date, to_date('31-12-4712', 'DD-MM-YYYY'), to_date(null), ou.resource_effective_end_date) resource_effective_end_date from pa_resources res, pa_resources_denorm ou, hr_all_organization_units hrorg where res.resource_id = ou.resource_id(+) and ou.resource_organization_id = hrorg.organization_id(+) and (decode(res.request_id,:p_conc_request_id,res.request_id,NULL) = :p_conc_request_id or decode(ou.request_id,:p_conc_request_id,ou.request_id,NULL) = :p_conc_request_id) PA PARCPRJR_XML AR PA تعديل بيانات موارد المشروعات (بتنسيق XML) Application: المشروعات Source: PRC: تعديل بيانات موارد المشروعات (بتنسيق XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG D PA Projektressourcen verwalten Application: Projects Source: PA: Projektressourcen verwalten (XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG F PA Tenir à jour les ressources projet Application: Projects Source: PRC : Tenir à jour les ressources projet (XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG US PA Maintain Project Resources Application: Projects Source: PRC: Maintain Project Resources (XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG ZHS PA PRC：维护项目资源 Application: 项目 Source: PRC：维护项目资源 (XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG BI Publisher :cp_chk_emp_range :cp_chk_org_and_emp_range :cp_chk_org_or_emp :cp_chk_single_org :cp_chk_start_org :cp_count :cp_nodatafound :operating_unit :p_coa_id :p_conc_request_id :p_conc_resquest_id :p_debug_mode :p_from_emp_num :p_org_str_version_id :p_organization_id :p_person_type :p_pull_term_res :p_refresh :p_ret_status :p_selection_option :p_start_organization_id :p_term_range_date :p_term_range_date1 :p_to_emp_num 1 10 :p_selection_option LOV Oracle PA_SRS_RESPULL_OPTION_TYPE Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PA_RES_PULL_SELECT_TYPE' order by value,description select meaning from pa_lookups where lookup_type='PA_RES_PULL_SELECT_TYPE' and lookup_code='EMP_RANGE' Y AR خيار التحديد D Auswahloption F Critère de sélection US Selection Option ZHS 选择选项 2 20 :p_from_emp_num LOV Oracle PA_SRS_PER_EMP_NUMBER Y select employee_number id, employee_number value, null description from pa_per_emp_v where :$flex$.pa_srs_respull_option_type in ('EMP_RANGE','EMP_RANGE_ORG') order by value,description AR من رقم الموظف D Von Personalnummer F Matricule employé - De US From Employee Number ZHS 自员工编号 3 30 :p_to_emp_num LOV Oracle PA_SRS_PER_EMP_NUMBER Y select employee_number id, employee_number value, null description from pa_per_emp_v where :$flex$.pa_srs_respull_option_type in ('EMP_RANGE','EMP_RANGE_ORG') order by value,description AR إلى رقم الموظف D Bis Personalnummer F Matricule employé - A US To Employee Number ZHS 至员工编号 4 40 :p_organization_id LOV Oracle PA_SRS_RES_EXP_ORGS Y select exp.organization_id id, exp.name value, null description from pa_r_expenditure_orgs_v exp,hr_organization_units org where org.organization_id=exp.business_group_id and :$flex$.pa_srs_respull_option_type in ('SINGLE_ORG','EMP_RANGE_ORG') order by exp.name AR المنشأة D Organisation F Organisation US Organization ZHS 组织 5 50 :p_org_str_version_id LOV Oracle PA_SRS_ORG_HIERARCHY Y select posv.org_structure_version_id id, pos.name value, null description from per_organization_structures pos,per_org_structure_versions posv where :$flex$.pa_srs_respull_option_type='START_ORG' and posv.organization_structure_id=pos.organization_structure_id and posv.org_structure_version_id in (select exp_org_structure_version_id from pa_implementations_all) order by pos.name AR التدرج الوظيفي للمنشأة D Organisationshierarchie F Hiérarchie d'organisations US Organization Hierarchy ZHS 组织层次结构 6 60 :p_start_organization_id LOV Oracle PA_SRS_START_ORG Y select organization_id id, name value, null description from hr_all_organization_units_tl where language=userenv('LANG') and :$flex$.pa_srs_respull_option_type='START_ORG' and organization_id in (select organization_id_child from per_org_structure_elements_v where org_structure_version_id=:$flex$.pa_srs_org_hierarchy union select organization_id_parent from per_org_structure_elements_v where org_structure_version_id=:$flex$.pa_srs_org_hierarchy) order by name AR تنظيم البداية D Startorganisation F Organisation de départ US Starting Organization ZHS 起始组织 7 70 :p_refresh LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from pa_lookups where lookup_type='YES_NO' and lookup_code='Y' AR تحديث بيانات المورد الموجودة D Vorhandene Ressourcendaten aktualisieren F Mettre à jour les informations sur les ressources existantes US Update Existing Resource Information ZHS 更新现有资源信息 8 80 :p_pull_term_res LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from pa_lookups where lookup_type='YES_NO' and lookup_code='N' AR سحب الموارد المنتهية D Beendete Ressourcen abrufen F Extraire les ressources terminées US Pull Terminated Resources ZHS 提取已终止的资源 9 90 :p_term_range_date Date select fnd_date.date_to_displaydate(add_months(sysdate, -12)) from dual AR تاريخ بداية الإنهاء D Startdatum Beendigung F Date de fin de la ressource US Termination Start Date ZHS 终止起始日期 10 100 :p_person_type LOV Oracle PA_SRS_PERSON_TYPE Y select lookup_code id, meaning value, null description from pa_lookups where (lookup_type='PA_PERSON_TYPE' and lookup_code in ('EMP','CWK') and :$flex$.pa_srs_respull_option_type in ('START_ORG', 'SINGLE_ORG') ) or (lookup_type='PA_REP_ALL' and :$flex$.pa_srs_respull_option_type in ('START_ORG', 'SINGLE_ORG') ) or (lookup_type='PA_PERSON_TYPE' and lookup_code='EMP' and :$flex$.pa_srs_respull_option_type in ('EMP_RANGE', 'EMP_RANGE_ORG') ) order by value,description select meaning from pa_lookups where (lookup_type = 'PA_REP_ALL' AND :$FLEX$.Selection_Option in ('SINGLE_ORG', 'START_ORG')) OR (lookup_type = 'PA_PERSON_TYPE' and lookup_code = 'EMP' and :$FLEX$.Selection_Option in ('EMP_RANGE', 'EMP_RANGE_ORG')) Y AR نوع الشخص D Personenart F Type de personne US Person Type ZHS 人员类型