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）限制的操作单元。 C6E085D4712451A9E05362FB09050512Y SELECT nvl(uncst.org_id, -99) uncst_org_id, uncst.set_of_books_id uncst_sob, 'UnCosted Exceptions' unCst_warnings, uncst.period_name Period_unCst, uncst.exception_reason Exception_Reason_unCst, uncst.corrective_action Corrective_Action_unCst, uncst.denom_currency_code uncost_denom_currency_code, COUNT(*) unCst_ei_Lines, SUM(uncst.acct_burdened_amount) Total_acct_amount_unCst, SUM(uncst.denom_burdened_amount) Total_denom_amount_uncst, PA_PAXEXCPS_XMLP_PKG.cf_uncst_ou_nameformula(nvl ( uncst.org_id , - 99 )) CF_uncst_ou_name, PA_PAXEXCPS_XMLP_PKG.cf_uncst_sob_nameformula(uncst.set_of_books_id) CF_uncst_sob_name FROM pa_gl_uncost_except_sum_v uncst, pa_implementations imp WHERE :calling_mode = 'PA' AND nvl(imp.org_id,-99) = nvl(uncst.org_id,-99) and uncst.set_of_books_id = imp.set_of_books_id and ( (uncst.system_linkage_function <> 'PJ' and uncst.expenditure_item_date BETWEEN :start_date AND :end_date) OR ( uncst.system_linkage_function = 'PJ' and NVL(uncst.prvdr_accrual_date,uncst.expenditure_item_date ) BETWEEN :start_date AND :end_date ) ) and ( nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'N' OR (nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'Y' and (nvl(imp.same_pa_gl_period,'N') in ('N', 'Y')) ) ) GROUP BY uncst.org_id,uncst.set_of_books_id ,3, uncst.period_name, uncst.exception_reason, uncst.denom_currency_code, uncst.corrective_action UNION SELECT nvl(uncst.org_id, -99) uncst_org_id, uncst.set_of_books_id uncst_sob, 'UnCosted Exceptions' unCst_warnings, uncst.period_name Period_unCst, uncst.exception_reason Exception_Reason_unCst, uncst.corrective_action Corrective_Action_unCst, uncst.denom_currency_code uncost_denom_currency_code, COUNT(*) unCst_ei_Lines, SUM(uncst.acct_burdened_amount) Total_acct_amount_unCst, SUM(uncst.denom_burdened_amount) Total_denom_amount_uncst, --ADDED PA_PAXEXCPS_XMLP_PKG.cf_uncst_ou_nameformula(nvl ( uncst.org_id , - 99 )) CF_uncst_ou_name, PA_PAXEXCPS_XMLP_PKG.cf_uncst_sob_nameformula(uncst.set_of_books_id) CF_uncst_sob_name FROM pa_gl_uncost_except_sum_v uncst WHERE :calling_mode = 'GL' and ( (uncst.system_linkage_function <> 'PJ' and uncst.expenditure_item_date BETWEEN :start_date AND :end_date) OR ( uncst.system_linkage_function = 'PJ' and NVL(uncst.prvdr_accrual_date,uncst.expenditure_item_date ) BETWEEN :start_date AND :end_date ) ) and nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') = 'Y' and nvl(uncst.same_pa_gl_period ,'N') in ('N', 'Y') and ( (:across_ous = 'Y' and set_of_books_id = (select set_of_books_id from pa_implementations where org_id=nvl(org_id ,-99)) ) OR ( :across_ous = 'N' and nvl(uncst.org_id ,-99) = ( select nvl(paimp.org_id,-99) from pa_implementations paimp) ) ) GROUP BY uncst.org_id,uncst.set_of_books_id ,3, uncst.period_name, uncst.exception_reason, uncst.denom_currency_code, uncst.corrective_action PA PAXEXGLS_XML AR PA إجمالي استثناء الحركات حسب فترة الأستاذ العام (بتنسيق XML) Imported from BI Publisher Description: إجمالي استثناء الحركة حسب فترة الأستاذ العام Application: المشروعات Source: EXC: إجمالي استثناء الحركات حسب فترة الأستاذ العام (بتنسيق XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG D PA Transaktionsausnahmen - Übersicht nach RW-Periode Imported from BI Publisher Description: Übersicht der Transaktionsausnahmen nach RW-Periode Application: Projects Source: AUS: Transaktionsausnahmen - Übersicht nach RW-Periode (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG E PA Resumen de Excepciones de Transacciones por Período Contable Imported from BI Publisher Description: Resumen de excepciones de transacciones por período contable Application: Projects Source: EXC: Resumen de Excepciones de Transacciones por Período Contable (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG F PA Synthèse des anomalies de mouvement par période GL Imported from BI Publisher Description: Synthèse des anomalies de mouvement par période GL Application: Projects Source: EXC : Synthèse des anomalies de mouvement par période GL (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG I PA Sintetico eccezioni transazione per periodo GL Imported from BI Publisher Description: Sintetico delle eccezioni transazione per periodo GL Application: Projects Source: EXC: Sintetico eccezioni transazione per periodo GL (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG JA PA GL期間別取引例外要約 Imported from BI Publisher Description: GL期間別取引例外要約 Application: Projects Source: EXC: GL期間別取引例外要約(XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG KO PA GL 기간별 거래 예외 요약 Imported from BI Publisher Description: GL 기간별 거래 예외 요약 Application: Projects Source: EXC: GL 기간별 거래 예외 요약(XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG PTB PA Sumário de Exceção da Transação por Período GL Imported from BI Publisher Description: Sumário de Exceções da Transação por Período GL Application: Projetos Source: EXC: Sumário de Exceção da Transação por Período GL (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG RU PA сводка исключений транзакции по периоду ГК Imported from BI Publisher Description: Сводка исключений транзакции по периоду ГК Application: Проекты Source: EXC: сводка исключений транзакции по периоду ГК (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG S PA Undantagsöversikt för transaktion per redovisningsperiod Imported from BI Publisher Description: Undantagsöversikt för transaktion per redovisningsperiod Application: Projects Source: Undantag: Undantagsöversikt för transaktion per redovisningsperiod (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG TR PA GL Dönemine Göre İşlem İstisna Özeti Imported from BI Publisher Description: GL Dönemine Göre İşlem İstisnaları Özeti Application: Proje Yönetimi Source: EXC: GL Dönemine Göre İşlem İstisna Özeti (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG US PA Transaction Exception Summary by GL Period Imported from BI Publisher Description: Transaction Exceptions Summary by GL Period Application: Projects Source: EXC: Transaction Exception Summary by GL Period (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG ZHS PA EXC：按 GL 期间列出的事务处理例外汇总 Imported from BI Publisher Description: 按 GL 期间列出的事务处理例外汇总 Application: 项目 Source: EXC：按 GL 期间列出的事务处理例外汇总 (XML) Short Name: PAXEXGLS_XML DB package: PA_PAXEXCPS_XMLP_PKG BI Publisher :across_ous :c_company_name_header :c_dummy_data :c_no_data_found :calling_mode :cp_ou_name :end_date :end_period :operating_unit :org_id1 :p_conc_request_id :p_debug_mode :p_min_precision :p_rule_optimizer :start_date :start_period 1 -20 :calling_mode Char GL Y AR طور الطلب طور الطلب D Aufrufmodus Aufrufmodus E Modo de Llamada Modo de llamada F Mode d'appel Mode d'appel I Modalità di chiamata Modalità di chiamata JA 呼出しモード 呼出しモード KO 호출 모드 호출 모드 PTB Modo de Chamada Modo de Chamada RU Режим вызова Режим вызова S Anropsläge Anropsläge TR Çağrı Modu Çağrı Modu US Calling Mode Calling Mode 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 :start_period LOV Oracle PA_SRS_EXCPS_GL_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where application_id=8721 and nvl(adjustment_period_flag,'N')='N' and set_of_books_id=(select set_of_books_id from pa_implementations) and closing_status in ('O','F','W') order by end_date Y AR من فترة الأستاذ العام فترة البداية D Von RW-Periode Erste Periode E De Período Contable Período de inicio F Période GL - De Période de début I Periodo GL - Da Periodo iniziale JA GL期間:自 開始期間 KO GL 기간: 부터 시작 기간 PTB Período GL - De Período inicial RU Период ГК с Начальный период S Från redovisningsperiod Startperiod TR İlk GL Dönemi Başlangıç dönemi US From GL Period Starting period ZHS 自 GL 期间 起始期间 4 20 :end_period LOV Oracle PA_SRS_EXCPS_GL_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where application_id=8721 and nvl(adjustment_period_flag,'N')='N' and set_of_books_id=(select set_of_books_id from pa_implementations) and closing_status in ('O','F','W') order by end_date Y AR إلى فترة الأستاذ العام فترة النهاية D Bis RW-Periode Letzte Periode E A Período Contable Período de finalización F Période GL - A Période de fin I Periodo GL - A Periodo finale JA GL期間:至 終了期間 KO GL 기간: 까지 종료 기간 PTB Período GL - Até Período final RU Период ГК по Конечный период S Till redovisningsperiod Slutperiod TR Son GL Dönemi Bitiş dönemi US To GL Period Ending period ZHS 至 GL 期间 终止期间 5 30 :across_ous 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 Y AR إظهار استثناءات الحركة عبر وحدات التشغيل إظهار استثناءات الحركة عبر وحدات التشغيل D Transaktionsausnahmen in allen Betriebseinheiten anzeigen Transaktionsausnahmen in allen Betriebseinheiten anzeigen E Mostrar Excepciones de Transacciones de todas las Unidades Operativas Mostrar excepciones de transacciones de todas las unidades operativas F Afficher les anomalies de mouvement dans toutes les unités opérationnelles Afficher les anomalies de mouvement dans toutes les unités opérationnelles I Mostra eccezioni transazione tra unità operative Mostra le eccezioni transazione tra le unità operative JA 複数営業単位の取引例外の表示 複数営業単位の取引例外の表示 KO 운영 단위간 트랜잭션 예외 표시 운영 단위간 트랜잭션 예외 표시 PTB Mostrar Exceções da Transação através das Unidades Operacionais Mostrar Exceções da Transação através das Unidades Operacionais RU Показать искл. транз. по всем опер. единицам Показать исключения транзакции по всем операционным единицам S Visa transaktionsundantag över operativa enheter Visa transaktionsundantag över operativa enheter TR Faaliyet Birimlerindeki İşlem İstisnalarını Göster Faaliyet Birimlerindeki İşlem İstisnalarını Göster US Show Transaction Exceptions Across Operating Units Show Transaction Exceptions Across Operating Units ZHS 显示各业务实体之间的事务处理例外 显示各业务实体之间的事务处理例外