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）限制的操作单元。 B41A694502D9F493E053B46B63582C25 select cv.project_type project_type ,cv.project_number project_number ,cv.project_name project_name ,cv.project_id project_id ,0+cv.expensed -(DECODE(pa_mc_currency_pkg.get_mrc_sob_type_code, 'R',0, nvl(rv.retirable_cost,0))) expensed_amount ,0+cv.cip_cost CIP_Amount ,0+cv.capitalized_cost interfaced_CIP_Amount ,0+DECODE(pa_mc_currency_pkg.get_mrc_sob_type_code, 'R',null, nvl(rv.rwip,0))rwip_amount ,0+ (DECODE(pa_mc_currency_pkg.get_mrc_sob_type_code, 'R',null, nvl(rv.retired_cost,0)))interfaced_rwip_amount ,0+cv.total_costs total_amount ,cv.project_organization project_organization, PA_PACRCAPS_XMLP_PKG.CP_project_id_p CP_project_id from pa_capital_projects_v cv, (select sum(retirable_cost) retirable_cost ,sum(retired_cost) retired_cost ,sum(retirable_cost - retired_cost) rwip ,project_id from pa_retirement_costs_v where nvl(:p_project_type,project_type)=project_type and nvl(:p_project_id,project_id)=project_id and nvl(:p_project_org,carrying_out_organization_id)=carrying_out_organization_id and (:p_class_category IS NULL OR project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category) ) and (:p_class_category IS NULL OR :p_class_code IS NULL OR project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category AND class_code = :p_class_code)) group by project_id) rv where rv.project_id(+)=cv.project_id and nvl(:p_project_type,cv.project_type)=cv.project_type and nvl(:p_project_id,cv.project_id)=cv.project_id and nvl(:cp_project_org,cv.project_organization)=cv.project_organization and (:p_class_category IS NULL OR cv.project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category) ) and (:p_class_category IS NULL OR :p_class_code IS NULL OR cv.project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category AND class_code = :p_class_code)) ORDER BY project_type,project_organization Y PA PACRCAPS_XML AR PA تقرير إجمالي المشروعات الرأسمالية (بتنسيق XML) Imported from BI Publisher Description: تقرير لعرض مبالغ إجمالي المشروعات الرأسمالية Application: المشروعات Source: MGT: تقرير إجمالي المشروعات الرأسمالية (بتنسيق XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG D PA Investitionsprojekte - Übersicht Imported from BI Publisher Description: Auswertung für die Anzeige von Investitionsprojektsummen Application: Projects Source: PA: Investitionsprojekte - Übersicht (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG E PA Resumen de Proyecto de Capital Imported from BI Publisher Description: Informe para consultar los importes resumen de proyecto de capital Application: Projects Source: MGT: Resumen de Proyecto de Capital (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG F PA Etat de synthèse de projet d'investissement Imported from BI Publisher Description: Etat permettant de voir les montants de synthèse des projets d'investissement Application: Projects Source: MGT : Etat de synthèse de projet d'investissement (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG I PA rapporto Sintetico progetto in conto capitale Imported from BI Publisher Description: Rapporto che visualizza gli importi del sintetico del progetto in conto capitale Application: Projects Source: MGT: rapporto Sintetico progetto in conto capitale (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG JA PA 資産プロジェクト要約レポート Imported from BI Publisher Description: 資産プロジェクト要約金額を表示するためのレポート Application: Projects Source: MGT: 資産プロジェクト要約レポート(XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG KO PA 자본 프로젝트 요약 보고서 Imported from BI Publisher Description: 자본 프로젝트 요약 금액 조회를 위한 보고서 Application: Projects Source: MGT: 자본 프로젝트 요약 보고서(XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG PTB PA Relatório Resumido do Projeto de Capital Imported from BI Publisher Description: Relatório para exibir quantias do sumário do projeto de capital Application: Projetos Source: MGT: Relatório Resumido do Projeto de Capital (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG RU PA сводный отчет об основном проекте Imported from BI Publisher Description: Отчет для просмотра сводных сумм по основному проекту Application: Проекты Source: УПР: сводный отчет об основном проекте (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG S PA Översiktsrapport för kapitalprojekt Imported from BI Publisher Description: Rapport för granskning av summerade belopp för kapitalprojekt Application: Projects Source: MGT: Översiktsrapport för kapitalprojekt (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG TR PA Sermaye Proje Özeti Raporu Imported from BI Publisher Description: Sermaye proje özeti tutarlarını görüntülemek için rapor Application: Proje Yönetimi Source: MGT: Sermaye Proje Özeti Raporu (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG US PA Capital Project Summary Imported from BI Publisher Description: Report for viewing capital project summary amounts Application: Projects Source: MGT: Capital Project Summary Report (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG ZHS PA MGT：资本项目汇总报表 Imported from BI Publisher Description: 用于查看资本项目汇总额的报表 Application: 项目 Source: MGT：资本项目汇总报表 (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG BI Publisher :cp_company_name :cp_project_id :cp_project_number :cp_project_org :operating_unit :p_class_category :p_class_code :p_conc_request_id :p_debug_mode :p_project_id :p_project_org :p_project_type 1 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 2 10 :p_project_type LOV Oracle PA_SRS_PROJECT_TYPE_CAPITAL Y select project_type id, project_type value, description description from pa_project_types where project_type_class_code='CAPITAL' order by project_type AR نوع المشروع D Projektart E Tipo de Proyecto F Type de projet I Tipo di progetto JA プロジェクト・タイプ KO 프로젝트 유형 PTB Tipo de Projeto RU Тип проекта S Projekttyp TR Proje Tipi US Project Type ZHS 项目类型 3 20 :p_project_id LOV Oracle PA_SRS_PROJECT_ID_CAPITAL 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='CAPITAL' and 'Y' in (select pa_utils.initialize from sys.dual) order by project_number_sort_order AR رقم المشروع D Projektnummer E Número de Proyecto F Numéro de projet I Numero progetto JA プロジェクト番号 KO 프로젝트 번호 PTB Nr. do Projeto RU № проекта S Projektnummer TR Proje Numarası US Project Number ZHS 项目编号 4 30 :p_project_org LOV Oracle PA_SRS_PROJECT_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_project_v where active_flag='Y' order by value,description AR تنظيم المشروع D Projektorganisation E Organización del Proyecto F Organisation du projet I Organizzazione progetto JA プロジェクト組織 KO 프로젝트 조직 PTB Organização do Projeto RU Проектная организация S Projektorganisation TR Proje Organizasyonu US Project Organization ZHS 项目组织 5 40 :p_class_category LOV Oracle PA_SRS_CAP_CLASS_CATEGORY Y select class_category id, class_category value, description description from pa_class_categories where class_category in (select cc.class_category from pa_class_categories cc ,pa_valid_categories vc ,pa_project_types_all ppta where cc.class_category=vc.class_category and vc.object_type_id=ppta.project_type_id union select cc1.class_category from pa_class_categories cc1 where cc1.object_type='PA_PROJECTS' and cc1.all_types_valid_flag='Y' and not exists (select 'Y' from pa_valid_categories vc1 ,pa_project_types_all ppta1 where vc1.class_category=cc1.class_category and vc1.object_type_id=ppta1.project_type_id)) order by 1 AR فئة الطبقة D Klassenkategorie E Categoría de Clase F Catégorie de classe I Categoria classe JA 区分カテゴリ KO 분류 범주 PTB Categoria da Classe RU Категория класса S Klasskategori TR Sınıf Kategorisi US Class Category ZHS 分类类别 6 50 :p_class_code LOV Oracle PA_SRS_CAP_CLASS_CODE Y select class_code id, class_code value, description description from pa_class_codes where class_category=:$flex$.pa_srs_cap_class_category and (trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)) order by class_code AR رمز الطبقة D Klassenschlüssel E Código de Clase F Code classe I Codice classe JA 区分コード KO 분류 코드 PTB Código da Classe RU Код класса S Klasskod TR Sınıf Kodu US Class Code ZHS 分类代码 :$flex$.pa_srs_cap_class_category Class Category Class Code