ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725851A9E05362FB09050512 select &FLEXDATA FLEXDATA_H, &ACCOUNT_SEG ACCOUNT_SEG_H, glbv.budget_name Dep_Bud_Name, &PTD_YTD Dep_amount, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP FROM gl_code_combinations cs, gl_balances glbd, gl_budget_versions glbv where glbd.ledger_id = :P_LEDGER_ID AND glbd.currency_code = :P_CURRENCY_CODE AND glbd.period_name = :P_PERIOD_NAME AND glbd.actual_flag = 'B' AND glbd.code_combination_id = cs.code_combination_id AND glbd.budget_version_id in (select glbv1.budget_version_id from gl_budget_versions glbv1 where glbv1.control_budget_version_id = :P_BUDGET_VERSION_ID) AND glbd.budget_version_id = glbv.budget_version_id AND NVL(glbd.translated_flag,'R') = 'R' AND glbd.template_id is NOT NULL AND glbd.code_combination_id NOT IN (select glbc.code_combination_id from gl_balances glbc where glbc.ledger_id = :P_LEDGER_ID AND glbc.period_name = :P_PERIOD_NAME AND glbc.currency_code = :P_CURRENCY_CODE AND glbc.budget_version_id = :P_BUDGET_VERSION_ID AND glbc.actual_flag = 'B') &WHERE_DAS order by 1 ASC , &FLEX_ORDERBY, glbv.budget_name Y SQLGL GLRRBUDA_XML AR GL الموازنة - حسابات رئيسية/تفصيلية غير مدرجة بالموازنة (بتنسيق XML) Imported from BI Publisher Description: تقرير الحسابات الرئيسية/التفصيلية غير المدرجة بالموازنة Application: الأستاذ العام Source: الموازنة - حسابات رئيسية/تفصيلية غير مدرجة بالموازنة (بتنسيق XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG D GL Budget - Nicht budgetierte Gesamt-/Einzelkonten Imported from BI Publisher Description: Nicht budgetierte Gesamt-/Einzelkonten Application: Rechnungswesen Source: Budget - Nicht budgetierte Gesamt-/Einzelkonten (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG E GL Presupuesto - Cuentas Maestro/Detalle no Presupuestadas Imported from BI Publisher Description: Informe Cuentas Maestro/Detalle no Presupuestadas Application: General Ledger Source: Presupuesto - Cuentas Maestro/Detalle no Presupuestadas (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG F GL Budget - Comptes principaux/élémentaires non budgétés Imported from BI Publisher Description: Comptes principaux/élémentaires non budgétés Application: General Ledger Source: Budget - Comptes principaux/élémentaires non budgétés (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG I GL Budget - Conti generali/dettagliati non inseriti nel budget Imported from BI Publisher Description: Rapporto Conti generali/dettagliati non inclusi nel budget Application: General Ledger Source: Budget - Conti generali/dettagliati non inseriti nel budget (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG JA GL 予算 - 非予算マスター/詳細勘定 Imported from BI Publisher Description: 非予算マスター/詳細勘定レポート Application: General Ledger Source: 予算 - 非予算マスター/詳細勘定 (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG KO GL 예산 - 비예산 마스터/상세 계정 Imported from BI Publisher Description: 예산이 책정되지 않은 종합/상세 계정 보고서 Application: General Ledger Source: 예산 - 비예산 마스터/상세 계정(XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG PTB GL Orçamento - Contas Mestre/Detalhadas Não Previstas em Orçamento Imported from BI Publisher Description: Relatório de Contas-Mestre/Detalhadas Não Previstas em Orçamento Application: General Ledger Source: Orçamento - Contas Mestre/Detalhadas Não Previstas em Orçamento (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG RU GL Бюджет - неучтенные в бюджете главные/подробные счета Imported from BI Publisher Description: Отчет о неучтенных в бюджете главных/подробных счетах Application: Главная книга Source: Бюджет - неучтенные в бюджете главные/подробные счета (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG S GL Budget - Obudgeterade över/underordnade konton Imported from BI Publisher Description: Obudgeterade huvud- och detaljkonton - rapport Application: General Ledger Source: Budget - Obudgeterade över/underordnade konton (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG TR GL Bütçe - Bütçelenmemiş Ana/Detay Hesaplar Imported from BI Publisher Description: Bütçelenmemiş Ana/Detay Hesaplar Raporu Application: Genel Muhasebe Source: Bütçe - Bütçelenmemiş Ana/Detay Hesaplar (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG US GL Budget - Unbudgeted Master/Detail Accounts Imported from BI Publisher Description: Unbudgeted Master/Detail Accounts Report Application: General Ledger Source: Budget - Unbudgeted Master/Detail Accounts (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG ZHS GL 预算 - 预算外的主/明细账户 Imported from BI Publisher Description: 预算外的主/明细账户报表 Application: 总帐管理系统 Source: 预算 - 预算外的主/明细账户 (XML) Short Name: GLRRBUDA_XML DB package: GL_GLXRBUDA_XMLP_PKG BI Publisher &account_seg &flex_orderby &flexdata &ptd_ytd &where_das :access_set_name :account_seg :budget_name :flex_orderby :flexdata :ledger_name :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 :ptd_ytd_dsp :struct_num :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 Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='PTD_YTD' and lookup_code!='QTD' order by upper(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 金额类型 金额类型 :$flex$.gl_srs_ledger_no_sets_store_id Ledger Master Budget :$flex$.gl_srs_ledger_no_sets_store_id Ledger Period :$flex$.gl_srs_master_budget Master Budget Period