ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4D13869E053B46B63588994Y select null TO_FLEXDATA, decode(cc.summary_flag, 'Y', '*', '') SUMMARY, null FROM_FLEXDATA, (nvl(ca.entered_dr,0) - nvl(ca.entered_cr,0)) ACCOUNT_BAL, ca.request_id REQUEST_ID, --fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield', 'SQLGL', 'GL#', CA.CHART_OF_ACCOUNTS_ID, NULL, CA.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') TO_FLEXFIELD, --fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield_pad', 'SQLGL', 'GL#', CA.CHART_OF_ACCOUNTS_ID, NULL, CA.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') TO_FLEXFIELD_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('from_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FROM_FLEXFIELD from gl_code_combinations cc, gl_consolidation_audit ca where ca.consolidation_id = :P_CONSOLIDATION_ID and &WHERE_BALANCE and ca.to_period_name = :P_PERIOD_NAME and ca.average_consolidation_flag = decode(:P_USAGE,'A','Y','N') and cc.code_combination_id = ca.from_code_combination_id and &WHERE_DR_CR_NOT_ZERO ORDER BY 2 ASC , &ORDERBY_TO_FLEX , &ORDERBY_FROM_FLEX, ca.request_id , 4 SQLGL GLXCAR_XML AR GL التجميع - التدقيق (بتنسيق XML) Application: الأستاذ العام Source: التجميع - التدقيق (بتنسيق XML) Short Name: GLXCAR_XML DB package: GL_GLXCAR_XMLP_PKG D GL Konsolidierung - Protokoll Application: Rechnungswesen Source: Konsolidierung - Protokoll (XML) Short Name: GLXCAR_XML DB package: GL_GLXCAR_XMLP_PKG US GL Consolidation - Audit Application: General Ledger Source: Consolidation - Audit (XML) Short Name: GLXCAR_XML DB package: GL_GLXCAR_XMLP_PKG ZHS GL 合并 - 审核 Application: 总帐管理系统 Source: 合并 - 审核 (XML) Short Name: GLXCAR_XML DB package: GL_GLXCAR_XMLP_PKG BI Publisher &orderby_from_flex &orderby_to_flex &where_balance &where_dr_cr_not_zero :consolidation_name :currency_code :from_chart_of_accounts_id :from_currency_code :from_ledger_id :from_ledger_name :orderby_from_flex :orderby_to_flex :p_balance_type :p_conc_request_id :p_consolidation_id :p_period_name :p_usage :select_from_flex :select_to_flex :to_chart_of_accounts_id :to_ledger_id :to_ledger_name :where_balance :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 Periode F Période US Period ZHS 期间 3 30 :p_balance_type LOV Oracle GL_SRS_CONS_BALANCE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_DSS_BALANCE_TYPE' and lookup_code in ('A','B','C') order by meaning select meaning from gl_lookups where lookup_type = 'GL_DSS_BALANCE_TYPE' and lookup_code = 'A' Y AR نوع الرصيد D Saldenart F Type de solde US Balance Type ZHS 余额类型 4 40 :p_usage LOV Oracle GL_SRS_CONS_USAGE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='CONSOLIDATION_USAGE' and (lookup_code='S' or lookup_code= (select decode(fb.enable_average_balances_flag,'Y', decode(tb.enable_average_balances_flag,'Y', decode(tb.consolidation_ledger_flag,'Y', 'A','S'),'S'),'S') from gl_ledgers tb, gl_ledgers fb, gl_consolidation c where c.consolidation_id=:$flex$.gl_srs_ledger_consolidations and c.from_ledger_id=fb.ledger_id and c.to_ledger_id=tb.ledger_id)) order by decode(lookup_code,'S',1,'A',2) SELECT MEANING FROM GL_LOOKUPS WHERE LOOKUP_CODE = 'S' AND LOOKUP_TYPE = 'CONSOLIDATION_USAGE' Y AR الاستخدام D Verwendung F Ressources hors main-d'oeuvre US Usage ZHS 用途