ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4711151A9E05362FB09050512Y select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.other_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.project_organization_id = to_number(:child_organization_id) and nvl(fi.project_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.other_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.other_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.expenditure_organization_id = to_number(:child_organization_id) and nvl(fi.expenditure_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.other_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.burden_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.project_organization_id = to_number(:child_organization_id) and nvl(fi.project_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.burden_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.burden_rejection_Code, fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.cost_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.expenditure_organization_id = to_number(:child_organization_id) and nvl(fi.expenditure_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.burden_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.cost_rejection_Code , fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.cost_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), null from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.project_organization_id = to_number(:child_organization_id) and nvl(fi.project_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.cost_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.cost_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.cost_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.expenditure_organization_id = to_number(:child_organization_id) and nvl(fi.expenditure_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.cost_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.cost_rejection_Code, fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.rev_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.project_organization_id = to_number(:child_organization_id) and nvl(fi.project_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.rev_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.rev_rejection_Code, fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.rev_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.expenditure_organization_id = to_number(:child_organization_id) and nvl(fi.expenditure_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.rev_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.rev_rejection_Code, fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.tp_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.project_organization_id = to_number(:child_organization_id) and nvl(fi.project_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.tp_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.tp_rejection_Code, fi.other_rejection_Code UNION select to_number(:org_id) context_org_id, to_number(:child_organization_id) context_organization_id, pou.name project_ou_name, porg.name project_organization_name, eou.name exp_ou_name, eorg.name exp_organization_name, ppa.segment1 project_number, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name) name, fi.tp_rejection_Code rejection_code, min(fi.item_date), max(fi.item_date), PA_PAFPEXRP_XMLP_PKG.cf_rejection_descriptionformul(fi.other_rejection_Code) CF_REJECTION_DESCRIPTION from pa_forecast_items fi, pa_projects_all ppa, hr_all_organization_units_tl pou, hr_all_organization_units_tl porg, hr_all_organization_units_tl eou, hr_all_organization_units_tl eorg, per_all_people_f p, pa_project_role_types rt, pa_project_assignments asg where fi.expenditure_organization_id = to_number(:child_organization_id) and nvl(fi.expenditure_org_id,-99) = to_number(:org_id) and fi.forecast_item_type in ('A','R','U') and fi.delete_flag = 'N' and fi.tp_rejection_code is not null and fi.person_id = p.person_id(+) and ppa.project_id = fi.project_id and asg.assignment_id = fi.assignment_id and asg.project_role_id = rt.project_role_id and pou.organization_id = fi.project_org_id AND pou.language = USERENV('LANG') and porg.organization_id = fi.project_organization_id AND porg.language = USERENV('LANG') and eou.organization_id = fi.expenditure_org_id AND eou.language = USERENV('LANG') and eorg.organization_id = fi.expenditure_organization_id AND eorg.language = USERENV('LANG') &p_project_id_param &p_assignment_id_param --and to_number(:org_id)=to_number(:org_id) --and to_number(:child_organization_id)=to_number(:child_organization_id) group by pou.name, porg.name, eou.name, eorg.name, ppa.segment1, asg.assignment_name, decode(fi.forecast_item_type,'R',rt.meaning,p.full_name), to_number(:org_id), to_number(:child_organization_id), fi.tp_rejection_Code, fi.other_rejection_Code order by 3,4,5,6,7,8,9 PA PAFPEXRP_XML AR PA سرد استثناءات تقدير التنظيم (بتنسيق XML) Imported from BI Publisher Description: تقرير استثناءات تقدير التنظيم Application: المشروعات Source: PRC: سرد استثناءات تقدير التنظيم (بتنسيق XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG D PA Ausnahmen für Organisations-Forecasts auflisten Imported from BI Publisher Description: Ausnahmenauswertung für Organisations-Forecasts Application: Projects Source: PA: Ausnahmen für Organisations-Forecasts auflisten (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG E PA Listado de Excepciones de Previsión de Organización Imported from BI Publisher Description: Informe de excepciones de previsión de organización Application: Projects Source: PRC: Listado de Excepciones de Previsión de Organización (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG F PA Répertorier les exceptions des prévisions des organisations Imported from BI Publisher Description: Etat des exceptions des prévisions des organisations Application: Projects Source: PRC : Répertorier les exceptions des prévisions des organisations (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG I PA Elenca eccezioni previsione organizzazione Imported from BI Publisher Description: Rapporto Eccezioni previsioni organizzazione Application: Projects Source: PRC: Elenca eccezioni previsione organizzazione (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG JA PA 組織予測例外のリスト Imported from BI Publisher Description: 組織予測例外レポート Application: Projects Source: PRC: 組織予測例外のリスト(XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG KO PA 조직 예측 예외 나열 Imported from BI Publisher Description: 조직 예측 예외 보고서 Application: Projects Source: PRC: 조직 예측 예외 나열(XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG PTB PA Relacionar Exceções de Previsão da Organização Imported from BI Publisher Description: Relatório de Exceções de Previsão da Organização Application: Projetos Source: PRC: Relacionar Exceções de Previsão da Organização (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG RU PA исключения прогнозов для списка организаций Imported from BI Publisher Description: Отчет об исключениях прогноза для организации Application: Проекты Source: ПРЦ: исключения прогнозов для списка организаций (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG S PA Lista undantag för organisationsprognos Imported from BI Publisher Description: Undantagsrapport för organisationsprognos Application: Projects Source: PRC: Lista undantag för organisationsprognos (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG TR PA Organizasyon Tahmin İstisnalarını Listele Imported from BI Publisher Description: Organizasyon Tahmin İstisnaları Raporu Application: Proje Yönetimi Source: PRC: Organizasyon Tahmin İstisnalarını Listele (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG US PA List Organization Forecast Exceptions Imported from BI Publisher Description: Organization Forecast Exceptions Report Application: Projects Source: PRC: List Organization Forecast Exceptions (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG ZHS PA PRC：列出组织预测例外 Imported from BI Publisher Description: 组织预测例外报表 Application: 项目 Source: PRC：列出组织预测例外 (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG BI Publisher &p_assignment_id_param &p_project_id_param :child_organization_id :org_id :p_assignment_id :p_assignment_id_param :p_conc_request_id :p_fcst_end_date :p_fcst_start_date :p_org_id :p_org_structure_version_id :p_organization_id :p_project_id :p_project_id_param :p_project_id_parameter :p_start_organization_id :p_start_organization_id_dummy 1 -50 :p_org_id Char SELECT rtrim(substr(USERENV('CLIENT_INFO'),1,INSTR(USERENV('CLIENT_INFO'),' ') )) from dual Y AR معرف وحدة التشغيل وحدة التشغيل D Betriebseinheitskennung Betriebseinheit E Id Unidad Operativa Unidad Operativa F ID unité opérationnelle Unité opérationnelle I Id unità operativa Unità operativa JA 営業単位ID 営業単位 KO 운영 단위 ID 운영 단위 PTB Id da Unidade Operacional Unidade Operacional RU Идентификатор операционной единицы Операционная единица S Id för operativ enhet Operativ enhet TR Faaliyet Birimi No Faaliyet Birimi US Operating Unit Id Operating Unit ZHS 业务实体标识 业务实体 2 -30 :p_organization_flag Char SELECT 1 FROM DUAL WHERE :$flex$.selection_criteria:NULL='02' AR PA_SRS_FP_CHAR_1 علامة التنظيم D PA_SRS_FP_CHAR_1 Kennzeichen "Organisation" E PA_SRS_FP_CHAR_1 Indicador de organización F PA_SRS_FP_CHAR_1 Indicateur Organisation I PA_SRS_FP_CHAR_1 Flag Organizzazione JA PA_SRS_FP_CHAR_1 組織フラグ KO PA_SRS_FP_CHAR_1 조직 플래그 PTB PA_SRS_FP_CHAR_1 Indicador da Organização RU PA_SRS_FP_CHAR_1 Флаг организации S PA_SRS_FP_CHAR_1 Organisationsflagga TR PA_SRS_FP_CHAR_1 Organizasyon İşareti US PA_SRS_FP_CHAR_1 Organization Flag ZHS PA_SRS_FP_CHAR_1 组织标志 3 -40 :p_project_flag Char SELECT 1 FROM DUAL WHERE :$flex$.selection_criteria:NULL='01' AR PA_SRS_FP_CHAR_1 علامة المشروع D PA_SRS_FP_CHAR_1 Kennzeichen "Projekt" E PA_SRS_FP_CHAR_1 Indicador de proyecto F PA_SRS_FP_CHAR_1 Indicateur Projet I PA_SRS_FP_CHAR_1 Flag Progetto JA PA_SRS_FP_CHAR_1 プロジェクト・フラグ KO PA_SRS_FP_CHAR_1 프로젝트 플래그 PTB PA_SRS_FP_CHAR_1 Indicador de Projeto RU PA_SRS_FP_CHAR_1 Флаг проекта S PA_SRS_FP_CHAR_1 Projektflagga TR PA_SRS_FP_CHAR_1 Proje İşareti US PA_SRS_FP_CHAR_1 Project Flag ZHS PA_SRS_FP_CHAR_1 项目标志 4 -20 :p_start_organization_flag Char SELECT 1 FROM DUAL WHERE :$flex$.selection_criteria:NULL='03' AR PA_SRS_FP_CHAR_1 علامة تنظيم البداية D PA_SRS_FP_CHAR_1 Kennzeichen "Startorganisation" E PA_SRS_FP_CHAR_1 Indicador de organización de inicio F PA_SRS_FP_CHAR_1 Indicateur Organisation de départ I PA_SRS_FP_CHAR_1 Flag Organizzazione di partenza JA PA_SRS_FP_CHAR_1 開始組織フラグ KO PA_SRS_FP_CHAR_1 시작 조직 플래그 PTB PA_SRS_FP_CHAR_1 Indicador de Organização Inicial RU PA_SRS_FP_CHAR_1 Флаг начальной организации S PA_SRS_FP_CHAR_1 Flagga för startorganisation TR PA_SRS_FP_CHAR_1 Başlangıç Organizasyonu İşareti US PA_SRS_FP_CHAR_1 Start Organization Flag ZHS PA_SRS_FP_CHAR_1 起始组织标志 5 10 :p_select_criteria LOV Oracle PA_SRS_FP_SELECT_CRITERIA Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PA_FP_SELECTION_CRITERIA' order by lookup_code Y AR معايير الاختيار معايير الاختيار D Auswahlkriterien Auswahlkriterien E Criterios de Selección Criterios de selección F Critères de sélection Critères de sélection I Criteri di selezione Criteri di selezione JA 選択基準 選択基準 KO 선택 기준 선택 기준 PTB Critérios de Seleção Critérios de Seleção RU Условия отбора Условия отбора S Urvalsvillkor Urvalsvillkor TR Seçim Ölçütleri Seçim Ölçütleri US Selection Criteria Selection Criteria ZHS 选择标准 选择标准 6 20 :p_project_id LOV Oracle PA_SRS_FP_PROJECT_ID Y select project_id id, segment1 value, name description from pa_projects where :$flex$.pa_srs_fp_char_1='1' and nvl(template_flag,'N')='N' order by value,description AR اسم المشروع معرف المشروع D Projektbezeichnung Projektkennung E Nombre de Proyecto Identificador de proyecto F Nom du projet ID projet I Nome progetto Id del progetto JA プロジェクト名 プロジェクトID KO 프로젝트명 프로젝트 ID PTB Nome do Projeto Id do Projeto RU Имя проекта Идентификатор проекта S Projektnamn Projekt-id TR Proje Adı Proje No US Project Name Project Id ZHS 项目名 项目标识 7 30 :p_assignment_id LOV Oracle PA_SRS_FP_ASSIGNMENT_ID Y select assignment_id id, assignment_name value, null description from pa_project_assignments where project_id=:$flex$.pa_srs_fp_project_id order by value,description AR اسم التخصيص معرف التخصيص D Zuordnungsbezeichnung Zuordnungskennung E Nombre de Asignación Identificador de asignación F Nom de l'affectation ID affectation I Nome assegnazione Id assegnazione JA 割当名 割当ID KO 지정명 지정 ID PTB Nome da Atribuição Id da Atribuição RU Имя назначения Идент. назначения S Tilldelningsnamn Tilldelnings-id TR Atama Adı Atama No US Assignment Name Assignment Id ZHS 分配名称 分配标识 8 40 :p_organization_id LOV Oracle PA_SRS_FP_ORGANIZATION_ID Y select org.child_organization_id id, lpad(' ',3*(org.parent_level-org.child_level))||substr(hr.name,1,50) value, null description from pa_org_hierarchy_denorm org,hr_all_organization_units_tl hr,pa_implementations imp where :$flex$.pa_srs_fp_char_1='1' and org.pa_org_use_type='REPORTING' and org.parent_organization_id=imp.start_organization_id and nvl(org.org_id,-99)=nvl(imp.org_id,-99) and org.child_organization_id=hr.organization_id and org.org_hierarchy_version_id=imp.org_structure_version_id and hr.language=userenv('LANG') order by org.parent_level desc ,org.child_level desc ,org.child_organization_id AR المنشأة معرف التنظيم D Organisation Organisationskennung E Organización Identificador de organización F Organisation ID organisation I Organizzazione Id dell'organizzazione JA 組織 組織ID KO 조직 조직 ID PTB Organização Id da Organização RU Организация Идентификатор организации S Organisation Organisations-id TR Organizasyon Organizasyon No US Organization Organization Id ZHS 组织 组织标识 9 50 :p_start_organization_id LOV Oracle PA_SRS_FP_ORGANIZATION_ID Y select org.child_organization_id id, lpad(' ',3*(org.parent_level-org.child_level))||substr(hr.name,1,50) value, null description from pa_org_hierarchy_denorm org,hr_all_organization_units_tl hr,pa_implementations imp where :$flex$.pa_srs_fp_char_1='1' and org.pa_org_use_type='REPORTING' and org.parent_organization_id=imp.start_organization_id and nvl(org.org_id,-99)=nvl(imp.org_id,-99) and org.child_organization_id=hr.organization_id and org.org_hierarchy_version_id=imp.org_structure_version_id and hr.language=userenv('LANG') order by org.parent_level desc ,org.child_level desc ,org.child_organization_id AR تنظيم البداية معرف تنظيم البداية D Startorganisation Kennung Startorganisation E Organización de Inicio Identificador de organización de inicio F Organisation de départ ID organisation de départ I Organizzazione di partenza Id dell'organizzazione di partenza JA 開始組織 開始組織ID KO 시작 조직 시작 조직 ID PTB Organização Inicial Id da Organização Inicial RU Начальная организация Идентификатор начальной организации S Startorganisation Startorganisations-id TR Başlangıç Organizasyonu Başlangıç Organizasyonu No US Start Organization Start Organization Id ZHS 起始组织 起始组织标识