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）限制的操作单元。 4DADBA9F28DF5278E0630100007F12DE select haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, pt.task_number, pt.task_name, peia.expenditure_type, aps.vendor_name, aps.segment1 vendor_number, aia.invoice_num, aia.invoice_date, aia.invoice_amount, aia.invoice_currency_code, peia.expenditure_item_date, pcdla.pa_period_name period_name, pcdla.gl_date, pcdla.transferred_date transfer_date, gcck.concatenated_segments gl_account, pcdla.amount raw_cost, pcdla.burdened_cost, peia.quantity, peia.expenditure_item_id, pcdla.line_num distribution_line_num, xxen_util.meaning(pcdla.transfer_status_code,'TRANSFER STATUS',275) transfer_status, xxen_util.user_name(pcdla.created_by) created_by, pcdla.creation_date from pa_cost_distribution_lines_all pcdla, pa_expenditure_items_all peia, pa_expenditures_all pea, pa_projects_all ppa, pa_tasks pt, ap_invoices_all aia, ap_suppliers aps, gl_code_combinations_kfv gcck, hr_all_organization_units_vl haouv where 1=1 and pcdla.line_type='R' and peia.system_linkage_function='VI' and pcdla.expenditure_item_id=peia.expenditure_item_id and peia.expenditure_id=pea.expenditure_id and peia.project_id=ppa.project_id and peia.task_id=pt.task_id and peia.document_header_id=aia.invoice_id(+) and aia.vendor_id=aps.vendor_id(+) and pcdla.dr_code_combination_id=gcck.code_combination_id(+) and ppa.org_id=haouv.organization_id and haouv.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 haouv.name, ppa.segment1, pt.task_number, aps.vendor_name, aia.invoice_num Y PA AR PA تقرير تدقيق فاتورة المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تدقيق فاتورة المورد Application: المشروعات Source: AUD: تقرير تدقيق فاتورة المورد (بتنسيق XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG D PA Lieferantenrechnungen übertragen - Protokoll Imported from BI Publisher Description: Lieferantenrechnungen übertragen - Protokoll Application: Projects Source: PA: Lieferantenrechnungen übertragen - Protokoll (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG E PA Auditoría de Facturas del Proveedor Imported from BI Publisher Description: Informe de auditoría de facturas del proveedor Application: Projects Source: AUD: Auditoría de Facturas del Proveedor (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG F PA Etat d'audit de factures fournisseur Imported from BI Publisher Description: Etat d'audit de factures fournisseur Application: Projects Source: AUD : Etat d'audit de factures fournisseur (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG I PA rapporto Audit fattura fornitore Imported from BI Publisher Description: Rapporto Audit fattura fornitore Application: Projects Source: AUD: rapporto Audit fattura fornitore (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG JA PA 仕入先請求書監査レポート Imported from BI Publisher Description: 仕入先請求書監査レポート Application: Projects Source: AUD: 仕入先請求書監査レポート(XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG KO PA 공급자 송장 감사 보고서 Imported from BI Publisher Description: 공급자 송장 감사 보고서 Application: Projects Source: AUD: 공급자 송장 감사 보고서(XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG PTB PA Relatório de Auditoria da NFF do Fornecedor Imported from BI Publisher Description: Relatório de Auditoria da NFF do Fornecedor Application: Projetos Source: AUD: Relatório de Auditoria da NFF do Fornecedor (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG RU PA отчет об аудите счетов-фактур поставщиков Imported from BI Publisher Description: Отчет об аудите счетов-фактур поставщиков Application: Проекты Source: АУД: отчет об аудите счетов-фактур поставщиков (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG S PA Leverantörsfakturor - kontrollrapport Imported from BI Publisher Description: Leverantörsfakturor - kontrollrapport Application: Projects Source: AUD: Leverantörsfakturor - kontrollrapport (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG TR PA Tedarikçi Faturası Denetim Raporu Imported from BI Publisher Description: Tedarikçi Faturası Denetim Raporu Application: Proje Yönetimi Source: AUD: Tedarikçi Faturası Denetim Raporu (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG US PA Supplier Invoice Audit AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit. ZHS PA AUD：供应商发票审核报表 Imported from BI Publisher Description: 供应商发票审核报表 Application: 项目 Source: AUD：供应商发票审核报表 (XML) Short Name: PAXAUVIT_XML DB package: PA_PAXAUVIT_XMLP_PKG Enginatics 1=1 1 10 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) AR من تاريخ الأستاذ العام من تاريخ الأستاذ العام D Von RW-Datum Von RW-Datum E De Fecha Contable De fecha contable F Date GL - Du Date GL - Du I Data GL - Da Data GL - Da JA GL記帳日:自 GL記帳日:自 KO GL 일자: 부터 GL 일자: 부터 PTB Data GL - De Data GL - De RU Дата ГК с Дата ГК с S Från bokföringsdatum Från bokföringsdatum TR İlk GL Tarihi İlk GL Tarihi US Operating Unit ZHS 自 GL 日期 自 GL 日期 2 20 1=1 ppa.segment1=:project_number LOV custom Y Y select ppa.segment1 value, ppa.name description from pa_projects_all ppa where (:$flex$.operating_unit is null or ppa.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) order by ppa.segment1 AR إلى تاريخ الأستاذ العام إلى تاريخ الأستاذ العام D Bis RW-Datum Bis RW-Datum E A Fecha Contable A fecha contable F Date GL - Au Date GL - Au I Data GL - A Data GL - A JA GL記帳日:至 GL記帳日:至 KO GL 일자: 까지 GL 일자: 까지 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokföringsdatum Till bokföringsdatum TR Son GL Tarihi Son GL Tarihi US Project ZHS 至 GL 日期 至 GL 日期 3 30 1=1 aps.vendor_name=:vendor_name LOV custom Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where aps.enabled_flag='Y' order by aps.vendor_name AR من تاريخ التحويل من تاريخ التحويل D Von Transferdatum Von Transferdatum E De Fecha de Transferencia De fecha de transferencia F Date de transfert - Du Date de transfert - Du I Data trasferimento - Da Data trasferimento - Da JA 転送日:自 転送日:自 KO 이전 일자: 부터 이전 일자: 부터 PTB Data da Transferência - De Data da Transferência - De RU Дата переноса с Дата переноса с S Från överföringsdatum Från överföringsdatum TR İlk Transfer Tarihi İlk Transfer Tarihi US Vendor ZHS 自传送日期 自传送日期 4 40 1=1 pcdla.gl_date>=:gl_date_from Date AR إلى تاريخ التحويل إلى تاريخ التحويل D Bis Transferdatum Bis Transferdatum E A Fecha de Transferencia A fecha de transferencia F Date de transfert - Au Date de transfert - Au I Data trasferimento - A Data trasferimento - A JA 転送日:至 転送日:至 KO 이전 일자: 까지 이전 일자: 까지 PTB Data da Transferência - Até Data da Transferência - Até RU Дата переноса по Дата переноса по S Till överföringsdatum Till överföringsdatum TR Son Transfer Tarihi Son Transfer Tarihi US GL Date From ZHS 至传送日期 至传送日期 5 50 1=1 pcdla.gl_date<:gl_date_to+1 Date AR من حساب الأستاذ العام من حساب الأستاذ العام D Von RW-Konto Von RW-Konto E De Cuenta Contable De cuenta contable F Compte GL - De Compte GL - De I Conto GL - Da Conto GL - Da JA GL勘定科目:自 GL勘定科目:自 KO GL 계정: 부터 GL 계정: 부터 PTB Conta GL - De Conta GL - De RU Счет ГК с Счет ГК с S Från huvudbokskonto Från huvudbokskonto TR İlk GL Hesabı İlk GL Hesabı US GL Date To ZHS 自 GL 帐户 自 GL 帐户 :$flex$.operating_unit Operating Unit Project