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）限制的操作单元。 C6E085D4712351A9E05362FB09050512Y SELECT imp.org_id cst_org_id, 'Costing Exceptions' Cst_Exceptions, cst.period_name Period_Cst, cst.exception_reason Exception_Reason_Cst, DECODE(cst.vendor_number, NULL, cst.person_name, cst.vendor_number) Vendor_Employee, cst.project_number Project_Cst, cst.task_number Task_Cst, cst.expenditure_type Expenditure_Type_Cst, cst.expenditure_item_date EI_Date, cst.quantity quantity_cst, substr(cst.expenditure_group,1,20) Group_Name, cst.amount Amount_Cst, cst.denom_currency_code denom_curr_code_cst, cst.denom_amount denom_amount_cst, lk.meaning unit_cst, PA_PAXEXCPD_XMLP_PKG.cf_cst_ou_nameformula(imp.org_id) CF_cst_ou_name FROM pa_cost_exceptions_det_v cst, pa_expenditure_types et, pa_lookups lk, pa_exception_reasons pl, pa_implementations imp, pa_projects_all pp WHERE cst.expenditure_type = et.expenditure_type AND NVL(cst.unit_of_measure,et.unit_of_measure) = lk.lookup_code AND lk.lookup_type = 'UNIT' AND cst.pa_date BETWEEN nvl(:start_date, cst.pa_date) AND nvl(:end_date, cst.pa_date) AND cst.exception_reason = pl.exception_reason AND :exception_type = 'COST_EXCP' AND pl.exception_category = 'COST_EXCP' AND pl.exception_code = :p_exception_reason AND :p_exception_reason is not null AND :calling_mode = 'PA' --AND :calling_mode_1 = 'PA' AND nvl(imp.org_id, -99) = nvl(pp.org_id ,-99) AND pp.project_id = cst.project_id /* AND ( :pa_new_gl_date = 'N' OR ( :pa_new_gl_date = 'Y' and nvl(imp.same_pa_gl_period , 'N') = 'Y' ) )*/ UNION SELECT imp.org_id cst_org_id, 'Costing Exceptions' Cst_Exceptions, cst.period_name Period_Cst, cst.exception_reason Exception_Reason_Cst, DECODE(cst.vendor_number, NULL, cst.person_name, cst.vendor_number) Vendor_Employee, cst.project_number Project_Cst, cst.task_number Task_Cst, cst.expenditure_type Expenditure_Type_Cst, cst.expenditure_item_date EI_Date, cst.quantity quantity_cst, substr(cst.expenditure_group,1,20) Group_Name, cst.amount Amount_Cst, cst.denom_currency_code denom_curr_code_cst, cst.denom_amount denom_amount_cst, lk.meaning unit_cst, PA_PAXEXCPD_XMLP_PKG.cf_cst_ou_nameformula(imp.org_id) CF_cst_ou_name FROM pa_cost_exceptions_det_v cst, pa_expenditure_types et, pa_lookups lk, pa_implementations imp, pa_projects_all pp WHERE cst.expenditure_type = et.expenditure_type AND NVL(cst.unit_of_measure,et.unit_of_measure) = lk.lookup_code AND lk.lookup_type = 'UNIT' AND cst.pa_date BETWEEN nvl(:start_date, cst.pa_date) AND nvl(:end_date, cst.pa_date) AND nvl(:exception_type, 'COST_EXCP') = 'COST_EXCP' AND :p_exception_reason is null AND :calling_mode = 'PA' --AND :calling_mode_1 = 'PA' AND nvl(imp.org_id, -99) = nvl(pp.org_id ,-99) AND pp.project_id = cst.project_id /*AND ( :pa_new_gl_date = 'N' OR ( :pa_new_gl_date = 'Y' and nvl(imp.same_pa_gl_period , 'N') = 'Y' ) )*/ UNION SELECT cst.org_id cst_org_id, 'Costing Exceptions' Cst_Exceptions, cst.period_name Period_Cst, cst.exception_reason Exception_Reason_Cst, DECODE(cst.vendor_number, NULL, cst.person_name, cst.vendor_number) Vendor_Employee, cst.project_number Project_Cst, cst.task_number Task_Cst, cst.expenditure_type Expenditure_Type_Cst, cst.expenditure_item_date EI_Date, cst.quantity quantity_cst, substr(cst.expenditure_group,1,20) Group_Name, cst.amount Amount_Cst, cst.denom_currency_code denom_curr_code_cst, cst.denom_amount denom_amount_cst, lk.meaning unit_cst, PA_PAXEXCPD_XMLP_PKG.cf_cst_ou_nameformula(cst.org_id) CF_cst_ou_name FROM pa_gl_cost_except_det_v cst, pa_expenditure_types et, pa_lookups lk WHERE cst.expenditure_type = et.expenditure_type AND NVL(cst.unit_of_measure,et.unit_of_measure) = lk.lookup_code AND lk.lookup_type = 'UNIT' AND cst.gl_date BETWEEN nvl(:start_date, cst.gl_date) AND nvl(:end_date, cst.gl_date) AND ( ( nvl(:exception_type, 'COST_EXCP') = 'COST_EXCP' AND :p_exception_reason is null ) OR ( cst.exception_reason in ( select pl.exception_reason from pa_exception_reasons pl where pl.exception_category = 'COST_EXCP' and pl.exception_code = :p_exception_reason ) AND :exception_type = 'COST_EXCP' AND :p_exception_reason is not null ) ) AND :calling_mode = 'GL' --AND :calling_mode_1 = 'GL' AND :pa_new_gl_date = 'Y' AND nvl(cst.same_pa_gl_period , 'N') in ('N', 'Y') AND ( ( :across_ous = 'Y' and Exists (Select 1 From HR_ORG_UNITS_NO_JOIN hr Where hr.ORGANIZATION_ID = cst.org_id ) 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(cst.org_id,-99) = :org_id1 ) ) ORDER BY cst_org_id,period_cst, exception_reason_cst, denom_curr_code_cst PA PAXEXGLD_XML AR PA تفاصيل استثناء الحركة حسب فترة الأستاذ العام (بتنسيق XML) Imported from BI Publisher Description: تفاصيل استثناء الحركة حسب فترة الأستاذ العام Application: المشروعات Source: EXC: تفاصيل استثناء الحركة حسب فترة الأستاذ العام (بتنسيق XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG D PA Transaktionsausnahmen - Details nach RW-Periode Imported from BI Publisher Description: Details der Transaktionsausnahmen nach RW-Periode Application: Projects Source: AUS: Transaktionsausnahmen - Details nach RW-Periode (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG E PA Detalles de Excepciones de Transacciones por Período Contable Imported from BI Publisher Description: Detalles de excepciones de transacción por período contable Application: Projects Source: EXC: Detalles de Excepciones de Transacciones por Período Contable (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG F PA Détails des anomalies de mouvement par période GL Imported from BI Publisher Description: Détails des anomalies de mouvement par période GL Application: Projects Source: EXC : Détails des anomalies de mouvement par période GL (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG I PA Dettagli eccezioni transazione per periodo GL Imported from BI Publisher Description: Dettagli delle eccezioni transazione per periodo GL Application: Projects Source: EXC: Dettagli eccezioni transazione per periodo GL (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG JA PA GL期間別取引例外詳細 Imported from BI Publisher Description: GL期間別取引例外詳細 Application: Projects Source: EXC: GL期間別取引例外詳細(XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG KO PA GL 기간별 거래 예외 상세내역 Imported from BI Publisher Description: GL 기간별 거래 예외 상세내역 Application: Projects Source: EXC: GL 기간별 거래 예외 상세내역(XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG PTB PA Detalhes da Exceção da Transação por Período GL Imported from BI Publisher Description: Detalhes da Exceção da Transação por Período GL Application: Projetos Source: EXC: Detalhes da Exceção da Transação por Período GL (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG RU PA сведения об исключениях транзакции по периоду ГК Imported from BI Publisher Description: Сведения об исключениях транзакции по периоду ГК Application: Проекты Source: EXC: сведения об исключениях транзакции по периоду ГК (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG S PA Undantagsdetaljer för transaktion per redovisningsperiod Imported from BI Publisher Description: Undantagsdetaljer för transaktion per redovisningsperiod Application: Projects Source: Undantag: Undantagsdetaljer för transaktion per redovisningsperiod (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG TR PA GL Dönemine Göre İşlem İstisna Detayları Imported from BI Publisher Description: GL Dönemine Göre İşlem İstisnası Detayları Application: Proje Yönetimi Source: EXC: GL Dönemine Göre İşlem İstisna Detayları (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG US PA Transaction Exception Details by GL Period Imported from BI Publisher Description: Transaction Exception Details by GL Period Application: Projects Source: EXC: Transaction Exception Details by GL Period (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_XMLP_PKG ZHS PA EXC：按 GL 期间列出的事务处理例外详细信息 Imported from BI Publisher Description: 按 GL 期间列出的事务处理例外详细信息 Application: 项目 Source: EXC：按 GL 期间列出的事务处理例外详细信息 (XML) Short Name: PAXEXGLD_XML DB package: PA_PAXEXCPD_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 :exception_type :operating_unit :org_id1 :p_conc_request_id :p_debug_mode :p_exception_reason :p_rule_optimizer :pa_new_gl_date :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 :exception_type LOV Oracle PA_SRS_EXCPS_GL_CATEGORY Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='EXCP_LEVEL_TYPE' and enabled_flag='Y' order by value,description AR فئة الاستثناء فئة الاستثناء D Ausnahmekategorie Ausnahmekategorie E Categoría de Excepción Categoría de excepción F Catégorie d'exception Catégorie d'exception I Categoria eccezione Categoria dell'eccezione JA 例外カテゴリ 例外カテゴリ KO 예외 범주 예외 범주 PTB Categoria de Exceção Categoria de exceção RU Категория исключений Категория исключения S Undantagskategori Undantagskategori TR İstisna Kategorisi İstisna kategorisi US Exception Category Exception category ZHS 例外类别 例外类别 6 40 :p_exception_reason LOV Oracle PA_SRS_EXCEPTION_GL_REASON Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type=:$flex$.pa_srs_excps_gl_category and enabled_flag='Y' order by value,description AR سبب الاستثناء سبب الاستثناء D Ausnahmegrund Ausnahmegrund E Motivo de Excepción Motivo de excepción F Motif d'exception Motif d'exception I Motivo eccezione Motivo eccezione JA 例外事由 例外事由 KO 예외 사유 예외 사유 PTB Motivo da Exceção Motivo da Exceção RU Основание исключения Основание исключения S Undantagsorsak Undantagsorsak TR İstisna Nedeni İstisna Nedeni US Exception Reason Exception Reason ZHS 例外原因 例外原因 7 50 :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 显示各业务实体之间的事务处理例外 显示各业务实体之间的事务处理例外