ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726C51A9E05362FB09050512Y select st.template_name template , --null C_FLEXDATA_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_flexdata_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXDATA_SUM, --null C_FLEXDATA_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_flexdata_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXDATA_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_SUM, --&C_LPROMPT_SUM C_LPROMPT_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_sum', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_SUM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_sum_pad', 'SQLGL', 'GL#', cs1.CHART_OF_ACCOUNTS_ID, NULL, cs1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEXFIELD_SUM_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD_DET, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_DET, --GL_GLXRLACH_XMLP_PKG.new_descformula(:C_DESC_ACCT_DET) NEW_DESC, GL_GLXRLACH_XMLP_PKG.new_descformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_det', 'SQLGL', 'GL#', cd.CHART_OF_ACCOUNTS_ID, NULL, cd.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION')) NEW_DESC, GL_GLXRLACH_XMLP_PKG.OLD_DESC_p OLD_DESC from gl_code_combinations cs1, gl_code_combinations cd, gl_summary_templates st, gl_account_hierarchies h where st.status = 'F' &WHERE_TEMPLATE and h.ledger_id = :P_LEDGER_ID and h.template_id = st.template_id and h.summary_code_combination_id = cs1.code_combination_id and h.detail_code_combination_id = cd.code_combination_id &WHERE_DAS order by &P_ORDER_BY_DET SQLGL GLXRLACH_XML AR GL جدول تصنيف الحسابات - تدرج الحسابات (بتنسيق XML) Imported from BI Publisher Description: قائمة تدرجات الحسابات Application: الأستاذ العام Source: جدول تصنيف الحسابات - تدرج الحسابات (بتنسيق XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG D GL Kontenplan - Kontenhierarchie Imported from BI Publisher Description: Kontenhierarchien Application: Rechnungswesen Source: Kontenplan - Kontenhierarchie (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG E GL Plan de Cuentas - Jerarquía de Cuentas Imported from BI Publisher Description: Listado de Jerarquía de Cuentas Application: General Ledger Source: Plan de Cuentas - Jerarquía de Cuentas (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG F GL Plan de comptes - Hiérarchie des comptes Imported from BI Publisher Description: Liste des hiérarchies de comptes Application: General Ledger Source: Plan de comptes - Hiérarchie des comptes (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG I GL Piano dei conti - Gerarchia conti Imported from BI Publisher Description: Elenco delle gerarchie dei conti Application: General Ledger Source: Piano dei conti - Gerarchia conti (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG JA GL 勘定体系 - 勘定科目階層レポート Imported from BI Publisher Description: 勘定科目階層リスト Application: General Ledger Source: 勘定体系 - 勘定科目階層レポート (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG KO GL 계정 코드집 - 계정 계층 Imported from BI Publisher Description: 계정 계층 목록 Application: General Ledger Source: 계정 코드집 - 계정 계층(XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG PTB GL Plano de Contas - Hierarquia de Conta Imported from BI Publisher Description: Lista de Hierarquias de Conta Application: General Ledger Source: Plano de Contas - Hierarquia de Conta (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG RU GL План счетов - иерархия счетов Imported from BI Publisher Description: Список иерархий счетов Application: Главная книга Source: План счетов - иерархия счетов (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG S GL Kontoplan - Kontohierarki Imported from BI Publisher Description: Kontohierarkier - lista Application: General Ledger Source: Kontoplan - Kontohierarki (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG TR GL Hesap Planı - Hesap Hiyerarşisi Imported from BI Publisher Description: Hesap Hiyerarşileri Listesi Application: Genel Muhasebe Source: Hesap Planı - Hesap Hiyerarşisi (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG US GL Chart of Accounts - Account Hierarchy Imported from BI Publisher Description: Account Hierarchies Listing Application: General Ledger Source: Chart of Accounts - Account Hierarchy (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG ZHS GL 科目表 - 账户层次结构 Imported from BI Publisher Description: 账户分层结构列表 Application: 总帐管理系统 Source: 科目表 - 账户层次结构 (XML) Short Name: GLXRLACH_XML DB package: GL_GLXRLACH_XMLP_PKG BI Publisher &c_lprompt_sum &p_order_by_det &where_das &where_template :ledger_name :old_desc :p_access_set_id :p_conc_request_id :p_flexdata_det :p_flexdata_sum :p_ledger_id :p_order_by_det :p_order_by_sum :p_template_id :struct_num :where_das :where_template 1 -20 :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 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_NO_SETS_STORE_ID Y select led.ledger_id id, led.name value, led.description description from gl_access_set_ledgers ac,gl_ledgers led where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and led.object_type_code='L' order by name select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y AR الأستاذ الأستاذ D Buch Buch E Libro Mayor Libro Mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger ZHS 分类账 分类账 3 20 :p_template_id LOV Oracle GL_SRS_SUMMARY_TEMPLATES Y select template_id id, template_name value, null description from gl_summary_templates where ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and status='F' order by value,description AR قالب الإجمالي معرف القالب D Summierungsschema Schemakennung E Plantilla Resumen Id Plantilla F Combinaison de synthèse ID modèle I Modello sintetico Id modello JA 要約テンプレート テンプレートID KO 요약 템플리트 템플리트 ID PTB Modelo Resumido Id do Modelo RU Сводный шаблон Идент. шаблона S Summeringsmall Mall-id TR Özet Hesap Şablonu Şablon No US Summary Template Template Id ZHS 汇总模板 模板标识