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）限制的操作单元。 C6E085D4713051A9E05362FB09050512 SELECT HRO.NAME Project_Organization, PROJ.Segment1 Project_Number, BT.Budget_Type Budget_Type, (SELECT SUM(BAL.BUDGET_PERIOD_TO_DATE) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) Original_Budget_Amount, (SELECT SUM(DECODE(BAL.BALANCE_TYPE,'REQ',BAL.ENCUMB_PERIOD_TO_DATE,0)) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) Commitments, (SELECT SUM(DECODE(BAL.BALANCE_TYPE,'PO',BAL.ENCUMB_PERIOD_TO_DATE,0)) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) Obligations, (SELECT SUM(DECODE(BAL.BALANCE_TYPE,'AP',BAL.ENCUMB_PERIOD_TO_DATE,0)) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) Invoices, (SELECT SUM(DECODE(BAL.BALANCE_TYPE,'EXP',BAL.ACTUAL_PERIOD_TO_DATE,0)) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) Expenditures, NVL(BCO.REVISE_BUDGET_AMOUNT,0) Unconsumed_Funds, ((SELECT SUM(BAL.BUDGET_PERIOD_TO_DATE) FROM PA_BC_BALANCES BAL, PA_Implementations IMP WHERE BAL.budget_version_id = PBV2.budget_version_id AND BAL.Set_Of_Books_ID = IMP.Set_Of_Books_ID AND IMP.org_id = PROJ.org_id AND BAL.Start_Date IN (SELECT GPS.Start_Date FROM GL_Period_Statuses GPS, GL_Sets_Of_Books SOB WHERE GPS.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND SOB.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS.APPLICATION_ID = 101 AND GPS.PERIOD_YEAR = (SELECT GPS2.PERIOD_YEAR FROM GL_Period_Statuses GPS2 WHERE GPS2.SET_OF_BOOKS_ID = IMP.Set_Of_Books_ID AND GPS2.APPLICATION_ID = 101 AND GPS2.PERIOD_NAME = BCO.REVISE_BUDGET_PERIOD AND NVL(GPS2.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) AND GPS.Period_Type = SOB.Accounted_Period_Type AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG,'N') <> 'Y' ) GROUP BY BAL.budget_version_id) - NVL(BCO.REVISE_BUDGET_AMOUNT,0)) Revised_Budget_Amount, CASE WHEN PBV1.WF_STATUS_CODE IS NOT NULL THEN (SELECT MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE ='WF_STATUS_CODE' AND LOOKUP_CODE = PBV1.WF_STATUS_CODE) WHEN PBV1.WF_STATUS_CODE IS NULL AND PBV1.LAST_UPDATE_DATE > PBV2.CREATION_DATE THEN (SELECT MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE ='BUDGET STATUS' AND LOOKUP_CODE = PBV1.BUDGET_STATUS_CODE) WHEN PBV1.WF_STATUS_CODE IS NULL AND PBV1.LAST_UPDATE_DATE <= PBV2.CREATION_DATE THEN (SELECT MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE ='BUDGET STATUS' AND LOOKUP_CODE = PBV2.BUDGET_STATUS_CODE) ELSE (SELECT MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE ='BUDGET STATUS' AND LOOKUP_CODE = PBV1.BUDGET_STATUS_CODE) END Budget_Status_Post_Revision FROM PA_Projects_All PROJ, PA_Budget_Types BT, PA_Budgetary_Control_Options BCO, PA_BUDGET_VERSIONS PBV1, PA_BUDGET_VERSIONS PBV2, HR_ALL_ORGANIZATION_UNITS HRO WHERE BCO.REVISE_BUDGET_FLAG = 'S' AND BCO.REVISE_BUDGET_REQUEST_ID = :P_Conc_Request_ID AND PROJ.Carrying_Out_Organization_ID = NVL(:P_Organization_ID, PROJ.Carrying_Out_Organization_ID) AND PROJ.Carrying_Out_Organization_ID = HRO.ORGANIZATION_ID AND BCO.Project_ID = PROJ.Project_ID AND BCO.Budget_Type_Code = BT.Budget_Type_Code AND PBV1.PROJECT_ID = PROJ.Project_ID AND PBV1.Budget_Type_Code = BCO.Budget_Type_Code AND PBV1.BUDGET_STATUS_CODE IN ('S', 'W') AND PBV2.PROJECT_ID = PROJ.Project_ID AND PBV2.Budget_Type_Code = BCO.Budget_Type_Code AND PBV2.BUDGET_STATUS_CODE = 'B' AND PBV2.CURRENT_FLAG = 'Y' order by 1,2 Y PA PAXREVBU AR PA مراجعة موازنة المشروع لاستهلاك Imported from BI Publisher Description: تقرير مراجعة موازنة مشروع لاستهلاك (بتنسيق XML) Application: المشروعات Source: AUD: مراجعة موازنة المشروع لاستهلاك Short Name: PAXREVBU DB package: D PA Projektbudget zum Verbrauch ändern Imported from BI Publisher Description: Auswertung "Projektbudget zum Verbrauch ändern" (XML) Application: Projects Source: PA: Projektbudget zum Verbrauch ändern Short Name: PAXREVBU DB package: E PA Revisar Presupuesto de Proyecto para Consumo Imported from BI Publisher Description: Revisar presupuesto de proyecto para consumo (XML) Application: Projects Source: AUD: Revisar Presupuesto de Proyecto para Consumo Short Name: PAXREVBU DB package: F PA Réviser un budget de projet par rapport à la consommation Imported from BI Publisher Description: Etat de révision de budgets de projet par rapport à la consommation (XML) Application: Projects Source: AUD : Réviser un budget de projet par rapport à la consommation Short Name: PAXREVBU DB package: I PA Rivedi budget progetto vs. consumo Imported from BI Publisher Description: Rapporto Rivedi budget progetto vs. consumo (XML) Application: Projects Source: AUD: Rivedi budget progetto vs. consumo Short Name: PAXREVBU DB package: JA PA プロジェクト予算対使用の訂正 Imported from BI Publisher Description: プロジェクト予算対使用の訂正レポート(XML) Application: Projects Source: AUD: プロジェクト予算対使用の訂正 Short Name: PAXREVBU DB package: KO PA 소비 대 프로젝트 예산 개정 Imported from BI Publisher Description: 소비 대 프로젝트 예산 개정 보고서(XML) Application: Projects Source: AUD: 소비 대 프로젝트 예산 개정 Short Name: PAXREVBU DB package: PTB PA Revisar Orçamento do Projeto até Consumo Imported from BI Publisher Description: Relatório Revisar Orçamento do Projeto até Consumo (XML) Application: Projetos Source: AUD: Revisar Orçamento do Projeto até Consumo Short Name: PAXREVBU DB package: RU PA пересмотр бюджета проекта по потреблению Imported from BI Publisher Description: Отчет о пересмотре бюджета проекта по потреблению (XML) Application: Проекты Source: АУД: пересмотр бюджета проекта по потреблению Short Name: PAXREVBU DB package: S PA Revidera projektbudget till konsumtion Imported from BI Publisher Description: Revidera projektbudget till konsumtion - rapport (XML) Application: Projects Source: AUD: Revidera projektbudget till konsumtion Short Name: PAXREVBU DB package: TR PA Proje Bütçesini Tüketim Olarak Revize Et Imported from BI Publisher Description: Proje Bütçesini Tüketim Olarak Revize Etme Raporu (XML) Application: Proje Yönetimi Source: AUD: Proje Bütçesini Tüketim Olarak Revize Et Short Name: PAXREVBU DB package: US PA Revise Project Budget To Consumption Imported from BI Publisher Description: Revise Project Budget To Consumption Report (XML) Application: Projects Source: AUD: Revise Project Budget To Consumption Short Name: PAXREVBU DB package: ZHS PA AUD：根据冲减修订项目预算 Imported from BI Publisher Description: 根据冲减修订项目预算报表 (XML) Application: 项目 Source: AUD：根据冲减修订项目预算 Short Name: PAXREVBU DB package: BI Publisher :operating_unit :p_conc_request_id :p_organization_id 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