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）限制的操作单元。 C6E085D4712C51A9E05362FB09050512Y SELECT p.project_id, p.labor_sch_type lab_sch_type_code, pal3.meaning labor_sch_type, p.non_labor_sch_type nonlab_sch_type_code, pal4.meaning non_labor_sch_type, irs1.ind_rate_sch_name rev_schedule, p.rev_ind_sch_fixed_date rev_fixed_date, irs2.ind_rate_sch_name inv_schedule, p.inv_ind_sch_fixed_date inv_fixed_date, dist.meaning distribution_rule, substr(per2tl.name,1,60) labor_bill_rate_org, sc1.std_bill_rate_schedule, pal1.meaning schedule_type, p.labor_schedule_discount|| decode(p.labor_schedule_discount,null,'','%') labor_schedule_discount, p.labor_schedule_fixed_date, substr(per3tl.name,1,60) non_labor_bill_rate_org, p.non_labor_std_bill_rate_schdl, pal2.meaning nl_schedule_type, p.non_labor_schedule_discount|| decode (p.non_labor_schedule_discount,null,'','%') non_labor_schedule_discount, p.non_labor_schedule_fixed_date, ifl.name invoice_labor_format_code, ife.name invoice_expense_format_code, ifr.name retention_format_code, ifb.name retention_billing_format_code, p.retention_percentage, p.invoice_comment, p.output_tax_code, p.retention_tax_code, decode(nvl(p.retn_accounting_flag,'N'),'Y','Yes','No') enable_enhanced_retn, p.baseline_funding_flag, p.revaluate_funding_flag, p.include_gains_losses_flag, rtrim(sc1.std_bill_rate_schedule) emp_bill_rate_schd, rtrim(sc3.std_bill_rate_schedule) job_bill_rate_schd, p.enable_top_task_customer_flag, p.enable_top_task_inv_mth_flag, p.revenue_accrual_method, p.invoice_method FROM pa_ind_rate_schedules irs1, pa_ind_rate_schedules irs2, pa_std_bill_rate_schedules sc1, pa_std_bill_rate_schedules sc2, pa_std_bill_rate_schedules sc3, pa_lookups pal1, pa_lookups pal2, pa_distribution_rules dist, pa_invoice_formats ifl, pa_invoice_formats ife, pa_invoice_formats ifr, pa_invoice_formats ifb, hr_org_units_no_join per2, hr_all_organization_units_tl per2tl, hr_org_units_no_join per3, hr_all_organization_units_tl per3tl, pa_projects p, pa_lookups pal3, pa_lookups pal4 WHERE (irs1.ind_rate_sch_id (+) = p.rev_ind_rate_sch_id and irs2.ind_rate_sch_id (+) = p.inv_ind_rate_sch_id and pal3.lookup_code (+) = p.labor_sch_type and pal3.lookup_type (+) = 'PROJECT SCHEDULE TYPE' and pal4.lookup_code (+) = p.non_labor_sch_type and pal4.lookup_type (+) = 'PROJECT SCHEDULE TYPE' and pal1.lookup_code (+) = sc1.schedule_type and pal1.lookup_type (+) = 'SCHEDULE TYPE' and pal2.lookup_code (+) = sc2.schedule_type and pal2.lookup_type (+) = 'SCHEDULE TYPE' and p.emp_bill_rate_schedule_id = sc1.bill_rate_sch_id (+) and p.job_bill_rate_schedule_id = sc3.bill_rate_sch_id (+) and p.non_labor_std_bill_rate_schdl = sc2.std_bill_rate_schedule (+) and dist.distribution_rule (+) = p.distribution_rule and ifl.invoice_format_id (+) = p.labor_invoice_format_id and ife.invoice_format_id (+) = p.non_labor_invoice_format_id and ifr.invoice_format_id (+) = p.retention_invoice_format_id and ifb.invoice_format_id (+) = p.retn_billing_inv_format_id and per2.organization_id (+) = p.job_bill_rate_schedule_id and per2tl.organization_id (+) = per2.organization_id and decode(per2tl.organization_id,null,'1',per2tl.language) = decode(per2tl.organization_id,null,'1',userenv('lang')) and per3.organization_id (+) = p.non_labor_bill_rate_org_id and per3tl.organization_id (+) = per3.organization_id and decode(per3tl.organization_id,null,'1',per3tl.language) = decode(per3tl.organization_id,null,'1',userenv('lang')) and :ptcc = 'CONTRACT' ) and (p.project_id=:project_id_1) PA PAXPRCON_XML AR PA تهيئة المشروع (بتنسيق XML) Imported from BI Publisher Description: تهيئة المشروع Application: المشروعات Source: AUD: تهيئة المشروع (بتنسيق XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG D PA Projektkonfiguration Imported from BI Publisher Description: Projektkonfiguration Application: Projects Source: PA: Projektkonfiguration (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG E PA Configuración del Proyecto Imported from BI Publisher Description: Configuración del proyecto Application: Projects Source: AUD: Configuración del Proyecto (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG F PA Configuration de projet Imported from BI Publisher Description: Configuration de projet Application: Projects Source: AUD : Configuration de projet (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG I PA Configurazione progetto Imported from BI Publisher Description: Configurazione del progetto Application: Projects Source: AUD: Configurazione progetto (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG JA PA プロジェクト構成 Imported from BI Publisher Description: プロジェクト構成 Application: Projects Source: AUD: プロジェクト構成(XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG KO PA 프로젝트 구성 Imported from BI Publisher Description: 프로젝트 구성 Application: Projects Source: AUD: 프로젝트 구성(XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG PTB PA Configuração do Projeto Imported from BI Publisher Description: Configuração do Projeto Application: Projetos Source: AUD: Configuração do Projeto (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG RU PA конфигурация проекта Imported from BI Publisher Description: Конфигурация проекта Application: Проекты Source: АУД: конфигурация проекта (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG S PA Projektkonfiguration Imported from BI Publisher Description: Projektkonfiguration Application: Projects Source: AUD: Projektkonfiguration (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG TR PA Proje Konfigürasyonu Imported from BI Publisher Description: Proje Konfigürasyonu Application: Proje Yönetimi Source: AUD: Proje Konfigürasyonu (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG US PA Project Configuration Imported from BI Publisher Description: Project Configuration Application: Projects Source: AUD: Project Configuration (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG ZHS PA AUD：项目配置 Imported from BI Publisher Description: 项目配置 Application: 项目 Source: AUD：项目配置 (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG BI Publisher :c_company_name_header :c_no_data_found :c_project_name :c_project_number :cp_bill_name :lp_ap_invoice_dist :lp_pa_cc_cost_xfer_audit :lp_pa_cost_dist_lines :lp_pa_cost_dist_lines_all :lp_pa_cost_xfer_audit :lp_pa_ei_denorm_v :lp_pa_events :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_costing :p_debug_mode :p_mrcsobtype :p_project_id :p_rule_optimizer :project_id_1 :ptcc 1 -20 :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' Y 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 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 3 10 :p_project_id LOV Oracle PA_SRS_PROJECT_AND_TEMPLATE_ID Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v order by project_number_sort_order Y AR رقم المشروع المشروع الذي يتم إعداد تقرير عن تكوين التفاصيل له D Projektnummer Das Projekt, für das die Detailkonfiguration ausgewertet werden soll E Número de Proyecto Proyecto correspondiente a la configuración de detalle que se va a incluir en el informe F Numéro de projet Projet pour lequel éditer la configuration détaillée I Numero progetto Progetto per il quale visualizzare nel rapporto la configurazione dettagliata JA プロジェクト番号 詳細構成のレポート対象プロジェクト KO 프로젝트 번호 상세한 구성을 보고할 프로젝트 PTB Nr. do Projeto O projeto para o qual deve ser informada a configuração do detalhe RU № проекта Проект, для которого создается отчет о подробной конфигурации S Projektnummer Projektet som detaljkonfigurationen ska rapporteras i TR Proje Numarası Detay konfigürasyonunu raporlama projesi US Project Number The project for which to report the detail configuration ZHS 项目编号 要报告其配置详细信息的项目