ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726651A9E05362FB09050512Y select null FLEXDATA, &SELECT_MASTER_BUDGET MASTER_BUDGET_BAL, bv.budget_name DEPENDENT_BUDGET_NAME, &SELECT_DETAIL_BUDGET DETAIL_BUDGET_BAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('acctdesc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCTDESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield_pad', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') FLEXFIELD_PAD, GL_GLXRBCR_XMLP_PKG.available_budgetformula(nvl ( bm.period_net_dr , 0 ) - nvl ( bm.period_net_cr , 0 ), :TOTAL_DETAIL_BAL) AVAILABLE_BUDGET from gl_budget_versions bv, gl_balances bm, gl_balances bd, gl_code_combinations cc where cc.chart_of_accounts_id = :CHART_OF_ACCOUNTS_ID and cc.template_id is not null &WHERE_DAS and bm.ledger_id = :P_LEDGER_ID and bm.code_combination_id = cc.code_combination_id and bm.currency_code = :P_CURRENCY_CODE and bm.period_name = :P_PERIOD_NAME and bm.actual_flag = 'B' and bm.budget_version_id = :P_BUDGET_VERSION_ID and (bm.translated_flag is NULL OR bm.translated_flag = 'R') and bm.template_id is not NULL and bd.ledger_id = :P_LEDGER_ID and bd.code_combination_id = bm.code_combination_id and bd.currency_code = :P_CURRENCY_CODE and bd.period_name = :P_PERIOD_NAME and bd.actual_flag = 'B' and bd.budget_version_id in (select bv2.budget_version_id from gl_budget_versions bv2 where bv2.control_budget_version_id = :P_BUDGET_VERSION_ID) and (bd.translated_flag is NULL OR bd.translated_flag = 'R') and bd.template_id is not NULL and bv.budget_version_id = bd.budget_version_id order by &ORDERBY_FLEX, bv.budget_name SQLGL GLXRBCR_XML AR GL الموازنة -رئيسية/تفصيلية (بتنسيق XML) Imported from BI Publisher Description: تقرير الموازنة الرئيسية/التفصيلية Application: الأستاذ العام Source: الموازنة -رئيسية/تفصيلية (بتنسيق XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG D GL Budget - Gesamt/Einzel Imported from BI Publisher Description: Gesamt-/Einzelbudget Application: Rechnungswesen Source: Budget - Gesamt/Einzel (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG E GL Presupuesto - Maestro/Detalle Imported from BI Publisher Description: Informe Presupuesto Maestro/Parcial Application: General Ledger Source: Presupuesto - Maestro/Detalle (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG F GL Budget - Principal/élémentaire Imported from BI Publisher Description: Budgets élémentaires/principaux Application: General Ledger Source: Budget - Principal/élémentaire (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG I GL Budget - Generale/Dettagli Imported from BI Publisher Description: Rapporto Budget generale/dettagliato Application: General Ledger Source: Budget - Generale/Dettagli (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG JA GL 予算 - マスター/詳細 Imported from BI Publisher Description: マスター/詳細予算レポート Application: General Ledger Source: 予算 - マスター/詳細 (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG KO GL 예산 - 종합/상세 Imported from BI Publisher Description: 종합/상세 예산 보고서 Application: General Ledger Source: 예산 - 종합/상세(XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG PTB GL Orçamento - Mestre/Detalhado Imported from BI Publisher Description: Relat. Detalh.Orçam.-Mestre Application: General Ledger Source: Orçamento - Mestre/Detalhado (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG RU GL Бюджет - главный/подробный Imported from BI Publisher Description: Отчет по главному/подробному бюджету Application: Главная книга Source: Бюджет - главный/подробный (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG S GL Budget - Huvud/detalj Imported from BI Publisher Description: Huvud-/detaljbudget - rapport Application: General Ledger Source: Budget - Huvud/detalj (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG TR GL Bütçe - Ana/Detay Imported from BI Publisher Description: Ana/Detay Bütçe Raporu Application: Genel Muhasebe Source: Bütçe - Ana/Detay (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG US GL Budget - Master/Detail Imported from BI Publisher Description: Master/Detail Budget Report Application: General Ledger Source: Budget - Master/Detail (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG ZHS GL 预算 - 主/明细 Imported from BI Publisher Description: 总/明细预算报表 Application: 总帐管理系统 Source: 预算 - 主/明细 (XML) Short Name: GLXRBCR_XML DB package: GL_GLXRBCR_XMLP_PKG BI Publisher &orderby_flex &select_detail_budget &select_master_budget &where_das :access_set_name :chart_of_accounts_id :ledger_name :orderby_flex :p_access_set_id :p_budget_version_id :p_conc_request_id :p_currency_code :p_ledger_id :p_period_name :p_period_type :ptd_ytd_dsp :select_detail_budget :select_flex :select_master_budget :total_detail_bal :where_das 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_budget_version_id LOV Oracle GL_SRS_MASTER_BUDGET Y select bv.budget_version_id id, bv.budget_name value, b.description description from gl_budget_versions bv,gl_budgets b where bv.budget_version_id in (select bv2.control_budget_version_id from gl_budget_versions bv2) and b.budget_name=bv.budget_name and b.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id order by bv.budget_name Y AR الموازنة الرئيسية الموازنة الرئيسية D Gesamtbudget Gesamtbudget E Presupuesto Principal Presupuesto Principal F Budget principal Budget principal I Budget principale Budget principale JA マスター予算 マスター予算 KO 종합 예산 종합 예산 PTB Orçamento Mestre Orçamento Mestre RU Главный бюджет Главный бюджет S Huvudbudget Huvudbudget TR Ana Bütçe Ana Bütçe US Master Budget Master Budget ZHS 总预算 总预算 4 30 :p_period_name LOV Oracle GL_SRS_MASTER_BUDGET_PERIOD Y select ps.period_name id, ps.period_name value, null description from gl_period_statuses ps,gl_budget_period_ranges bpr where bpr.budget_version_id=:$flex$.gl_srs_master_budget and ps.period_year=bpr.period_year and ps.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and ps.application_id=101 and ps.period_num between bpr.start_period_num and bpr.end_period_num order by ps.period_year desc,ps.period_num desc Y AR الفترة الفترة D Periode Periode E Período Período F Période Période I Periodo Periodo JA 期間 期間 KO 기간 기간 PTB Período Período RU Период Период TR Dönem Dönem US Period Period ZHS 期间 期间 5 40 :p_currency_code LOV Oracle GL_SRS_CURRENCIES Y select currency_code id, currency_code value, null description from fnd_currencies_vl where enabled_flag in ('Y','N') order by currency_code Y AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 6 50 :p_period_type LOV Oracle GL_SRS_PERIOD_TYPES_QTD Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='PTD_YTD' order by meaning Y AR نوع المبلغ نوع المبلغ D Betragsart Betragsart E Tipo de Importe Tipo de Importe F Type de montant Type de montant I Tipo di importo Tipo di importo JA 金額タイプ 金額タイプ KO 금액 유형 금액 유형 PTB Tipo de Quantia Tipo de Quantia RU Тип суммы Тип суммы S Beloppstyp Beloppstyp TR Miktar Tipi Miktar Tipi US Amount Type Amount Type ZHS 金额类型 金额类型