ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4D63869E053B46B63588994Y select distinct null C_FLEXDATA, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Flexfield, fnd_flex_xml_publisher_apis.process_kff_combination_1('description', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') Description from gl_consolidation_audit GLCA, gl_code_combinations GLCC where GLCA.consolidation_id = to_number(:P_CONSOLIDATION_ID) --and &P_FLEXDATA1 = &P_FLEXDATA2 and GLCA.to_period_name = :P_PERIOD_NAME and GLCC.template_id is NULL and GLCC.chart_of_accounts_id = to_number(:STRUCT_NUM) and ( glcc.enabled_flag = 'N' OR ((sign(glcc.start_date_active - sysdate) = 1) or (sign(glcc.end_date_active - sysdate) = -1))) and &WHERE_DR_CR_NOT_ZERO order by 1 SQLGL GLXDDA_XML AR GL التجميع - حسابات رئيسية معطلة (بتنسيق XML) Application: الأستاذ العام Source: التجميع - حسابات رئيسية معطلة (بتنسيق XML) Short Name: GLXDDA_XML DB package: GL_GLXDDA_XMLP_PKG D GL Konsolidierung - Gesperrte übergeordnete Konten Application: Rechnungswesen Source: Konsolidierung - Gesperrte übergeordnete Konten (XML) Short Name: GLXDDA_XML DB package: GL_GLXDDA_XMLP_PKG F GL Consolidation - Comptes parent désactivés Application: General Ledger Source: Consolidation - Comptes parent désactivés (XML) Short Name: GLXDDA_XML DB package: GL_GLXDDA_XMLP_PKG US GL Consolidation - Disabled Parent Accounts Application: General Ledger Source: Consolidation - Disabled Parent Accounts (XML) Short Name: GLXDDA_XML DB package: GL_GLXDDA_XMLP_PKG ZHS GL 合并 - 禁用父账户 Application: 总帐管理系统 Source: 合并 - 禁用父账户 (XML) Short Name: GLXDDA_XML DB package: GL_GLXDDA_XMLP_PKG BI Publisher &p_flexdata1 &p_flexdata2 &where_dr_cr_not_zero :consolidationname :from_ledger_name :ledger_name :p_conc_request_id :p_consolidation_id :p_flexdata1 :p_flexdata2 :p_orderby :p_period_name :struct_num :to_ledger_name :where_dr_cr_not_zero 1 10 :p_consolidation_id LOV Oracle GL_SRS_LEDGER_CONSOLIDATIONS Y select consolidation_id id, name value, description description from gl_consolidation where consolidation_id in (select c.consolidation_id from gl_consolidation_audit ca,gl_consolidation c,gl_access_set_ledgers gls where c.consolidation_id=ca.consolidation_id and (gls.ledger_id=c.to_ledger_id or gls.ledger_id=c.from_ledger_id) and gls.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID')) and decode(security_flag,'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_CONSOLIDATION_U','GL_DAS_CONSOLIDATION', to_char(consolidation_id),null,null,null,null, fnd_global.user_name),'T','Y','N'),'Y')='Y' order by name Y AR تعريف التجميع D Konsolidierungsdefinition F Définition de la consolidation US Consolidation Definition ZHS 合并定义 2 20 :p_period_name LOV Oracle GL_SRS_CONS_TO_PERIODS Y select period_name id, period_name value, null description from gl_consolidation glc,gl_period_statuses glp where glc.consolidation_id=:$flex$.gl_srs_ledger_consolidations and glp.ledger_id=glc.to_ledger_id and glp.application_id=101 and glp.period_name in (select to_period_name from gl_consolidation_audit ca where consolidation_id= :$flex$.gl_srs_ledger_consolidations) order by period_year desc,period_num desc Y AR فترة رئيسية D Übergeordnete Periode F Période parent US Parent Period ZHS 母公司期间