ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472C251A9E05362FB09050512 select * from ( select app.application_name ,lk11.meaning amb_context_dsp ,err.amb_context_code ,err.product_rule_code ,prt.name product_rule_name ,err.product_rule_type_code ,lk4.meaning product_rule_type_dsp ,err.line_definition_owner_code ,lk12.meaning line_definition_owner ,err.line_definition_code ,xld.name line_definition_name ,err.category_sequence_num ,err.message_category_code ,lk2.meaning message_category_dsp ,msg.message_number ,err.message_type_flag ,lk1.meaning message_type_dsp ,ect.event_class_code ,ect.name event_class_name ,ett.event_type_code ,ett.name event_type_name ,err.description_code ,dt.name description_name ,err.description_type_code ,lk5.meaning description_type_dsp ,err.extract_object_name ,err.extract_object_type_code ,lk3.meaning extract_object_type_dsp ,err.source_code ,st.name source_name ,err.source_type_code ,lk9.meaning source_type_dsp ,err.analytical_criterion_code ,act.name analytical_criterion_name ,err.analytical_criterion_type_code ,lk6.meaning analytical_criterion_type_dsp ,err.accounting_line_code ,acb.name accounting_line_name ,err.accounting_line_type_code ,lk7.meaning accounting_line_type_dsp ,err.mapping_set_code ,mst.name mapping_set_name ,err.segment_rule_code ,srt.name segment_rule_name ,err.segment_rule_type_code ,lk8.meaning segment_rule_type_dsp ,err.accounting_source_code ,err.mapping_group_code ,lk10.meaning mapping_group_dsp ,ast1.name accounting_source_name ,err.mpa_accounting_line_code ,malt.name mpa_accounting_line_name ,err.mpa_accounting_line_type_code ,lk13.meaning mpa_accounting_line_type_dsp ,msg.message_text from xla_amb_setup_errors err ,xla_product_rules_tl prt ,xla_line_definitions_tl xld ,xla_event_classes_tl ect ,xla_event_types_tl ett ,xla_descriptions_tl dt ,xla_analytical_hdrs_tl act ,xla_acct_line_types_tl acb ,xla_acct_line_types_tl malt ,xla_sources_tl st ,xla_acct_attributes_tl ast1 ,xla_mapping_sets_tl mst ,xla_seg_rules_tl srt ,fnd_new_messages msg ,fnd_application_vl app ,xla_lookups lk1 ,xla_lookups lk2 ,xla_lookups lk3 ,xla_lookups lk4 ,xla_lookups lk5 ,xla_lookups lk6 ,xla_lookups lk7 ,xla_lookups lk8 ,xla_lookups lk9 ,xla_lookups lk10 ,xla_lookups lk11 ,xla_lookups lk12 ,xla_lookups lk13 where msg.message_name = err.message_name and msg.application_id = 602 and msg.language_code = USERENV('LANG') and app.application_id = err.application_id and prt.application_id(+) = err.application_id and prt.amb_context_code(+) = err.amb_context_code and prt.product_rule_code(+) = err.product_rule_code and prt.product_rule_type_code(+) = err.product_rule_type_code and prt.language(+) = USERENV('LANG') and xld.application_id(+) = err.application_id and xld.amb_context_code(+) = err.amb_context_code and xld.event_class_code(+) = err.event_class_code and xld.event_type_code(+) = err.event_type_code and xld.line_definition_owner_code(+) = err.line_definition_owner_code and xld.line_definition_code(+) = err.line_definition_code and xld.language(+) = USERENV('LANG') and ect.application_id(+) = err.application_id and ect.event_class_code(+) = err.event_class_code and ect.language(+) = USERENV('LANG') and ett.application_id(+) = err.application_id and ett.event_class_code (+) = err.event_class_code and ett.event_type_code(+) = err.event_type_code and ett.language(+) = USERENV('LANG') and dt.application_id(+) = err.application_id and dt.amb_context_code (+) = err.amb_context_code and dt.description_type_code(+) = err.description_type_code and dt.description_code(+) = err.description_code and dt.language(+) = USERENV('LANG') and st.application_id(+) = err.application_id and st.source_type_code(+) = err.source_type_code and st.source_code(+) = err.source_code and st.language(+) = USERENV('LANG') and ast1.accounting_attribute_code(+) = err.accounting_source_code and ast1.language(+) = USERENV('LANG') and acb.application_id(+) = err.application_id and acb.event_class_code(+) = err.event_class_code and acb.amb_context_code (+) = err.amb_context_code and acb.accounting_line_type_code(+) = err.accounting_line_type_code and acb.accounting_line_code(+) = err.accounting_line_code and acb.language(+) = USERENV('LANG') and malt.application_id(+) = err.application_id and malt.event_class_code(+) = err.event_class_code and malt.amb_context_code (+) = err.amb_context_code and malt.accounting_line_type_code(+) = err.mpa_accounting_line_type_code and malt.accounting_line_code(+) = err.mpa_accounting_line_code and malt.language(+) = USERENV('LANG') and act.analytical_criterion_code(+) = err.analytical_criterion_code and act.analytical_criterion_type_code(+) = err.analytical_criterion_type_code and act.amb_context_code(+) = err.amb_context_code and act.language(+) = USERENV('LANG') and mst.mapping_set_code(+) = err.mapping_set_code and mst.amb_context_code(+) = err.amb_context_code and mst.language(+) = USERENV('LANG') and srt.application_id(+) = err.application_id and srt.amb_context_code(+) = err.amb_context_code and srt.segment_rule_type_code(+) = err.segment_rule_type_code and srt.segment_rule_code(+) = err.segment_rule_code and srt.language(+) = USERENV('LANG') and lk1.lookup_code = err.message_type_flag and lk1.lookup_type = 'XLA_ERROR_TYPE' and lk2.lookup_code = err.message_category_code and lk2.lookup_type = 'XLA_AB_MESSAGE_CATEGORY' and lk3.lookup_code(+) = err.extract_object_type_code and lk3.lookup_type(+) = 'XLA_EXTRACT_OBJECT_TYPE' and lk4.lookup_code(+) = err.product_rule_type_code and lk4.lookup_type(+) = 'XLA_OWNER_TYPE' and lk5.lookup_code(+) = err.description_type_code and lk5.lookup_type(+) = 'XLA_OWNER_TYPE' and lk6.lookup_code(+) = err.analytical_criterion_type_code and lk6.lookup_type(+) = 'XLA_OWNER_TYPE' and lk7.lookup_code(+) = err.accounting_line_type_code and lk7.lookup_type(+) = 'XLA_OWNER_TYPE' and lk8.lookup_code(+) = err.segment_rule_type_code and lk8.lookup_type(+) = 'XLA_OWNER_TYPE' and lk9.lookup_code(+) = err.source_type_code and lk9.lookup_type(+) = 'XLA_SOURCE_TYPE' and lk10.lookup_code(+) = err.mapping_group_code and lk10.lookup_type(+) = 'XLA_ACCT_ATTR_ASSGN_GROUP' and lk11.lookup_code = err.amb_context_code and lk11.lookup_type = 'XLA_AMB_CONTEXT_TYPE' and lk12.lookup_code(+) = err.line_definition_owner_code and lk12.lookup_type(+) = 'XLA_OWNER_TYPE' and lk13.lookup_code(+) = err.mpa_accounting_line_type_code and lk13.lookup_type(+) = 'XLA_OWNER_TYPE' and err.amb_context_code = NVL(FND_PROFILE.value('XLA_AMB_CONTEXT'),'DEFAULT') &CP_QUERY &CP_JLD_SELECT &CP_JLD_FROM &CP_JLD_WHERE &CP_JLD_WHERE2 ) Q order by application_name, product_rule_name, product_rule_type_dsp, line_definition_name, line_definition_owner Y XLA XLAABACR_XML AR XLA مراجعة التعريفات المحاسبية للتطبيق (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير مراجعة التعريف المحاسبي للتطبيق Application: محاسبة الأستاذ الفرعي Source: مراجعة التعريفات المحاسبية للتطبيق (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG D XLA Anwendungsbuchungsdefinitionen validieren- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Auswertung "Anwendungsbuchungsdefinition - Validierung" Application: Subledger Accounting Source: Anwendungsbuchungsdefinitionen validieren (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG E XLA Validación de Definiciones Contables de Aplicación: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe Validación de Definición Contable de Aplicación Application: Subledger Accounting Source: Validación de Definiciones Contables de Aplicación (XML): No Admitido, Reservado para Uso Futuro Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG F XLA Validation des définitions comptables pour l'auxiliaire- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Validation de définitions comptables pour l'auxiliaire Application: Subledger Accounting Source: Validation des définitions comptables pour l'auxiliaire (XML) - Non pris en charge : réservé pour une utilisation future Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG I XLA Convalida definizioni regole contabili applicazione- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Convalida definizioni regole contabili applicazione Application: Subledger Accounting Source: Convalida definizioni regole contabili applicazione (XML) - non supportato: riservato per usi futuri Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG JA XLA アプリケーション会計定義の検証- サポートされていません: 将来の使用のために予約されています Imported from BI Publisher Description: アプリケーション会計定義検証レポート Application: Subledger Accounting Source: アプリケーション会計定義の検証(XML) - サポートされていません: 将来の使用のために予約されています Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG KO XLA 애플리케이션 회계 정의 검증- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 애플리케이션 회계 정의 검증 보고서 Application: Subledger Accounting Source: 애플리케이션 회계 정의 검증(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG PTB XLA Validar Definições Contábeis da Aplicação- Não Suportado: Reservado para Uso Futuro Imported from BI Publisher Description: Relatório de Validação da Definição Contábil da Aplicação Application: Subledger Accounting Source: Validar Definições Contábeis da Aplicação (XML) - Não Suportado: Reservado para Uso Futuro Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG RU XLA Проверка определений учета для приложения- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о проверке определений учета для приложения Application: Учет на основе субкниг Source: Проверка определений учета для приложения (XML) - не поддерживается: зарезервировано для будущего использования Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG S XLA Validera redovisningsdefinitioner för applikation- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Validering av redovisningsdefinition för applikation - rapport Application: Sidoordnad redovisning Source: Validera redovisningsdefinitioner för applikation (XML) - Stöds inte: Reserverad för framtida bruk Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG TR XLA Uygulama Muhasebe Tanımlarını Doğrula- Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Imported from BI Publisher Description: Uygulama Yazılımı Muhasebe Tanımı Doğrulama Raporu Application: Cari Hesap Muhasebesi Source: Uygulama Muhasebe Tanımlarını Doğrula (XML) - Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG US XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Application Accounting Definition Validation Report Application: Subledger Accounting Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG ZHS XLA 验证应用产品会计定义- 不支持：已保留供将来使用 Imported from BI Publisher Description: 应用产品会计定义验证报表 Application: 子分类帐会计系统 Source: 验证应用产品会计定义 (XML) - 不支持：已保留供将来使用 Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG BI Publisher &cp_jld_from &cp_jld_select &cp_jld_where &cp_jld_where2 &cp_query :cp_aad_query :cp_aad_where :cp_debug_flag :cp_default_module :cp_jld_from :cp_jld_select :cp_jld_where :cp_jld_where2 :cp_ledger_category :cp_log_level :cp_query :cp_ret_code :p_application_id :p_conc_request_id :p_event_class_code :p_event_type_code :p_ledger_id :p_line_definition_code :p_line_definition_owner_code :p_product_rule_code :p_product_rule_type_code :p_report_only_mode :p_uncompile_only_flag 1 -30 :p_dummy Char SELECT 'Y' FROM DUAL WHERE :$flex$.ledger:NULL IS NULL US XLA_SRS_NO_VALIDATION 2 -20 :p_report_only_mode Char N AR طور التقرير فقط D Modus "Nur Auswertung" E Modo de Sólo Informe F Mode Edition seule I Modalità Solo rapporto JA レポート専用モード KO 보고서 전용 모드 PTB Modo Somente Relatório RU Режим "Только отчет" S Läge endast för rapport TR Sadece Rapor Modu US Report Only Mode ZHS 仅限于报表模式 3 10 :p_ledger_id LOV Oracle XLA_AB_LEDGERS Y select ledger_id id, name value, null description from xla_gl_ledgers_v where ledger_category_code in ('NONE','PRIMARY','SECONDARY') and sla_accounting_method_code is not null and exists (select 1 from xla_acctg_method_rules where sla_accounting_method_code=accounting_method_code and sla_accounting_method_type=accounting_method_type_code) order by name AR دفتر الأستاذ D Buch E Libro Mayor F Livre I Libro contabile JA 元帳 KO 원장 PTB Razão RU Книга S Huvudbok TR Defter US Ledger ZHS 分类帐 4 20 :p_uncompile_only_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description select meaning from xla_lookups where lookup_type = 'XLA_YES_NO' and lookup_code = 'Y' AR الموقف غير المُجمَّع فقط D Nur Status nicht kompiliert E Sólo Estado No Compilado F Statut Non compilé seulement I Solo stato non compilato JA 未コンパイル・ステータスのみ KO 컴파일링되지 않은 상태만 PTB Status Não compilado Somente RU Только статус "Не скомпилировано" S Endast status Okompilerad TR Sadece Derlenmemiş Statü US Uncompiled Status Only ZHS 仅限于未编译状态 5 30 :p_application_id LOV Oracle XLA_AB_SUBLEDGERS Y select application_id id, application_name value, null description from xla_subledgers_fvl x where exists ( select 1 from xla_acctg_method_rules r,xla_gl_ledgers_v gl where r.application_id=x.application_id and gl.sla_accounting_method_code=r.accounting_method_code and gl.sla_accounting_method_type= r.accounting_method_type_code and gl.ledger_id=:$flex$.xla_ab_ledgers:null ) or :$flex$.xla_ab_ledgers:null is null order by application_name AR التطبيق D Anwendung E Aplicación I Applicazione JA アプリケーション KO 애플리케이션 PTB Aplicação RU Приложение S Applikation TR Uygulama Yazılımı US Application ZHS 应用产品 6 40 :p_product_rule_code LOV Oracle XLA_AB_PRODUCT_RULES Y select product_rule_code id, name value, null description from xla_product_rules_vl where :$flex$.xla_srs_no_validation='Y' and amb_context_code=fnd_profile.value('XLA_AMB_CONTEXT') and application_id=:$flex$.xla_ab_subledgers and compile_status_code in ('N','E', decode(nvl(:$flex$.xla_ab_compile_status:null,'A'), 'A','Y','N')) order by value,description AR التعريف المحاسبي للتطبيق D Anwendungsbuchungsdefinition E Definición Contable de Aplicación F Définition comptable auxiliaire I Definizione regole contabili applicazione JA アプリケーション会計定義 KO 애플리케이션 회계 정의 PTB Definição Contábil da Aplicação RU Определение учета для приложения S Redovisningsdefinition för applikation TR Uygulama Yazılımı Muhasebe Tanımı US Application Accounting Definition ZHS 应用产品会计定义 7 50 :p_product_rule_type_code LOV Oracle XLA_AB_PRODUCT_RULE_OWNERS Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_OWNER_TYPE' and lookup_code in ( select distinct prb.product_rule_type_code from xla_product_rules_b prb where prb.product_rule_code= nvl(:$flex$.xla_ab_product_rules:null, prb.product_rule_code)) order by value,description SELECT MEANING FROM XLA_LOOKUPS LK, XLA_PRODUCT_RULES_B PRB WHERE LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE' AND LK.LOOKUP_CODE = PRB.PRODUCT_RULE_TYPE_CODE AND PRB.PRODUCT_RULE_CODE = :$flex$.application_accounting_definition AND PRB.AMB_CONTEXT_CODE = fnd_profile.value('XLA_AMB_CONTEXT') AR مالك التعريف المحاسبي للتطبيق D Verantwortlicher Anwendungsbuchungsdefinition E Propietario de Definición Contable de Aplicación F Propriétaire de la définition comptable auxiliaire I Proprietario definizione regole contabili applicazione JA アプリケーション会計定義所有者 KO 애플리케이션 회계 정의 소유자 PTB Proprietário da Definição Contábil da Aplicação RU Владелец определения учета для приложения S Ägare till redovisningsdefinition för applikation TR Uygulama Yazılımı Muhasebe Tanımı Sahibi US Application Accounting Definition Owner ZHS 应用产品会计定义责任人