ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id 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) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4712651A9E05362FB09050512Y SELECT Project_Number, 1 TempFlag, Project_Type, Task_Number, SUBSTR(Agreement_Number,1,20) Agreement_Number, Customer_Name ||' ('||Customer_Number||')' Customer_Desc, Revaluation_Date, Funding_Currency, to_char(Funding_Baselined_Funding,FND_CURRENCY.Get_Format_Mask(Funding_Currency,30)) FC_Baselined_Funding, to_char(Funding_Amount_Applied,FND_CURRENCY.Get_Format_Mask(Funding_Currency,30)) FC_Amount_Applied, to_char(Funding_Amount_Due,FND_CURRENCY.Get_Format_Mask(Funding_Currency,30)) FC_Amount_Due, to_char(Funding_Backlog,FND_CURRENCY.Get_Format_Mask(Funding_Currency,30)) FC_Backlog, Funding_Revaluation_Factor, to_char(Funding_Backlog_Subj_Reval, FND_CURRENCY.Get_Format_Mask(Funding_Currency,30)) FC_Backlog_Subj_Reval, RevProc_Currency, substr(PA_Multi_Currency.Get_User_Conversion_Type(RevProc_Rate_Type),1,30) RevProc_Rate_Type, RevProc_Rate_Date, RevProc_Rate, to_char(RevProc_Backlog_Revalued,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Backlog_Revalued, to_char(RevProc_Amount_Applied,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Amount_Applied, to_char(RevProc_Amount_Due_Revaled, FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Amount_Due_Revaled, to_char(RevProc_Realized_Gains, FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Realized_Gains, to_char(RevProc_Realized_Losses,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Realized_Losses, to_char(RevProc_Baselined_Revalued,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Baselined_Revalued, to_char(RevProc_Baselined_Bfr_Reval,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Baselined_Bfr_Reval, to_char(RevProc_Revaluation_Adj,FND_CURRENCY.Get_Format_Mask(RevProc_Currency,30)) RPC_Revaluation_Adj, to_char(RevProc_Revaluation_Adj,FND_Currency.Get_Format_Mask(RevProc_Currency,30)) ||' '||RevProc_Currency RPC_Reval_Adj_Wth_Curr, InvProc_Currency, substr(PA_Multi_Currency.Get_User_Conversion_Type(InvProc_Rate_Type),1,30) InvProc_Rate_Type, InvProc_Rate_Date, InvProc_Rate, to_char(InvProc_Backlog_Ravaled,FND_CURRENCY.Get_Format_Mask(InvProc_Currency,30)) IPC_Backlog_Revaled, to_char(InvProc_Baselined_Revaled,FND_CURRENCY.Get_Format_Mask(InvProc_Currency,30)) IPC_Baselined_Revaled, to_char(InvProc_Baselined_Bfr_Reval,FND_CURRENCY.Get_Format_Mask(InvProc_Currency,30)) IPC_Baselined_Bfr_Reval, to_char(InvProc_Revaluation_Adj,FND_CURRENCY.Get_Format_Mask(InvProc_Currency,30)) IPC_Revaluation_Adj, to_char(InvProc_Revaluation_Adj,FND_CURRENCY.Get_Format_Mask(InvProc_Currency,30)) ||' '||InvProc_Currency IPC_Reval_Adj_wth_Curr, Event_Number, Event_Type, Event_Classification, Event_Currency, to_char(nvl(Event_Amount,0), FND_CURRENCY.Get_Format_Mask(Event_Currency,30)) EC_Event_Amount FROM pa_fund_reval_audits_v WHERE Project_Number BETWEEN NVL(:LP_From_Project_Number, '0') AND NVL(:LP_To_Project_Number, 'z') AND UPPER(Project_Type) = UPPER(NVL(:P_Proj_Type, Project_Type)) AND trunc(Revaluation_Date) BETWEEN NVL(trunc(:P_Reval_From_Date), sysdate-10000) AND NVL(trunc(:P_Reval_To_Date), sysdate+10000) UNION SELECT p.segment1, 0 TempFlag, NULL, NULL, NULL, NULL, to_Date(NULL), NULL, NULL, NULL, NULL, NULL, to_Number(NULL), NULL, NULL, NULL, To_Date(NULL), To_Number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, To_Date(NULL), To_Number(NULL), NULL, NULL, NULL, NULL, NULL, To_Number(NULL), NULL, NULL, NULL, NULL from pa_projects p where p.segment1 BETWEEN NVL(:LP_From_Project_Number, '0') AND NVL(:LP_To_Project_Number, 'z') AND P.Project_Type = NVL(:P_Proj_Type, P.Project_Type) AND p.template_flag = 'N' AND Revaluate_Funding_Flag = 'Y' AND NOT EXISTS (select f.project_id from pa_project_fundings f where p.project_Id = f.project_id and Revaluation_Through_Date between NVL(trunc(:P_Reval_From_Date), sysdate-10000) AND NVL(trunc(:P_Reval_To_Date), sysdate+10000) ) ORDER BY TempFlag, Project_Number, Agreement_Number, Task_Number, Revaluation_Date PA PAXFRADR_XML AR PA تقرير تدقيق تمويل معاد تقييمه (بتنسيق XML) Imported from BI Publisher Description: تقرير تدقيق تمويل معاد تقييمه Application: المشروعات Source: AUD: تقرير تدقيق تمويل معاد تقييمه (بتنسيق XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG D PA Neu bewertete Finanzierung - Protokoll Imported from BI Publisher Description: Neu bewertete Finanzierung - Protokoll Application: Projects Source: PA: Neu bewertete Finanzierung - Protokoll (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG E PA Auditoría de Financiación Revalorizada Imported from BI Publisher Description: Informe de auditoría de financiación revalorizada Application: Projects Source: AUD: Auditoría de Financiación Revalorizada (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG F PA Etat Financement réévalué - Audit Imported from BI Publisher Description: Etat Financement réévalué - Audit Application: Projects Source: AUD : Etat Financement réévalué - Audit (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG I PA rapporto Audit fondi rivalutati Imported from BI Publisher Description: Rapporto Audit fondi rivalutati Application: Projects Source: AUD: rapporto Audit fondi rivalutati (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG JA PA 再評価済資金監査レポート Imported from BI Publisher Description: 再評価済資金監査レポート Application: Projects Source: AUD: 再評価済資金監査レポート(XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG KO PA 재평가된 자금조달 감사 보고서 Imported from BI Publisher Description: 재평가된 자금조달 감사 보고서 Application: Projects Source: AUD: 재평가된 자금조달 감사 보고서(XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG PTB PA Relatório de Auditoria de Fundos Reavaliados Imported from BI Publisher Description: Relatório de Auditoria de Fundos Reavaliados Application: Projetos Source: AUD: Relatório de Auditoria de Fundos Reavaliados (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG RU PA отчет об аудите переоцененного финансирования Imported from BI Publisher Description: Отчет об аудите переоцененного финансирования Application: Проекты Source: АУД: отчет об аудите переоцененного финансирования (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG S PA Omvärderad finansiering - kontrollrapport Imported from BI Publisher Description: Omvärderad finansiering - kontrollrapport Application: Projects Source: AUD: Omvärderad finansiering - kontrollrapport (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG TR PA Yeniden Değerlenen Fon Denetim Raporu Imported from BI Publisher Description: Yeniden Değerlenen Fon Denetim Raporu Application: Proje Yönetimi Source: AUD: Yeniden Değerlenen Fon Denetim Raporu (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG US PA Revaluated Funding Audit Imported from BI Publisher Description: Revaluated Funding Audit Report Application: Projects Source: AUD: Revaluated Funding Audit Report (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG ZHS PA AUD：重估的资金分配审核报表 Imported from BI Publisher Description: 重估的资金分配审核报表 Application: 项目 Source: AUD：重估的资金分配审核报表 (XML) Short Name: PAXFRADR_XML DB package: PA_PAXFRADR_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_error_buf :c_no_data_found :c_no_report_data :c_retcode :curr_code :l_where_clause :lp_from_project_number :lp_reval_from_date :lp_reval_to_date :lp_to_project_number :operating_unit :p_conc_request_id :p_debug_mode :p_from_clause :p_from_project_number :p_mode :p_proj_type :p_report_mode :p_reval_from_date :p_reval_to_date :p_to_project_number 1 -30 :p_set_of_books_id LOV Oracle PA_SRS_SET_OF_BOOKS Y select set_of_books_id id, currency value, set_of_books_name description from pa_gl_set_of_books_v order by set_of_books_type select currency from pa_gl_set_of_books_v where set_of_books_type_code = 'P' AR عملة دفتر الأستاذ معرف دفاتر الحسابات المستخدم لتقرير تدقيق التمويل المعاد تقييمه D Buchwährung Buchungsstrukturkennung für die Auswertung "Neu bewertete Finanzierung - Protokoll" E Divisa de Libro Mayor Identificador de juego de libros utilizado en el informe de auditoría de financiación revalorizada F Devise comptable ID entité comptable utilisé pour l'état d'audit de financement réévalué I Divisa libro contabile Id del set of books utilizzato per il rapporto Audit fondi rivalutati JA 元帳通貨 再評価済資金監査レポートに使用する会計帳簿ID KO 원장 통화 재평가된 자금조달 감사 보고서에 사용되는 회계장부 ID PTB Moeda do Razão Id do Conjunto de Livros usado para Relatório de Auditoria de Fundos Reavaliados RU Валюта книги Код набора книг, используемого для отчета об аудите переоценки финансирования S Huvudboksvaluta Räkenskaps-id som används för kontrollrapport över omvärderad finansiering TR Defter Para Birimi Yeniden Değerlenen Fon Denetim Raporu için kullanılan Yasal Muhasebe Birimi No US Ledger Currency Set of Books Id used for Revaluated Funding Audit Report ZHS 分类帐币种 用于重估的资金分配审核报表的帐套标识 2 -20 :p_debug_mode Char fnd_profile.value('PA_DEBUG_MODE') AR P_DEBUG_MODE طور معالجة الأخطاء D P_DEBUG_MODE Debug-Modus E P_DEBUG_MODE Modo Depuración F P_DEBUG_MODE Mode Diagnostic I P_DEBUG_MODE Modalità debug JA P_DEBUG_MODE デバッグ・モード KO P_DEBUG_MODE 디버그 모드 PTB P_DEBUG_MODE Modo de Depuração RU P_DEBUG_MODE Режим отладки S P_DEBUG_MODE Felsökningsläge TR P_DEBUG_MODE Hata Ayıklama Modu US P_DEBUG_MODE Debug Mode ZHS P_DEBUG_MODE 调试模式 3 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id 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) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 4 10 :p_from_project_number LOV Oracle PA_SRS_PROJECT_ID_CONTRACT Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CONTRACT' and cc_prvdr_flag='N' order by project_number_sort_order AR من رقم المشروع من رقم المشروع D Von Projektnummer Von Projektnummer E De Número de Proyecto De Número de Proyecto F Du numéro de projet Du numéro de projet I Numero progetto - Da Numero progetto - Da JA プロジェクト番号:自 プロジェクト番号:自 KO 프로젝트 번호: 부터 프로젝트 번호: 부터 PTB Nr. do Projeto - De Nr. do Projeto - De RU Номер проекта с Номер проекта с S Från projektnummer Från projektnummer TR İlk Proje Numarası İlk Proje Numarası US From Project Number From Project Number ZHS 自项目编号 自项目编号 5 20 :p_to_project_number LOV Oracle PA_SRS_PROJECT_ID_CONTRACT Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CONTRACT' and cc_prvdr_flag='N' order by project_number_sort_order AR إلى رقم المشروع إلى رقم المشروع D Bis Projektnummer Bis Projektnummer E A Número de Proyecto A Número de Proyecto F Au numéro de projet Au numéro de projet I Numero progetto - A Numero progetto - A JA プロジェクト番号:至 プロジェクト番号:至 KO 프로젝트 번호: 까지 프로젝트 번호: 까지 PTB Nr. do Projeto - Até Nr. do Projeto - Até RU Номер проекта по Номер проекта по S Till projektnummer Till projektnummer TR Son Proje Numarası Son Proje Numarası US To Project Number To Project Number ZHS 至项目编号 至项目编号 6 30 :p_proj_type LOV Oracle PA_SRS_FR_PROJ_TYPE Y Y select project_type_id id, project_type value, description description from pa_project_types where direct_flag='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate) order by project_type AR نوع المشروع نوع المشروع D Projektart Projektart E Tipo de Proyecto Tipo de Proyecto F Type de projet Type de projet I Tipo di progetto Tipo di progetto JA プロジェクト・タイプ プロジェクト・タイプ KO 프로젝트 유형 프로젝트 유형 PTB Tipo de Projeto Tipo de Projeto RU Тип проекта Тип проекта S Projekttyp Projekttyp TR Proje Tipi Proje Tipi US Project Type Project Type ZHS 项目类型 项目类型 7 40 :p_reval_from_date Date AR إعادة التقييم من تاريخ إعادة التقييم من تاريخ D Neubewertung von Neubewertung von E De Fecha de Revalorización De fecha de revalorización F Date de réévaluation - Du Date de réévaluation - Du I Data rivalutazione - Da Data rivalutazione - Da JA 再評価開始日 再評価開始日 KO 재평가 일자: 부터 재평가 일자: 부터 PTB Data de Reavaliação - De Data de Reavaliação - De RU Дата переоценки с Дата переоценки с S Omvärdering från datum Omvärdering från datum TR Yeniden Değerleme Başlangıç Tarihi Yeniden Değerleme Başlangıç Tarihi US Revaluation From Date Revaluation From Date ZHS 重估起始日期 重估起始日期 8 50 :p_reval_to_date Date sysdate AR إعادة التقييم إلى تاريخ إعادة التقييم إلى تاريخ D Neubewertung bis Neubewertung bis E A Fecha de Revalorización A fecha de revalorización F Date de réévaluation - Au Date de réévaluation - Au I Data rivalutazione - A Data rivalutazione - A JA 再評価終了日 再評価終了日 KO 재평가 일자: 까지 재평가 일자: 까지 PTB Data de Reavaliação - Até Data de Reavaliação - Até RU Дата переоценки по Дата переоценки по S Omvärdering till datum Omvärdering till datum TR Yeniden Değerleme Bitiş Tarihi Yeniden Değerleme Bitiş Tarihi US Revaluation To Date Revaluation To Date ZHS 重估终止日期 重估终止日期 9 60 :p_mode LOV Oracle AR_REPORT_TYPE Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='REPORT_TYPE_SD' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning,lookup_code select meaning from ar_lookups where lookup_type = 'REPORT_TYPE_SD' and lookup_code = 'D' Y AR الطور الطور D Modus Modus E Modo Modo I Modalità Modalità JA モード モード KO 모드 모드 PTB Modo Modo RU Режим Режим S Läge Läge TR Mod Mod US Mode Mode ZHS 模式 模式