ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4F03869E053B46B63588994Y select null C_FLEXDATAAB, decode(upper(:P_PERIOD_TYPE), 'PATD', gdb.period_average_to_date_num, 'YATD', gdb.year_average_to_date_num, 'QATD', gdb.quarter_average_to_date_num, 'EOD', gdb.end_of_date_balance_num, 0) from_amountAB, 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_FlexfieldAB, 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') DescriptionAB from gl_code_combinations GLCC, gl_daily_balances_v gdb, gl_period_statuses gps where (:P_PERIOD_TYPE = 'PATD' or :P_PERIOD_TYPE = 'QATD' or :P_PERIOD_TYPE = 'YATD' or :P_PERIOD_TYPE = 'EOD') AND NOT EXISTS ( SELECT 'Consolidated Detail Accounts Exists' FROM GL_CONSOLIDATION_AUDIT GLCA, GL_CODE_COMBINATIONS GLCC1 WHERE GLCA.consolidation_id = :P_CONSOLIDATION_ID AND GLCA.from_period_name = :P_PERIOD_NAME AND GLCA.average_consolidation_flag = :P_Y AND GLCA.actual_flag = :P_A AND GLCA.from_code_combination_id = GLCC1.code_combination_id AND GLCC1.summary_flag = :P_N AND GLCC1.code_combination_id = GLCC.code_combination_id AND :PZ = 'ZZ') AND NOT EXISTS ( SELECT 'Detail Accounts consolidated through summary accounts exists' FROM GL_CONSOLIDATION_AUDIT GLCA, GL_CODE_COMBINATIONS GLCC2, GL_ACCOUNT_HIERARCHIES GAH WHERE GLCA.consolidation_id = :P_CONSOLIDATION_ID AND GLCA.from_period_name = :P_PERIOD_NAME AND GLCA.average_consolidation_flag = 'Y' AND GLCA.actual_flag = 'A' AND GLCA.from_code_combination_id = GLCC2.code_combination_id AND GLCC2.summary_flag = 'Y' AND GLCC2.code_combination_id = GAH.summary_code_combination_id AND GAH.detail_code_combination_id = GLCC.code_combination_id) and GLCC.chart_of_accounts_id = to_number(:STRUCT_NUM) and gdb.code_combination_id = glcc.code_combination_id and gdb.actual_flag = 'A' and gdb.period_name = :P_PERIOD_NAME and gdb.currency_type in ('T', 'O', 'U') and gdb.currency_code = :ConsCurrencyCode and gdb.ledger_currency = :FromCurrencyCode and gdb.template_id is NULL and gdb.ledger_id = :SubsidLedgerId and gdb.period_set_name = :PeriodSetName and gps.application_id = 101 and gps.ledger_id = gdb.ledger_id and gps.period_name = gdb.period_name and gps.end_date = gdb.accounting_date and gps.period_type = gdb.period_type and &P_Accounts_ADB and &P_BALJOINAB order by &P_ORDERBY --C_FLEXDATAAB,from_amountAB,&P_ORDERBY SQLGL GLXUSA_XML AR GL التجميع - حسابات فرعية غير مخططة (بتنسيق XML) Application: الأستاذ العام Source: التجميع - حسابات فرعية غير مخططة (بتنسيق XML) Short Name: GLXUSA_XML DB package: GL_GLXUSA_XMLP_PKG D GL Konsolidierung - Nicht zugeordnete Konten in untergeordneten Firmen Application: Rechnungswesen Source: Konsolidierung - Nicht zugeordnete Konten in untergeordneten Firmen (XML) Short Name: GLXUSA_XML DB package: GL_GLXUSA_XMLP_PKG F GL Consolidation - Comptes enfant non rapprochés Application: General Ledger Source: Consolidation - Comptes enfant non rapprochés (XML) Short Name: GLXUSA_XML DB package: GL_GLXUSA_XMLP_PKG US GL Consolidation - Unmapped Subsidiary Accounts Application: General Ledger Source: Consolidation - Unmapped Subsidiary Accounts (XML) Short Name: GLXUSA_XML DB package: GL_GLXUSA_XMLP_PKG ZHS GL 合并 - 未映射的子账户 Application: 总帐管理系统 Source: 合并 - 未映射的子账户 (XML) Short Name: GLXUSA_XML DB package: GL_GLXUSA_XMLP_PKG BI Publisher &p_accounts_adb &p_baljoinab &p_orderby :conscurrencycode :consolidation_name :fromcurrencycode :p_a :p_accounts :p_accounts_adb :p_accounts_clause :p_accounts_clause_adb :p_baljoin :p_baljoinab :p_conc_request_id :p_consolidation_id :p_flexdata :p_n :p_orderby :p_period_name :p_period_type :p_y :parentledgername :periodsetname :pz :struct_num :subsidledgerid :subsidledgername 1 10 :p_consolidation_id LOV Oracle GL_SRS_LEDGER_CONS_USA Y select consolidation_id id, name value, description description from gl_consolidation_v where consolidation_id in (select c.consolidation_id from gl_consolidation_audit ca,gl_consolidation c,gl_access_set_ledgers gls,gl_ledgers g1,gl_ledgers g2 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 g1.ledger_id=c.to_ledger_id and g2.ledger_id=c.from_ledger_id and g1.period_set_name=decode (gls.ledger_id,c.to_ledger_id,g2.period_set_name,c.from_ledger_id,g1.period_set_name) and g1.accounted_period_type= decode (gls.ledger_id,c.to_ledger_id,g2.accounted_period_type,c.from_ledger_id,g1.accounted_period_type)) 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_FROM_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_cons_usa and glp.ledger_id=glc.from_ledger_id and glp.application_id=101 and glp.period_name in (select from_period_name from gl_consolidation_audit ca where consolidation_id= :$flex$.gl_srs_ledger_cons_usa) order by period_year desc,period_num desc Y AR فترة فرعية D Untergeordnete Periode F Période enfant US Subsidiary Period ZHS 子公司期间 3 30 :p_period_type LOV Oracle GL_SRS_PERIOD_TYPES_ALL Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='PTD_YTD' or lookup_type='PATD_EOD' order by meaning Y AR نوع المبلغ D Betragsart F Type de montant US Amount Type ZHS 金额类型