ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725551A9E05362FB09050512Y SELECT l2.name LEDGER_NAME , l2.ledger_id LEDGER_ID, nvl(bal.begin_balance_dr,0) BEGIN_DR, nvl(bal.begin_balance_cr,0) BEGIN_CR, nvl(bal.period_net_dr,0) PERIOD_DR, nvl(bal.period_net_cr,0) PERIOD_CR, bal.period_name PERIOD_NAME, null BAL_DATA, null FLEXDATA, cc.code_combination_id CCID, bal.period_num PERIOD_NUM, bal.period_year PERIOD_YEAR, cc.template_id TEMPLATE_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BAL_FIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BAL_FIELD_W_DEP, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') BAL_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'SECURITY') BAL_SECURE, GL_GLRGNL_XMLP_PKG.CP_1_p CP_1, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_FIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_field', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_FIELD_W_DEP, 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('flexdesc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') FLEXDESC, 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, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEX_SECURE, GL_GLRGNL_XMLP_PKG.OLD_CCID_p OLD_CCID, GL_GLRGNL_XMLP_PKG.new_recordformula(cc.code_combination_id) NEW_RECORD, GL_GLRGNL_XMLP_PKG.begin_balformula(nvl ( bal.begin_balance_cr , 0 ), nvl ( bal.begin_balance_dr , 0 )) BEGIN_BAL, GL_GLRGNL_XMLP_PKG.end_balformula(nvl ( bal.begin_balance_cr , 0 ), nvl ( bal.period_net_cr , 0 ), nvl ( bal.begin_balance_dr , 0 ), nvl ( bal.period_net_dr , 0 )) END_BAL, GL_GLRGNL_XMLP_PKG.bad_startformula(:new_record, bal.period_num, bal.period_year, nvl ( bal.begin_balance_dr , 0 ), nvl ( bal.begin_balance_cr , 0 ), nvl ( bal.period_net_dr , 0 ), nvl ( bal.period_net_cr , 0 )) BAD_START, GL_GLRGNL_XMLP_PKG.bad_endformula(nvl ( bal.period_net_dr , 0 ), :TOTAL_DR, nvl ( bal.period_net_cr , 0 ), :TOTAL_CR, cc.template_id) BAD_END, GL_GLRGNL_XMLP_PKG.OLD_END_DR_p OLD_END_DR, GL_GLRGNL_XMLP_PKG.OLD_END_CR_p OLD_END_CR, GL_GLRGNL_XMLP_PKG.LAST_PERIOD_YEAR_p LAST_PERIOD_YEAR FROM GL_LEDGERS L, GL_LEDGER_SET_ASSIGNMENTS LS, GL_LEDGERS L2, GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES PS, GL_BALANCES BAL WHERE 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 AND ps.application_id = 101 AND ps.ledger_id = l2.ledger_id AND ps.effective_period_num >= :START_EFF_PERIOD_NUM AND ps.effective_period_num <= :END_EFF_PERIOD_NUM AND cc.chart_of_accounts_id = :STRUCT_NUM AND &WHERE &WHERE_DAS AND bal.code_combination_id = cc.code_combination_id AND bal.ledger_id = l2.ledger_id AND bal.period_name = ps.period_name AND bal.currency_code = decode(:P_CURRENCY_TYPE, 'S','STAT',:P_LEDGER_CURRENCY) AND bal.actual_flag = :P_ACTUAL_FLAG AND &WHERE_ACTUAL_TYPE AND &WHERE_INDEX AND ( ( nvl(bal.begin_balance_dr, 0) - nvl(bal.begin_balance_cr,0) != 0 OR nvl(bal.period_net_dr,0) != 0 OR nvl(bal.period_net_cr,0) != 0) OR (EXISTS (SELECT 'has data' FROM gl_je_lines jel, gl_je_headers jeh, gl_je_batches jeb WHERE jel.code_combination_id = bal.code_combination_id AND jel.period_name = bal.period_name AND jel.ledger_id = bal.ledger_id AND jel.status = 'P' AND ((nvl(jel.accounted_dr,0) != 0 OR nvl(jel.accounted_cr,0) != 0) OR (nvl(jel.accounted_dr,0) = 0 AND nvl(jel.accounted_cr,0) = 0 AND jel.stat_amount is not NULL)) AND jeh.je_header_id = jel.je_header_id+0 AND jeh.currency_code = bal.currency_code AND jeh.actual_flag = bal.actual_flag AND nvl(jeh.budget_version_id, -1) = nvl(bal.budget_version_id, -1) AND nvl(jeh.encumbrance_type_id, -1) = nvl(bal.encumbrance_type_id, -1) AND jeh.status = 'P' AND jeb.je_batch_id = jeh.je_batch_id + 0 AND jeb.status = 'P'))) ORDER BY l2.name, &ORDERBY_BAL, &ORDERBY_ACCT, &ORDERBY_ALL, ps.period_year, ps.period_num SQLGL GLGENLED_XML AR GL دفتر الأستاذ العام - (132 حرف) (بتنسيق XML) Imported from BI Publisher Description: الأستاذ العام Application: الأستاذ العام Source: دفتر الأستاذ العام - (132 حرف) (بتنسيق XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG D GL Rechnungswesen - (132 Zeichen) Imported from BI Publisher Description: Rechnungswesen Application: Rechnungswesen Source: Rechnungswesen - (132 Zeichen) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG E GL Contabilidad General - (132 Car) Imported from BI Publisher Description: Libro Contable Application: General Ledger Source: Contabilidad General - (132 Car) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG F GL Grand Livre - (132 car) Imported from BI Publisher Description: General Ledger Application: General Ledger Source: Grand Livre - (132 car) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG I GL General Ledger - (132 caratteri) Imported from BI Publisher Description: Contabilità generale Application: General Ledger Source: General Ledger - (132 caratteri) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG JA GL 総勘定元帳 - (132文字) Imported from BI Publisher Description: 総勘定元帳 Application: General Ledger Source: 総勘定元帳 - (132文字) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG KO GL - (132자) Imported from BI Publisher Description: GL Application: General Ledger Source: GL - (132자)(XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG PTB GL Razão Geral - (132 Caracteres) Imported from BI Publisher Description: General Ledger Application: General Ledger Source: Razão Geral - (132 Caracteres) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG RU GL Главная книга (132 символа) Imported from BI Publisher Description: Главная книга Application: Главная книга Source: Главная книга (132 символа) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG S GL Huvudbok - (132 tkn) Imported from BI Publisher Description: Huvudbok Application: General Ledger Source: Huvudbok - (132 tkn) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG TR GL Kebir Defteri - (132 Karakter) Imported from BI Publisher Description: Genel Muhasebe Application: Genel Muhasebe Source: Kebir Defteri - (132 Karakter) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG US GL General Ledger - (132 Char) Imported from BI Publisher Description: General Ledger Application: General Ledger Source: General Ledger - (132 Char) (XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG ZHS GL 总账 -（132 个字符） Imported from BI Publisher Description: 总账 Application: 总帐管理系统 Source: 总账 -（132 个字符）(XML) Short Name: GLGENLED_XML DB package: GL_GLRGNL_XMLP_PKG BI Publisher &orderby_acct &orderby_all &orderby_bal &where &where_actual_type &where_das &where_index :access_set_name :cp_1 :end_eff_period_num :exclaimation_point :l_where :last_period_year :new_record :old_ccid :old_end_cr :old_end_dr :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_code :p_currency_type :p_end_period :p_entered_currency :p_kind :p_ledger_currency :p_ledger_id :p_max_flex :p_min_flex :p_page_size :p_start_period :resulting_currency :select_all :select_bal :select_cr :select_dr :select_reference :star :start_eff_period_num :struct_num :total_cr :total_dr :where_actual_type :where_currency_code :where_das :where_index 1 -50 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة الوصول للبيانات معرف مجموعة الوصول للبيانات D Kennung DatenzugriffsSet Kennung DatenzugriffsSet E Id Juego de Accesos a Datos Id Juego de Accesos a Datos F ID jeu d'accès aux données ID jeu d'accès aux données I Id serie di accesso dati Id della serie di accesso ai dati JA データ・アクセス・セットID データ・アクセス・セットID KO 데이터 액세스 세트 ID 데이터 액세스 세트 ID PTB ID do Conjunto de Acesso a Dados ID do Conjunto de Acesso a Dados RU Идент. набора доступа к данным Идент. набора доступа к данным S Id för dataåtkomstuppsättning Id för dataåtkomstuppsättning TR Veri Erişim Kümesi No Veri Erişim Kümesi No US Data Access Set ID Data Access Set ID ZHS 数据访问权限集标识 数据访问权限集标识 2 -40 :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 -30 :p_dummy 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 =:$flex$.currency_type Y AR GL_SRS_CURRENCY_TYPE نوع العملة - افتراضي D GL_SRS_CURRENCY_TYPE Währungsart - Dummy E GL_SRS_CURRENCY_TYPE Tipo de Divisa - Ficticia F GL_SRS_CURRENCY_TYPE Type de devise - Fictif I GL_SRS_CURRENCY_TYPE Tipo di divisa - fittizio JA GL_SRS_CURRENCY_TYPE 通貨タイプ - ダミー KO GL_SRS_CURRENCY_TYPE 통화 유형 - Dummy PTB GL_SRS_CURRENCY_TYPE Tipo de Moeda - Fictício RU GL_SRS_CURRENCY_TYPE Тип валюты - фиктивный S GL_SRS_CURRENCY_TYPE Valutatyp - dummy TR GL_SRS_CURRENCY_TYPE Para Birimi Tipi - Sözde US GL_SRS_CURRENCY_TYPE Currency Type - Dummy ZHS GL_SRS_CURRENCY_TYPE 货币类型 - 虚拟 4 -20 :p_page_size Number 132 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 页面大小 页面大小 5 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 分类账/分类账集 分类账标识 6 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 分类账币种 分类账币种 7 30 :p_currency_type LOV Oracle GL_SRS_CURRENCY_TYPE_NO_E Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_CURRENCY_TYPE' and lookup_code in ('T','S') 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 币种类型 币种类型 8 40 :p_kind LOV Oracle GL_SRS_LEDGER_RPT_KIND Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='LEDGER_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 50 :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 60 :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 70 :p_start_period LOV Oracle GL_SRS_LEDGER_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 80 :p_end_period LOV Oracle GL_SRS_LEDGER_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 (period_year>(select period_year from gl_srs_ledger_period_start where period_name= :$flex$.gl_srs_ledger_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) or (period_year=(select period_year from gl_srs_ledger_period_start where period_name= :$flex$.gl_srs_ledger_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) and period_num>=(select period_num from gl_srs_ledger_period_start where period_name =:$flex$.gl_srs_ledger_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,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 90 :p_min_flex Char Y AR الحساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR Hesap, İlk Hesap, İlk US Account From Account From ZHS 账户自 账户自 14 100 :p_max_flex Char Y AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目:至 勘定科目:至 KO 계정: 까지 계정: 까지 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Hesap, Son Hesap, Son US Account To Account To ZHS 账户至 账户至