ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726151A9E05362FB09050512Y select null ACCTDATA, null BAL_DATA, null FLEXDATA, l.description ACCT_TYPE, nvl(bb.begin_balance_dr,0) - nvl(bb.begin_balance_cr,0) BEGIN_BAL, nvl(be.begin_balance_dr,0) - nvl(be.begin_balance_cr,0) + nvl(be.period_net_dr,0) - nvl(be.period_net_cr,0) END_BAL, 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_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE_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_GLXBTB_XMLP_PKG.period_act_balformula(nvl ( be.begin_balance_dr , 0 ) - nvl ( be.begin_balance_cr , 0 ) + nvl ( be.period_net_dr , 0 ) - nvl ( be.period_net_cr , 0 ), nvl ( bb.begin_balance_dr , 0 ) - nvl ( bb.begin_balance_cr , 0 )) PERIOD_ACT_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_lookups l, gl_code_combinations cc, gl_balances bb, gl_balances be where be.ledger_id = :P_LEDGER_ID and be.period_name = :P_TO_PERIOD_NAME and be.currency_code =:RESULTING_CURRENCY and be.actual_flag = 'B' and be.budget_version_id = :P_BUDGET_VERSION_ID and be.template_id is null and &TRANS_CHECK_BE and bb.ledger_id(+) = :P_LEDGER_ID and bb.period_name(+) = :P_FROM_PERIOD_NAME and bb.code_combination_id(+) = be.code_combination_id + 0 and bb.currency_code(+) = :RESULTING_CURRENCY and bb.actual_flag(+) = 'B' and bb.budget_version_id(+) = :P_BUDGET_VERSION_ID and bb.template_id(+) is null and &TRANS_CHECK_BB and cc.code_combination_id = be.code_combination_id + 0 &WHERE_DAS and l.lookup_type = 'ACCOUNT TYPE' and l.lookup_code = cc.account_type /*order by &ORDERBY_BAL, &ORDERBY_ACCT, &ORDERBY_ALL*/ order by 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'),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'),fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') SQLGL GLXBTB_XML AR GL ميزان المراجعة - الموازنة (بتنسيق XML) Imported from BI Publisher Description: ميزان مراجعة الموازنة Application: الأستاذ العام Source: ميزان المراجعة - الموازنة (بتنسيق XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG D GL Summen/Saldenliste - Budget Imported from BI Publisher Description: Summen/Saldenliste - Budget Application: Rechnungswesen Source: Summen/Saldenliste - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG E GL Balance de Comprobación - Presupuesto Imported from BI Publisher Description: Balance de Comprobación - Presupuesto Application: General Ledger Source: Balance de Comprobación - Presupuesto (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG F GL Balance - Budget Imported from BI Publisher Description: Balance budgétaire Application: General Ledger Source: Balance - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG I GL Bilancio di verifica - Budget Imported from BI Publisher Description: Bilancio di verifica budget Application: General Ledger Source: Bilancio di verifica - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG JA GL 残高試算表 - 予算 Imported from BI Publisher Description: 予算残高試算表 Application: General Ledger Source: 残高試算表 - 予算 (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG KO GL 시산표 - 예산 Imported from BI Publisher Description: 예산 시산표 Application: General Ledger Source: 시산표 - 예산(XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG PTB GL Balancete - Orçamento Imported from BI Publisher Description: Balancete de Orçamento Application: General Ledger Source: Balancete - Orçamento (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG RU GL Пробный баланс бюджета Imported from BI Publisher Description: Пробный баланс бюджета Application: Главная книга Source: Пробный баланс бюджета (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG S GL Råbalans - Budget Imported from BI Publisher Description: Budget: Råbalans Application: General Ledger Source: Råbalans - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG TR GL Mizan - Bütçe Imported from BI Publisher Description: Bütçe Mizanı Application: Genel Muhasebe Source: Mizan - Bütçe (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG US GL Trial Balance - Budget Imported from BI Publisher Description: Budget Trial Balance Application: General Ledger Source: Trial Balance - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG ZHS GL 试算表 - 预算 Imported from BI Publisher Description: 预算试算表 Application: 总帐管理系统 Source: 试算表 - 预算 (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG BI Publisher &orderby_acct &orderby_all &orderby_bal &trans_check_bb &trans_check_be &where_das :access_set_name :orderby_acct :orderby_all :orderby_bal :p_access_set_id :p_budget_version_id :p_conc_request_id :p_currency_type :p_entered_currency :p_from_period_name :p_ledger_currency :p_ledger_id :p_to_period_name :resulting_currency :select_acct :select_all :select_bal :struct_num :trans_check_bb :trans_check_be :where_das 1 -30 :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 -20 :p_ledger_id Number SELECT ledger_id FROM GL_BUDGETS b, GL_BUDGET_VERSIONS bv WHERE bv.budget_version_id = :$flex$.budget AND b.budget_name = bv.budget_name AND b.budget_type = bv.budget_type Y AR GL_SRS_LEDGER_ID_UNVALIDATED معرف الأستاذ D GL_SRS_LEDGER_ID_UNVALIDATED Buchkennung E GL_SRS_LEDGER_ID_UNVALIDATED Id Libro Mayor F GL_SRS_LEDGER_ID_UNVALIDATED ID livre I GL_SRS_LEDGER_ID_UNVALIDATED Id sezionale JA GL_SRS_LEDGER_ID_UNVALIDATED 元帳ID KO GL_SRS_LEDGER_ID_UNVALIDATED 원장 ID PTB GL_SRS_LEDGER_ID_UNVALIDATED ID do Razão RU GL_SRS_LEDGER_ID_UNVALIDATED Идентификатор книги S GL_SRS_LEDGER_ID_UNVALIDATED Huvudboks-id TR GL_SRS_LEDGER_ID_UNVALIDATED Defter No US GL_SRS_LEDGER_ID_UNVALIDATED Ledger ID ZHS GL_SRS_LEDGER_ID_UNVALIDATED 分类账标识 3 10 :p_budget_version_id LOV Oracle GL_SRS_BUDGETS_DAS Y select bv.budget_version_id id, b.budget_name value, b.description description from gl_budget_versions bv,gl_budgets b where bv.budget_name=b.budget_name and b.ledger_id in (select ledger_id from gl_access_set_ledgers where access_set_id=fnd_profile.value('GL_ACCESS_SET_ID')) order by upper(b.budget_name) Y AR الموازنة اسم الموازنة D Budget Budgetbezeichnung E Presupuesto Nombre del presupuesto F Budgétaire Nom du budget I Budget Nome budget JA 予算 予算名 KO 예산 예산명 PTB Orçamento Nome do Orçamento RU Бюджет Имя бюджета S Budget Budget TR Bütçe Bütçe Adı US Budget Budget Name ZHS 预算 预算名称 4 20 :p_ledger_currency LOV Oracle GL_SRS_BUDGET_LEDGERS_BY_ID_STORE_CURRENCY Y select target_currency_code id, target_ledger_name value, null description from gl_ledger_relationships where target_ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and source_ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and application_id=101 order by value,description select name from gl_ledgers where ledger_id = :$FLEX$.GL_SRS_LEDGER_ID_UNVALIDATED Y AR الأستاذ عرض الاسم الكامل وتخزين عملة الأستاذ D Buch Zeigt die Buchbezeichnung an, speichert die Buchwährung E Libro Mayor Muestra el nombre del libro mayor, almacena la divisa del libro mayor F Livre Affiche le nom du livre, stocke la devise comptable I Libro contabile Visualizza il nome libro contabile e memorizza la divisa libro contabile JA 元帳 元帳名を表示し、 元帳通貨を保管します KO 원장 원장명을 표시하고 원장 통화를 저장합니다. PTB Razão Exibe o Nome do Razão, Armazena a Moeda do Razão RU Книга Выводится имя книги, сохраняется валюта книги S Huvudbok Visar reskontranamn, sparar reskontravaluta TR Defter Defter Adını Görüntüler, Defter Para Birimini Saklar US Ledger Displays Ledger Name, Stores Ledger Currency ZHS 分类账 显示分类账名称，存储分类账币种 5 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 Eingegeben, Statistisch oder Summe E Tipo de Divisa Introducida, estadística o total F Type de devise Saisie, Statistique ou Total I Tipo di divisa Inserita, Statistica o Totale JA 通貨タイプ 入力済、 統計または合計 KO 통화 유형 입력, 통계 또는 합계 PTB Tipo de Moeda Informado, Estatístico ou Total RU Тип валюты Введенная, статистическая или итоговая S Valutatyp Registrerad, Statistisk eller Summa TR Para Birimi Tipi Girilen, İstatistiksel veya Toplam US Currency Type Entered, Statistical or Total ZHS 币种类型 输入、统计或合计 6 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 输入币种 输入币种 7 50 :p_from_period_name LOV Oracle GL_SRS_BUDGET_START_PERIODS 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_budgets_das and bpr.open_flag='O' and ps.application_id=101 and ps.ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and ps.period_year=bpr.period_year 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 Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Начальный период Начальный период S Från period Från period TR İlk Dönem İlk Dönem US From Period From Period ZHS 自期间 自期间 8 60 :p_to_period_name LOV Oracle GL_SRS_BUDGET_END_PERIODS Y select eps.period_name id, eps.period_name value, null description from gl_period_statuses eps,gl_budget_period_ranges bpr,gl_period_statuses sps where sps.application_id=101 and sps.ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and sps.period_name=:$flex$.gl_srs_budget_start_periods and bpr.budget_version_id=:$flex$.gl_srs_budgets_das and bpr.open_flag='O' and bpr.period_year=sps.period_year and eps.application_id=101 and eps.ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and eps.period_year=bpr.period_year and eps.period_num between bpr.start_period_num and bpr.end_period_num and eps.period_year=sps.period_year and eps.period_num>=sps.period_num order by eps.period_year desc,eps.period_num desc Y AR إلى الفترة إلى الفترة D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 기간: 까지 기간: 까지 PTB Período - Até Período - Até RU Конечный период Конечный период S Till period Till period TR Son Dönem Son Dönem US To Period To Period ZHS 至期间 至期间