ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4728251A9E05362FB09050512Y SELECT report.name report_name, rowset.name rowset_name, colset.name colset_name, conset.name conset_name, roword.name roword_name, lk1.meaning level_of_detail, report.segment_override, report.unit_of_measure_id currency, lk2.meaning rounding_option, lk3.meaning output_option, ds.name display_set, report.description, report.parameter_set_id parm_set_id, GL_RGXRPTD_XMLP_PKG.c_segment_overirdeformula(report.segment_override) C_Segment_Overirde FROM rg_reports report, rg_report_axis_sets rowset, rg_report_axis_sets colset, rg_report_content_sets conset, rg_row_orders roword, rg_lookups lk1, rg_lookups lk2, rg_lookups lk3, rg_report_display_sets ds WHERE report.report_id = nvl(:P_REPORT_ID, report.report_id) AND report.column_set_id = colset.axis_set_id AND report.row_set_id = rowset.axis_set_id AND report.content_set_id = conset.content_set_id(+) AND report.row_order_id = roword.row_order_id(+) AND lk1.lookup_type(+) = 'GL_DISPLAY_LEVEL' AND lk1.lookup_code(+) = TO_CHAR(report.minimum_display_level) AND lk2.lookup_type(+) = 'ROUNDING_OPTION' AND lk2.lookup_code(+) = report.rounding_option AND lk3.lookup_type(+) = 'OUTPUT_OPTION' AND lk3.lookup_code(+) = report.output_option AND ds.report_display_set_id(+) = report.report_display_set_id AND nvl(report.id_flex_code,:C_ID_FLEX_CODE) = :C_ID_FLEX_CODE AND nvl(report.structure_id,nvl(:C_STRUCTURE_ID,101)) = nvl(:C_STRUCTURE_ID, nvl(report.structure_id,101)) AND report.application_id in (101,168) AND decode(report.security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_REPORT_V', 'GL_DAS_FSG_REPORT',to_char(report.report_id),null,null,null,null,fnd_global.user_name),'T','Y','N'), 'Y') = 'Y' ORDER BY report.name SQLGL RGXRPTD_XML AR GL مكون كشف الحساب المالي - قائمة تفاصيل التقرير (بتنسيق XML) Imported from BI Publisher Description: قائمة تفاصيل التقرير Application: الأستاذ العام Source: مكون كشف الحساب المالي - قائمة تفاصيل التقرير (بتنسيق XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG D GL Berichte - Details Imported from BI Publisher Description: Berichte - Details Application: Rechnungswesen Source: Berichtsgenerator: Berichte - Details (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG E GL FSG - Listado Detallado de Informes Imported from BI Publisher Description: Listado Detallado de Informes Application: General Ledger Source: FSG - Listado Detallado de Informes (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG F GL FSG - Détail d'un état Imported from BI Publisher Description: Liste détaillée d'états Application: General Ledger Source: FSG - Détail d'un état (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG I GL FSG - Elenco dettagliato rapporti Imported from BI Publisher Description: Elenco dettagli rapporto Application: General Ledger Source: FSG - Elenco dettagliato rapporti (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG JA GL FSG - レポート詳細リスト Imported from BI Publisher Description: レポート詳細リスト Application: General Ledger Source: FSG - レポート詳細リスト (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG KO GL FSG - 보고서 상세 목록 Imported from BI Publisher Description: 보고서 상세내역 목록 Application: General Ledger Source: FSG - 보고서 상세 목록(XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG PTB GL FSG - Lista Detalhada de Relatórios Imported from BI Publisher Description: Listagem Detalhada do Relatório Application: General Ledger Source: FSG - Lista Detalhada de Relatórios (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG RU GL ГФД - подробный список отчетов Imported from BI Publisher Description: Подробный список отчетов Application: Главная книга Source: ГФД - подробный список отчетов (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG S GL RG - Rapportdetaljer Imported from BI Publisher Description: Rapportdetaljer Application: General Ledger Source: RG - Rapportdetaljer (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG TR GL FSG - Rapor Detay Listesi Imported from BI Publisher Description: Rapor Detay Listesi Application: Genel Muhasebe Source: FSG - Rapor Detay Listesi (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG US GL FSG - Report Detail Listing Imported from BI Publisher Description: Report Detail Listing Application: General Ledger Source: FSG - Report Detail Listing (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG ZHS GL FSG - 报表明细列表 Imported from BI Publisher Description: 报表明细列表 Application: 总帐管理系统 Source: FSG - 报表明细列表 (XML) Short Name: RGXRPTD_XML DB package: GL_RGXRPTD_XMLP_PKG BI Publisher :c_attribute_flag :c_id_flex_code :c_industry_type :c_structure_id :p_access_set_id :p_conc_request_id :p_delimiter :p_report_id 1 -50 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung ZugriffsSet-Kennung E Id Juego de Accesos Id Juego de Accesos F ID jeu d'accès ID jeu d'accès I Id serie di accesso Id serie di accesso JA アクセス・セットID アクセス・セットID KO 액세스 세트 ID 액세스 세트 ID PTB Id do Conjunto de Acesso Id do Conjunto de Acesso RU Идент. набора доступа Идент. набора доступа S Åtkomstuppsättnings-id Åtkomstuppsättnings-id TR Erişim Kümesi No Erişim Kümesi No US Access Set Id Access Set Id ZHS 访问权限集标识 访问权限集标识 2 -40 :p_chart_of_accts_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id =fnd_profile.value('GL_ACCESS_SET_ID') Y AR GL_SRS_COA_UNVALIDATED معرف جدول تصنيف الحسابات D GL_SRS_COA_UNVALIDATED Kontenplankennung E GL_SRS_COA_UNVALIDATED Id Plan de Cuentas F GL_SRS_COA_UNVALIDATED ID plan de comptes I GL_SRS_COA_UNVALIDATED Id piano dei conti JA GL_SRS_COA_UNVALIDATED 勘定体系ID KO GL_SRS_COA_UNVALIDATED 계정 코드집 ID PTB GL_SRS_COA_UNVALIDATED Id do Plano de Contas RU GL_SRS_COA_UNVALIDATED Идент. плана счетов S GL_SRS_COA_UNVALIDATED Kontoplans-id TR GL_SRS_COA_UNVALIDATED Hesap Planı No US GL_SRS_COA_UNVALIDATED Chart of Accounts Id ZHS GL_SRS_COA_UNVALIDATED 科目表标识 3 -30 :p_adhoc_prefix LOV Oracle RG_SRS_ADHOC_REPORT_PREFIX Y select meaning id, meaning value, description description from rg_lookups where lookup_type='FSG_ADHOC_REPORT_NAME_PREFIX' and lookup_code='ADHOC_PREFIX' order by value,description SELECT MEANING FROM RG_LOOKUPS WHERE LOOKUP_TYPE = 'FSG_ADHOC_REPORT_NAME_PREFIX' AND LOOKUP_CODE = 'ADHOC_PREFIX' Y AR RG_SRS_ADHOC_REPORT_PREFIX بادئة تقرير لغرض محدد D RG_SRS_ADHOC_REPORT_PREFIX Präfix Ad-Hoc-Bericht E RG_SRS_ADHOC_REPORT_PREFIX Prefijo de Informe ADHOC F RG_SRS_ADHOC_REPORT_PREFIX Préfixe d'état modifiable I RG_SRS_ADHOC_REPORT_PREFIX Prefisso del rapporto ADHOC JA RG_SRS_ADHOC_REPORT_PREFIX アドホック・レポート・プリフィクス KO RG_SRS_ADHOC_REPORT_PREFIX 임시 보고서 구분 PTB RG_SRS_ADHOC_REPORT_PREFIX Prefixo de Relatório ADHOC RU RG_SRS_ADHOC_REPORT_PREFIX Префикс разового отчета S RG_SRS_ADHOC_REPORT_PREFIX Tillfälligt rapportprefix TR RG_SRS_ADHOC_REPORT_PREFIX ÖZEL Rapor Öneki US RG_SRS_ADHOC_REPORT_PREFIX ADHOC Report Prefix ZHS RG_SRS_ADHOC_REPORT_PREFIX 特殊报表前缀 4 -20 :p_industry Char C Y AR RG_SRS_INSTALLATION الصناعة D RG_SRS_INSTALLATION Branche E RG_SRS_INSTALLATION Industria F RG_SRS_INSTALLATION Industrie I RG_SRS_INSTALLATION Industria JA RG_SRS_INSTALLATION 産業 KO RG_SRS_INSTALLATION 산업 PTB RG_SRS_INSTALLATION Indústria RU RG_SRS_INSTALLATION Отрасль S RG_SRS_INSTALLATION Bransch TR RG_SRS_INSTALLATION Endüstri US RG_SRS_INSTALLATION Industry ZHS RG_SRS_INSTALLATION 行业 5 10 :p_report_id LOV Oracle RG_SRS_RGXRPTD_V Y select report_id id, name value, description description from rg_reports where nvl(id_flex_code, decode(:$flex$.rg_srs_installation,'G', decode(fnd_profile.value('ATTRIBUTE_REPORTING'),'Y','GLAT','GLLE'),'GLLE')) =decode(:$flex$.rg_srs_installation,'G', decode(fnd_profile.value('ATTRIBUTE_REPORTING'),'Y','GLAT','GLLE'),'GLLE') and nvl(structure_id,:$flex$.gl_srs_coa_unvalidated) =:$flex$.gl_srs_coa_unvalidated and application_id in (101,168) and name not like substr(:$flex$.rg_srs_adhoc_report_prefix,1,16) || '%' and decode(security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_FSG_REPORT_V','GL_DAS_FSG_REPORT',to_char(report_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),'Y')='Y' order by name AR اسم التقرير معرف التقرير D Bericht Berichtskennung E Nombre del Informe Id Informe F Nom de l'état ID état I Nome rapporto ID del rapporto JA レポート名 レポートID KO 보고서명 보고서 Id PTB Nome do Relatório Id do Relatório RU Имя отчета Идент. отчета S Rapport Rapport-id TR Rapor Adı Rapor No US Report Name Report Id ZHS 报表名称 报表标识