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）限制的操作单元。 C6E085D4712551A9E05362FB09050512 select distinct ai.vendor_id, per.full_name "Employee Name:", NVL (per.employee_number, per.npw_number) "Employee Number:", pa_utils.GetWeekending(aid.expenditure_item_date) "Week Ending Date:", ai.CREATION_DATE "Initial Submission Date:", ai.source "Entry Method", ai.DESCRIPTION "Description:", aid.INVOICE_ID, aid.EXPENDITURE_ITEM_DATE "Date", to_char(aid.expenditure_item_date,'FMDay') "Week Day", nvl(aid.quantity_invoiced,0) "Quantity", nvl(aid.amount,0) "Amount", lk.meaning "Unit", aid.expenditure_type "Expenditure Type", pa.name "Project Name", pa.segment1 "Project Number", ta.task_number "Task Number", ta.task_Name "Task name", aid.description "Description", PA_PAXEXONE_XMLP_PKG.c_dis_sum_invoiceformula(:C_SUM_INVOICE) C_dis_Sum_invoice, PA_PAXEXONE_XMLP_PKG.c_bill_pctformula(:C_SUM_INVOICE, :C_sum_invoice1) C_bill_pct, PA_PAXEXONE_XMLP_PKG.c_amountformula(nvl ( aid.amount , 0 )) C_Amount from per_people_f per, hr_organization_units org, pa_expenditure_types et, pa_tasks ta, pa_lookups lk, pa_projects_all pa, po_vendors pv, ap_invoices ai, &lp_ap_invoice_dist aid WHERE ai.INVOICE_ID = aid.INVOICE_ID AND ai.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' AND per.person_id between nvl(:Employee_id,0) and nvl(:Employee_id,999999999999999) and (per.employee_number IS NOT NULL OR per.npw_number IS NOT NULL) and pa_utils.GetWeekending(aid.expenditure_item_date) between :date_low and :date_high and aid.expenditure_organization_id = nvl(:incurred_org,aid.EXPENDITURE_ORGANIZATION_ID) and pv.vendor_id = ai.vendor_id and pv.vendor_type_lookup_code = 'EMPLOYEE' and pv.employee_id = per.person_id and org.organization_id = aid.expenditure_organization_id and aid.task_id = ta.task_id and pa.project_id = ta.project_id and et.expenditure_type = aid.expenditure_type and et.unit_of_measure = lk.lookup_code and ai.invoice_type_lookup_code = 'EXPENSE REPORT' and lk.lookup_type = 'UNIT' and pa_addition_flag <> 'Y' Y PA PAXEXONE_XML AR PA إدخال تقرير المصروفات (بتنسيق XML) Imported from BI Publisher Description: إدخال تقرير المصروفات Application: المشروعات Source: AUD: إدخال تقرير المصروفات (بتنسيق XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG D PA Spesenabrechnungen - Eingabe Imported from BI Publisher Description: Spesenabrechnungen - Eingabe Application: Projects Source: PA: Spesenabrechnungen - Eingabe (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG E PA Registro de Informe de Gastos Imported from BI Publisher Description: Registro de informe de gastos Application: Projects Source: AUD: Registro de Informe de Gastos (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG F PA Saisie de notes de frais Imported from BI Publisher Description: Saisie de notes de frais Application: Projects Source: AUD : Saisie de notes de frais (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG I PA Inserimento note spese Imported from BI Publisher Description: Inserimento delle note spese Application: Projects Source: AUD: Inserimento note spese (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG JA PA 経費精算書入力 Imported from BI Publisher Description: 経費精算書入力 Application: Projects Source: AUD: 経費精算書入力(XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG KO PA 경비 보고서 입력 Imported from BI Publisher Description: 경비 보고서 입력 Application: Projects Source: AUD: 경비 보고서 입력(XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG PTB PA Entrada do Relatório de Despesas Imported from BI Publisher Description: Entrada do Relatório de Despesas Application: Projetos Source: AUD: Entrada do Relatório de Despesas (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG RU PA ввод авансового отчета Imported from BI Publisher Description: Ввод авансового отчета Application: Проекты Source: АУД: ввод авансового отчета (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG S PA Post i reseräkning Imported from BI Publisher Description: Post i reseräkning Application: Projects Source: AUD: Post i reseräkning (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG TR PA Harcama Raporu Girişi Imported from BI Publisher Description: Gider Raporu Girişi Application: Proje Yönetimi Source: AUD: Harcama Raporu Girişi (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG US PA Expense Report Entry Imported from BI Publisher Description: Expense Report Entry Application: Projects Source: AUD: Expense Report Entry (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG ZHS PA AUD：费用报表分录 Imported from BI Publisher Description: 费用报表分录 Application: 项目 Source: AUD：费用报表分录 (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG BI Publisher &lp_ap_invoice_dist :c_company_name_header :c_employee_name :c_incurred_org :c_no_data_found :c_sum_invoice :c_sum_invoice1 :date_high :date_low :employee_id :exp_id :inc_routing_history :incurred_org :lp_ap_invoice_dist :lp_pa_cost_dist_lines :lp_pa_cost_dist_lines_all :lp_pa_cost_xfer_audit :lp_pa_ei_denorm_v :lp_pa_expenditure_items :lp_pa_expenditure_items_all :lp_pa_expenditures :lp_pa_expenditures_all :lp_pa_implementations :lp_pa_implementations_all :lp_pa_proj_expend_view :operating_unit :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_debug_mode :p_mrcsobtype :p_rule_optimizer 1 -30 :p_ca_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 Währung Buchungsstruktur Währung Buchungsstruktur E Divisa de Juego de Libros Divisa de juego de libros F Devise de l'entité comptable Devise de l'entité comptable I Divisa set of books Divisa del set of books JA 会計帳簿通貨 会計帳簿通貨 KO 회계장부 통화 회계장부 통화 PTB Moeda do Conjunto de Livros Moeda do Conjunto de Livros RU Валюта набора книг Валюта набора книг S Räkenskapsvaluta Räkenskapsvaluta TR Defter Para Birimi Defter Para Birimi US Set of Books Currency Set of Books Currency ZHS 帐套币种 帐套币种 2 -20 :inc_routing_history 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 fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' AR تضمين تاريخ التوجيه تضمين تاريخ التوجيه للمصروفات D Mit Weiterleitungshistorie Mit Weiterleitungshistorie für den Aufwand E Incluir Historial de Rutas Incluir historial de rutas del gasto F Inclure l'historique d'acheminement Inclure l'historique d'acheminement pour la dépense I Includi cronologia instradamento Include la cronologia dell'instradamento per la spesa JA ルート履歴を含む 支出に対するルート履歴を含む KO 절차순서 내역 포함 비용에 대한 절차순서 내역 포함 PTB Incluir Histórico do Roteiro Incluir Histórico de Roteiro do dispêndio RU Включить историю маршрутизации Включить историю маршрутизации для расхода S Inkludera cirkulationshistorik Inkludera cirkulationshistorik för utgiften TR Rota Tarihçesini Dahil Et Harcama için Rota Tarihçesini kapsar US Include Routing History Include Routing History for the expenditure ZHS 包括审批历史记录 包括此支出的审批历史记录 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 :date_low Date Y AR تاريخ نهاية الأسبوع من تكوين تقرير فقط من تاريخ نهاية الأسبوع هذا D Von KW Ende Auswertung erst ab diesem KW Ende generieren E De Fecha de Finalización de Semana Generar informe sólo a partir de esta fecha de finalización de semana F Date de fin de semaine - Du Générer l'état uniquement à partir de cette date de fin de semaine I Data fine settimana - Da Genera il rapporto solo a partire da questa data di fine settimana JA 週末日:自 この週末日からのみレポートを生成します KO 주간 종료 일자: 부터 이 주간 종료 일자로부터만 보고서를 생성 PTB Data Final da Semana - De Gerar Relatório somente a partir da Data Final desta Semana RU Дата окончания недели с Создать отчет только с этой даты окончания недели S Veckoslutsdatum från Skapa rapport bara från det här veckoslutsdatumet TR Hafta Bitiş Tarihi, Başlangıç Sadece bu Haftanın Bitiş Tarihinden itibaren Rapor oluşturur US Week Ending Date From Generate Report only from this Week Ending Date ZHS 周末日期自 仅从此周末日期开始生成报表 5 20 :date_high Date Y AR تاريخ نهاية الأسبوع إلى تكوين تقرير فقط إلى تاريخ نهاية الأسبوع هذا D Bis KW Ende Auswertung nur bis zu diesem KW Ende generieren E A Fecha de Finalización de Semana Generar informe sólo hasta esta fecha de finalización de semana F Date de fin de semaine - Au Générer l'état uniquement jusqu'à cette date de fin de semaine I Data fine settimana - A Genera il rapporto solo fino a questa data di fine settimana JA 週末日:至 この週末日までのみレポートを生成します KO 주간 종료 일자: 까지 이 주간 종료 일자까지만 보고서를 생성 PTB Data Final da Semana - Até Gerar Relatório somente até a Data Final desta Semana RU Дата окончания недели по Создать отчет только до этой даты окончания недели S Veckoslutsdatum till Skapa rapport t o m det här veckoslutsdatumet TR Hafta Bitiş Tarihi, Bitiş Yalnızca bu Haftanın Bitiş Tarihine kadar rapor oluşturur US Week Ending Date To Generate Report only up to this Week Ending Date ZHS 周末日期至 仅生成在此周末日期之前的报表 6 30 :employee_id LOV Oracle PA_SRS_EMPLOYEE_LOV Y Y select person_id id, full_name value, employee_number description from pa_employees order by full_name AR اسم الموظف تم تكوين تقرير مصروفات لهذا الموظف D Mitarbeitername Spesenabrechnung für diesen Mitarbeiter wurde erstellt E Nombre del Empleado Se genera el informe de gastos para este empleado F Nom de l'employé Création d'une note de frais pour cet employé I Nome dipendente La nota spese viene generata per questo dipendente JA 従業員名 この従業員に対する経費精算書を生成します KO 사원명 이 사원에 대한 경비 보고서가 생성됩니다. PTB Nome do Funcionário Foi gerado um Relatório de Despesas para este funcionário RU Имя работника Создается авансовый отчет для этого работника S Anställd Det har skapats en reseräkning för den här anställde TR Çalışan Adı Bu çalışan için harcama raporu oluşturulur US Employee Name Expense Report for this employee is generated ZHS 员工姓名 生成此员工费用报表 7 40 :incurred_org LOV Oracle PA_SRS_EXPENDITURE_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_exp_all_bg_v order by name AR تكبد التكلفة بواسطة التنظيم اسم التنظيم الذي تحمل المصروفات D Erstellt von Organisation Organisation, für die die Aufwendungen anfielen E Realizado por Organización Nombre de la organización en la que se realizaron los gastos F Organisation ayant engagé les coûts Nom de l'organisation pour laquelle les dépenses ont été engagées I Sostenuta da - Organizzazione Nome dell'organizzazione che ha sostenuto le spese JA 発生元組織 費用の発生対象組織名 KO 발생 조직 비용이 발생한 조직명 PTB Incorrido pela Organização Nome da Organização para a qual as despesas foram incorridas RU Подотчетная организация Название организации, для которой были выполнены расходы S Utfärdande organisation Namn på den organisation som utgifterna påförts TR Gerçekleştiren Organizasyon Harcamaların gerçekleştiği Organizasyon Adı US Incurred By Organization Organization Name to which the expenses were incurred ZHS 费用支出组织 支出费用的组织名