ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4724F51A9E05362FB09050512Y select l2.name LEDGER_NAME, l2.ledger_id LEDGER_ID, max(bal.period_name) PERIOD_NAME, &SELECT_BEGIN_DR BEGIN_DR, &SELECT_BEGIN_CR BEGIN_CR, &SELECT_END_DR END_DR, &SELECT_END_CR END_CR, GL_GLRJED_XMLP_PKG.begin_balformula(sum ( nvl ( bal.begin_balance_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) )) BEGIN_BAL, GL_GLRJED_XMLP_PKG.begin_bal_dr_crformula(sum ( nvl ( bal.begin_balance_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) )) BEGIN_BAL_DR_CR, GL_GLRJED_XMLP_PKG.end_balformula(sum ( nvl ( bal.begin_balance_dr , 0 ) + nvl ( bal.period_net_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) + nvl ( bal.period_net_cr , 0 ) )) END_BAL, GL_GLRJED_XMLP_PKG.end_bal_dr_crformula(sum ( nvl ( bal.begin_balance_dr , 0 ) + nvl ( bal.period_net_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) + nvl ( bal.period_net_cr , 0 ) )) END_BAL_DR_CR FROM gl_ledgers l, gl_ledger_set_assignments ls, gl_ledgers l2, gl_period_statuses per, gl_code_combinations cc, gl_balances bal WHERE &WHERE_FLEX AND cc.chart_of_accounts_id = :STRUCT_NUM AND l.ledger_id = :P_LEDGER_ID AND ls.ledger_set_id (+) = l.ledger_id AND l2.ledger_id = nvl(ls.ledger_id, l.ledger_id) AND l2.currency_code = :P_LEDGER_CURRENCY &WHERE_DAS_BAL AND per.application_id = 101 AND per.ledger_id = l2.ledger_id AND per.effective_period_num BETWEEN :START_EFFECTIVE_PERIOD_NUM AND :END_EFFECTIVE_PERIOD_NUM AND bal.code_combination_id = cc.code_combination_id AND bal.period_name = per.period_name AND bal.actual_flag = :P_ACTUAL_FLAG AND &WHERE_ACTUAL_TYPE AND bal.currency_code = :RESULTING_CURRENCY AND &WHERE_CURRENCY_BAL AND bal.ledger_id = l2.ledger_id AND bal.template_id is null &SECURITY_FILTER_STR GROUP BY l2.name, l2.ledger_id, per.period_year, per.period_num ORDER BY l2.name, per.period_year, per.period_num SQLGL GLACTANL2_XML AR GL تحليل الحسابات - (180 حرف) (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل الحساب Application: الأستاذ العام Source: تحليل الحسابات - (180 حرف) (بتنسيق XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG D GL Kontenanalyse (180 Zeichen) Imported from BI Publisher Description: Kontenanalyse Application: Rechnungswesen Source: Kontenanalyse (180 Zeichen) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG E GL Análisis de Cuentas - (180 Car) Imported from BI Publisher Description: Informe Análisis de Cuentas Application: General Ledger Source: Análisis de Cuentas - (180 Car) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG F GL Analyse des comptes - (180 car) Imported from BI Publisher Description: Etat d'analyse des comptes Application: General Ledger Source: Analyse des comptes - (180 car) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG I GL Analisi conto - (180 caratteri) Imported from BI Publisher Description: Rapporto Analisi conti Application: General Ledger Source: Analisi conto - (180 caratteri) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG JA GL 勘定科目分析 - (180文字) Imported from BI Publisher Description: 勘定科目分析レポート Application: General Ledger Source: 勘定科目分析 - (180文字) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG KO GL 계정분석 - (180자) Imported from BI Publisher Description: 계정 분석 보고서 Application: General Ledger Source: 계정분석 - (180자)(XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG PTB GL Análise de Conta - (180 Caracteres) Imported from BI Publisher Description: Relatório de Análise de Conta Application: General Ledger Source: Análise de Conta - (180 Caracteres) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG RU GL Анализ счетов (180 символов) Imported from BI Publisher Description: Анализ счетов Application: Главная книга Source: Анализ счетов (180 символов) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG S GL Kontoanalys - (180 tkn) Imported from BI Publisher Description: Kontoanalysrapport Application: General Ledger Source: Kontoanalys - (180 tkn) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG TR GL Hesap Analizi - (180 Karakter) Imported from BI Publisher Description: Hesap Analiz Raporu Application: Genel Muhasebe Source: Hesap Analizi - (180 Karakter) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG US GL Account Analysis - (180 Char) Imported from BI Publisher Description: Account Analysis Report Application: General Ledger Source: Account Analysis - (180 Char) (XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG ZHS GL 账户分析 -（180 个字符） Imported from BI Publisher Description: 账户分析报表 Application: 总帐管理系统 Source: 账户分析 -（180 个字符）(XML) Short Name: GLACTANL2_XML DB package: GL_GLRJED_XMLP_PKG BI Publisher &security_filter_str &select_begin_cr &select_begin_dr &select_end_cr &select_end_dr &where_actual_type &where_currency_bal &where_das_bal &where_flex :access_set_name :cr_meaning :dr_meaning :end_effective_period_num :order_by :orderby_acct :orderby_acct2 :orderby_all :orderby_bal :orderby_bal2 :p_access_set_id :p_actual_flag :p_bud_enc_type_id :p_conc_request_id :p_currency_type :p_end_period :p_entered_currency :p_kind :p_ledger_currency :p_ledger_id :p_max_flex :p_min_flex :p_order_type :p_page_size :p_start_period :param_acct_from :param_acct_to :param_currency_type :param_period_from :param_period_to :param_reference_type :resulting_currency :security_filter_str :select_all :select_begin_cr :select_begin_dr :select_cr :select_dr :select_end_cr :select_end_dr :select_reference :start_effective_period_num :struct_num :where_actual_type :where_currency_bal :where_currency_code :where_das_bal :where_das_je :where_flex 1 -40 :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 della 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 -30 :p_chart_of_accounts_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB ID do Plano de Contas ID do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts ID Chart of Accounts ID ZHS 科目表标识 科目表标识 3 -20 :p_page_size LOV Oracle GL_SRS_PAGE_SIZE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=101714 order by ffvv.flex_value 180 Y AR حجم الصفحة حجم الصفحة D Seitenformat Seitenformat E Tamaño de Página Tamaño de Página F Taille de page Taille de page I Dimensioni pagina Dimensioni della pagina JA ページ・サイズ ページ・サイズ KO 페이지 크기 페이지 크기 PTB Tam. Pág. Tam. Pág. RU Размер страницы Размер страницы S Sidstorlek Sidstorlek TR Sayfa Boyutu Sayfa Boyutu US Page Size Page Size ZHS 页面大小 页面大小 4 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_WITH_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 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/BuchSet Buchkennung E Libro Mayor/Juego de Libros Mayores Id Libro Mayor F Livre/jeu de livres ID livre I Libro contabile/serie libri contabili Id sezionale JA 元帳/元帳セット 元帳ID KO 원장/원장 세트 원장 ID PTB Razão/Conjunto de Razões Id do Razão RU Книга/набор книг Идентификатор книги S Huvudbok/huvudboksgrupp Huvudboks-id TR Defter / Defter Kümesi Defter No US Ledger/Ledger Set Ledger Id ZHS 分类账/分类账集 分类账标识 5 20 :p_ledger_currency LOV Oracle GL_SRS_LEDGER_CURRENCIES_NO_TRANSLATED_ALC Y select currency_code id, currency_code value, null description from fnd_currencies where currency_code in (select currency_code from gl_ledgers where ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id union select l.currency_code from gl_ledgers l,gl_ledger_set_assignments ls where ls.ledger_set_id=:$flex$.gl_srs_ledger_with_sets_store_id and l.ledger_id=ls.ledger_id) order by value,description SELECT GL_LEDGER_UTILS_PKG.GET_DEFAULT_LEDGER_CURRENCY(SHORT_NAME) FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger_ledger_set Y AR عملة الأستاذ عملة الأستاذ D Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa del libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类账币种 分类账币种 6 30 :p_currency_type LOV Oracle GL_SRS_CURRENCY_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_CURRENCY_TYPE' and lookup_code in ('T','S','E') order by meaning SELECT MEANING FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE' AND LOOKUP_CODE ='T' Y AR نوع العملة نوع العملة D Währungsart Währungsart E Tipo de Divisa Tipo de Divisa F Type de devise Type de devise I Tipo di divisa Tipo di divisa JA 通貨タイプ 通貨タイプ KO 통화 유형 통화 유형 PTB Tipo de Moeda Tipo de Moeda RU Тип валюты Тип валюты S Valutatyp Valutatyp TR Para Birimi Tipi Para Birimi Tipi US Currency Type Currency Type ZHS 币种类型 币种类型 7 40 :p_entered_currency LOV Oracle GL_SRS_ENTERED_CURRENCIES Y select currency_code id, currency_code value, null description from gl_entered_currencies_v where currency_type=:$flex$.gl_srs_currency_type order by value,description SELECT CURRENCY_CODE FROM GL_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = DECODE(:$flex$.currency_type, 'S', 'S', 'T', 'T', NULL) Y AR العملة المدخلة العملة المدخلة D Eingabewährung Eingabewährung E Divisa Introducida Divisa Introducida F Devise de saisie Devise de saisie I Divisa inserita Divisa inserita JA 入力通貨 入力通貨 KO 입력 통화 입력 통화 PTB Moeda Informada Moeda Informada RU Введенная валюта Введенная валюта S Registrerad valuta Registrerad valuta TR Girilen Para Birimi Girilen Para Birimi US Entered Currency Entered Currency ZHS 输入币种 输入币种 8 50 :p_kind LOV Oracle GL_SRS_ACCT_RPT_KIND Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='ACCOUNT_RPT_KIND' order by meaning Y AR النوع النوع D Art Art E Tipo Tipo I Tipo Tipo JA タイプ タイプ KO 유형 유형 PTB Tipo Tipo RU Тип Тип S Typ Typ TR Tip Tip US Type Type ZHS 类型 类型 9 60 :p_actual_flag LOV Oracle GL_SRS_ACCTANL_BALANCE_TYPE Y select lk.lookup_code id, lk.meaning value, lk.description description from gl_lookups lk,gl_ledgers l where lk.lookup_type='BATCH_TYPE' and l.ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id and (lk.lookup_code!='B' or l.object_type_code='L') and (lk.lookup_code!='E' or :$flex$.gl_srs_currency_type='T') order by upper(lk.meaning) Y AR نوع الرصيد نوع الرصيد D Saldenart Saldenart E Tipo de Saldo Tipo de Saldo F Type de solde Type de solde I Tipo di saldo Tipo di saldo JA 残高タイプ 残高タイプ KO 잔액 유형 잔액 유형 PTB Tipo de Saldo Tipo de Saldo RU Тип сальдо Тип сальдо S Saldotyp Saldotyp TR Bakiye Tipi Bakiye Tipi US Balance Type Balance Type ZHS 余额类型 余额类型 10 70 :p_bud_enc_type_id LOV Oracle GL_SRS_ACCTANL_BUD_ENCUM_NAME Y select budget_encumbrance_id id, budget_encumbrance_name value, null description from gl_srs_ledger_bud_encum_name where actual_flag=:$flex$.gl_srs_acctanl_balance_type and decode(actual_flag,'A',:$flex$.gl_srs_ledger_with_sets_store_id,'E',:$flex$.gl_srs_ledger_with_sets_store_id,ledger_id)=:$flex$.gl_srs_ledger_with_sets_store_id order by value,description SELECT decode(:$flex$.balance_type, 'A', meaning, null) FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE='N/A' Y AR اسم الموازنة أو الالتزام اسم الموازنة أو الالتزام D Budget oder Obligo Budget oder Obligo E Nombre Presupuesto o Compromiso Nombre Presupuesto o Compromiso F Nom du budget ou de l'engagement Nom du budget ou de l'engagement I Nome budget o impegno Nome del budget o dell'impegno JA 予算または予算引当名 予算または予算引当名 KO 예산명 또는 예산가집행명 예산명 또는 예산가집행명 PTB Nome do Orçamento ou do Empenho Nome do Orçamento ou do Empenho RU Имя бюджета или обязательства Имя бюджета или обязательства S Budget eller avsättning Budget eller avsättning TR Bütçe veya Bütçe Sınırlaması Adı Bütçe veya Bütçe Sınırlaması Adı US Budget or Encumbrance Name Budget or Encumbrance Name ZHS 预算或保留名称 预算或保留名称 11 80 :p_start_period LOV Oracle GL_SRS_ACCTANL_PERIOD_START Y select period_name id, period_name value, null description from gl_srs_ledger_period_start where actual_flag=:$flex$.gl_srs_acctanl_balance_type and ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id and decode(actual_flag,'B',budget_encumbrance_id, :$flex$.gl_srs_acctanl_bud_encum_name) =:$flex$.gl_srs_acctanl_bud_encum_name order by period_year desc,period_num desc Y AR فترة البداية فترة البداية D Von Periode Von Periode E Período Inicial Período Inicial F Période de début Période de début I Periodo iniziale Periodo iniziale JA 期間:自 期間:自 KO 시작 기간 시작 기간 PTB Período Inicial Período Inicial RU Начальный период Начальный период S Startperiod Startperiod TR Başlangıç Dönemi Başlangıç Dönemi US Starting Period Starting Period ZHS 起始期间 起始期间 12 90 :p_end_period LOV Oracle GL_SRS_ACCTANL_PERIOD_END Y select period_name id, period_name value, null description from gl_srs_ledger_period_start where actual_flag=:$flex$.gl_srs_acctanl_balance_type and ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id and decode(actual_flag, 'B',budget_encumbrance_id, :$flex$.gl_srs_acctanl_bud_encum_name)= :$flex$.gl_srs_acctanl_bud_encum_name and effective_period_num>= (select effective_period_num from gl_srs_ledger_period_start where period_name=:$flex$.gl_srs_acctanl_period_start and actual_flag=:$flex$.gl_srs_acctanl_balance_type and ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id and decode(actual_flag, 'B',budget_encumbrance_id, :$flex$.gl_srs_acctanl_bud_encum_name)= :$flex$.gl_srs_acctanl_bud_encum_name) order by period_year desc,effective_period_num desc Y AR فترة النهاية فترة النهاية D Bis Periode Bis Periode E Período Final. Período Final. F Période de fin Période de fin I Periodo finale Periodo finale JA 終了期間 終了期間 KO 마감 기간 마감 기간 PTB Período Final Período Final RU Конечный период Конечный период S Slutperiod Slutperiod TR Bitiş Dönemi Bitiş Dönemi US Ending Period Ending Period ZHS 终止期 终止期 13 100 :p_min_flex Char Y AR حقل مرن من حقل مرن من D Von FlexFeld Von FlexFeld E De Estructura De Estructura F Clé flexible - De Clé flexible - De I Flexfield - Da Flexfield - Da JA フレックスフィールド:自 フレックスフィールド:自 KO 가변필드 From 가변필드 From PTB Do Flex Do Flex RU ГП с ГП с S Från flexfält Från flexfält TR İlk Esnekalan İlk Esnekalan US Flexfield From Flexfield From ZHS 弹性域自 弹性域自 14 110 :p_max_flex Char Y AR حقل مرن إلى حقل مرن إلى D Bis FlexFeld Bis FlexFeld E A Estructura A Estructura F Clé flexible - A Clé flexible - A I Flexfield - A Flexfield - A JA フレックスフィールド:至 フレックスフィールド:至 KO 가변필드 To 가변필드 To PTB Até o Flex Até o Flex RU ГП по ГП по S Till flexfält Till flexfält TR Son Esnekalan Son Esnekalan US Flexfield To Flexfield To ZHS 弹性域至 弹性域至 15 120 :p_order_type LOV Oracle GL_SRS_GLACTANL_SORT_BY Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='GLACTANL_SORT_BY' order by meaning Y AR ترتيب بواسطة م - المصدر ق - مقطع الترصيد ح - مقطع الحساب D Sortieren nach H - Herkunft B - Buchungskreis K - Kontensegment E Ordenar por S - origen B - segmento de balance A - segmento de cuenta F Tri par S - origine B - segment d'équilibrage A - segment de compte I Ordina per O - origine Q - segmento quadratura A - segmento conto JA ソート・キー S - ソース B - 貸借一致セグメント A - 勘定科目セグメント KO 정렬 기준 S - 출처 B - 잔액조정 세그먼트 A - 계정 세그먼트 PTB Ord. Por O - origem B - segmento balanceador C - segmento de conta RU Сортировка S - источник, B - балансирующий сегмент, A - сегмент счета S Ordna per S - källa B - balanssegment A - kontosegment TR Sıralama Bazı S - kaynak B - dengeleme segmenti A - hesap segmenti US Order By S - source B - balancing segment A - account segment ZHS 排序依据 S - 来源 B - 平衡段 A - 账户段