ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726351A9E05362FB09050512Y select null ACCTDATA, null BAL_DATA, null FLEXDATA, nvl(bal.begin_balance_dr,0) - nvl(bal.begin_balance_cr,0) BEGIN_BAL, nvl(bal.period_net_dr,0) DEBITS, nvl(bal.period_net_cr,0) CREDITS, l.name LEDGER_NAME, 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, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCT_DESC, 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('acct_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'SECURITY') ACCT_SECURE, 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, GL_GLXETB_XMLP_PKG.end_balformula(nvl ( bal.begin_balance_dr , 0 ) - nvl ( bal.begin_balance_cr , 0 ), nvl ( bal.period_net_dr , 0 ), nvl ( bal.period_net_cr , 0 )) END_BAL, 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 from gl_code_combinations cc, gl_balances bal, gl_ledgers l &FROM_LEDGER where ( 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 ) &WHERE_LEDGER and bal.period_name = :P_PERIOD_NAME and bal.currency_code = l.currency_code and bal.actual_flag = 'E' and bal.encumbrance_type_id = :P_ENCUMBRANCE_TYPE_ID and bal.template_id is null and bal.translated_flag is null and cc.code_combination_id = bal.code_combination_id + 0 and l.ledger_id = bal.ledger_id &WHERE_DAS order by l.name, &ORDERBY_BAL, &ORDERBY_BAL2, &ORDERBY_ACCT, &ORDERBY_ACCT2, &ORDERBY_ALL SQLGL GLXETB_XML AR GL ميزان المراجعة - الالتزام (بتنسيق XML) Imported from BI Publisher Description: ميزان مراجعة الالتزام Application: الأستاذ العام Source: ميزان المراجعة - الالتزام (بتنسيق XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG D GL Summen/Saldenliste - Obligo Imported from BI Publisher Description: Summen/Saldenliste - Obligo Application: Rechnungswesen Source: Summen/Saldenliste - Obligo (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG E GL Balance de Comprobación - Compromisos Imported from BI Publisher Description: Balance de Comprobación - Compromisos Application: General Ledger Source: Balance de Comprobación - Compromisos (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG F GL Balance - Engagements Imported from BI Publisher Description: Balance des engagements Application: General Ledger Source: Balance - Engagements (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG I GL Bilancio di verifica - Impegno Imported from BI Publisher Description: Bilancio di verifica degli impegni Application: General Ledger Source: Bilancio di verifica - Impegno (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG JA GL 残高試算表 - 予算引当 Imported from BI Publisher Description: 予算引当残高試算表 Application: General Ledger Source: 残高試算表 - 予算引当 (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG KO GL 시산표 - 예산가집행 Imported from BI Publisher Description: 예산가집행 시산표 Application: General Ledger Source: 시산표 - 예산가집행(XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG PTB GL Balancete - Empenho Imported from BI Publisher Description: Balancete de Empenho Application: General Ledger Source: Balancete - Empenho (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG RU GL Пробный баланс резервирований Imported from BI Publisher Description: Пробный баланс обязательств Application: Главная книга Source: Пробный баланс резервирований (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG S GL Råbalans - Avsättning Imported from BI Publisher Description: Avsättning: Råbalans Application: General Ledger Source: Råbalans - Avsättning (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG TR GL Mizan - Bütçe Sınırlamalı Imported from BI Publisher Description: Bütçe Sınırlama Mizanı Application: Genel Muhasebe Source: Mizan - Bütçe Sınırlamalı (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG US GL Trial Balance - Encumbrance Imported from BI Publisher Description: Encumbrance Trial Balance Application: General Ledger Source: Trial Balance - Encumbrance (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG ZHS GL 试算表 - 保留款 Imported from BI Publisher Description: 保留试算表 Application: 总帐管理系统 Source: 试算表 - 保留款 (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG BI Publisher &from_ledger &orderby_acct &orderby_acct2 &orderby_all &orderby_bal &orderby_bal2 &where_das &where_ledger :access_set_name :curr_format_mask :from_ledger :mixed_precision :orderby_acct :orderby_acct2 :orderby_all :orderby_bal :orderby_bal2 :p_access_set_id :p_conc_request_id :p_encumbrance_type_id :p_ledger_id :p_period_name :param_ledger_curr :param_ledger_type :select_acct :select_all :select_bal :struct_num :thousands_separator :where_das :where_ledger 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_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 Buch/BuchSet E Libro Mayor/Juego de Libros Mayores Libro Mayor/Juego de Libros Mayores F Livre/jeu de livres Livre/jeu de livres I Libro contabile/serie libri contabili Libro contabile/serie libri contabili JA 元帳/元帳セット 元帳/元帳セット KO 원장/원장 세트 원장/원장 세트 PTB Razão/Conjunto de Razões Razão/Conjunto de Razões RU Книга/набор книг Книга/набор книг S Huvudbok/huvudboksgrupp Huvudbok/huvudboksgrupp TR Defter / Defter Kümesi Defter / Defter Kümesi US Ledger/Ledger Set Ledger/Ledger Set ZHS 分类账/分类账集 分类账/分类账集 3 20 :p_encumbrance_type_id LOV Oracle GL_SRS_ENCUMBRANCES Y select encumbrance_type_id id, encumbrance_type value, description description from gl_encumbrance_types order by encumbrance_type Y AR نوع الالتزام نوع الالتزام D Obligoart Obligoart E Tipo de Compromiso Tipo de Compromiso F Type d'engagement Type d'engagement I Tipo di impegno Tipo di impegno JA 予算引当タイプ 予算引当タイプ KO 예산가집행 유형 예산가집행 유형 PTB Tipo de Empenho Tipo de Empenho RU Тип обязательства Тип обязательства S Avsättningstyp Avsättningstyp TR Bütçe Sınırlaması Tipi Bütçe Sınırlaması Tipi US Encumbrance Type Encumbrance Type ZHS 保留款类型 保留款类型 4 30 :p_period_name LOV Oracle GL_SRS_PERIODS_EVER_OPENED Y select p2.period_name id, p2.period_name value, null description from gl_periods p2,gl_ledgers l where l.ledger_id=:$flex$.gl_srs_ledger_with_sets_store_id and p2.period_set_name=l.period_set_name and p2.period_type=l.accounted_period_type and (p2.period_year*10000+p2.period_num) in (select effective_period_num from gl_ledger_set_assignments glsa, gl_ledgers gll, gl_ledgers gl2, gl_period_statuses gps where gl2.ledger_id=l.ledger_id and glsa.ledger_set_id(+)=gl2.ledger_id and gll.ledger_id=nvl(glsa.ledger_id,gl2.ledger_id) and gll.object_type_code='L' and gll.ledger_id=gps.ledger_id and gps.application_id=101 and gps.closing_status in ('P','C','O')) order by p2.period_year desc,p2.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 期间 期间