ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725D51A9E05362FB09050512 SELECT CC.code_combination_id CCID, null BAL_DATA, null FLEXDATA, dbal.accounting_date ACC_DATE, dbal.end_of_date_balance_num END_OF_DATE_BALANCE, decode(:P_BALANCE_TYPE, 'PATD', dbal.period_aggregate_num, 'QATD', dbal.quarter_aggregate_num, 'YATD', dbal.year_aggregate_num, 0) AGGREGATE, decode(:P_BALANCE_TYPE, 'PATD', dbal.period_average_to_date_num, 'QATD', dbal.quarter_average_to_date_num, 'YATD', dbal.year_average_to_date_num, 0) AVERAGE, 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_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_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_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'SECURITY') BAL_SECURE, GL_GLXAVADT_XMLP_PKG.opening_balformula(CC.code_combination_id) opening_bal, 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_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('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('acct_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'SECURITY') ACCT_SECURE, GL_GLXAVADT_XMLP_PKG.last_ccidformula(:last_ccid, CC.code_combination_id, :opening_bal) last_ccid, GL_GLXAVADT_XMLP_PKG.daily_activityformula(dbal.end_of_date_balance_num) daily_activity, GL_GLXAVADT_XMLP_PKG.last_eod_p last_eod FROM GL_DAILY_BALANCES_V DBAL, GL_CODE_COMBINATIONS CC WHERE dbal.ledger_id = :P_LEDGER_ID AND dbal.ledger_currency = :LEDGER_CURRENCY AND dbal.period_set_name = :PERIOD_SET_NAME AND dbal.period_type = :PERIOD_TYPE AND dbal.accounting_date <= :P_REPORTING_DATE AND dbal.accounting_date >= :START_DATE AND cc.chart_of_accounts_id = :STRUCT_NUM AND cc.code_combination_id = dbal.code_combination_id AND dbal.currency_code = :REPORTING_CURR AND dbal.currency_type = decode(:P_CURRENCY_TYPE, 'E', 'E', 'U') AND &WHERE_FLEX_RANGE &WHERE_DAS ORDER BY &ORDERBY_BAL, &ORDERBY_ACCT, &ORDERBY_ALL, dbal.accounting_date Y SQLGL GLXAVADT_XML AR GL تحليل الحسابات - تدقيق الرصيد المتوسط (بتنسيق XML) Imported from BI Publisher Description: تقرير مسار التدقيق للرصيد المتوسط Application: الأستاذ العام Source: تحليل الحسابات - تدقيق الرصيد المتوسط (بتنسيق XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG D GL Kontenanalyse - Prüfprotokoll Durchschnittssalden Imported from BI Publisher Description: Prüfprotokoll Durchschnittssalden Application: Rechnungswesen Source: Kontenanalyse - Prüfprotokoll Durchschnittssalden (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG E GL Análisis de Cuentas - Auditoría de Saldos Medios Imported from BI Publisher Description: Informe Análisis de Cuentas - Auditoría de Saldos Medios Application: General Ledger Source: Análisis de Cuentas - Auditoría de Saldos Medios (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG F GL Analyse des comptes - Audit des soldes moyens Imported from BI Publisher Description: Piste d'audit des soldes moyens Application: General Ledger Source: Analyse des comptes - Audit des soldes moyens (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG I GL Analisi conto - Audit saldi medi Imported from BI Publisher Description: Rapporto sulla traccia di riferimento dell'audit dei saldi medi Application: General Ledger Source: Analisi conto - Audit saldi medi (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG JA GL 勘定科目分析 - 平均残高監査 Imported from BI Publisher Description: 平均残高監査証跡レポート Application: General Ledger Source: 勘定科目分析 - 平均残高監査 (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG KO GL 계정분석 - 평균 잔액 감사 Imported from BI Publisher Description: 평균 잔액 감사 추적 보고서 Application: General Ledger Source: 계정분석 - 평균 잔액 감사(XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG PTB GL Análise de Conta - Auditoria de Saldo Médio Imported from BI Publisher Description: Relatório de Trilha de Auditoria de Saldo Médio Application: General Ledger Source: Análise de Conta - Auditoria de Saldo Médio (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG RU GL Анализ счетов - аудит средних сальдо Imported from BI Publisher Description: Отчет об аудите средних сальдо Application: Главная книга Source: Анализ счетов - аудит средних сальдо (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG S GL Kontoanalys - Verifikation av genomsnittligt saldo Imported from BI Publisher Description: Verifieringskedja för genomsnittssaldo Application: General Ledger Source: Kontoanalys - Verifikation av genomsnittligt saldo (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG TR GL Hesap Analizi - Ortalama Bakiye Denetimi Imported from BI Publisher Description: Ortalama Bakiye Denetim Listesi Raporu Application: Genel Muhasebe Source: Hesap Analizi - Ortalama Bakiye Denetimi (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG US GL Account Analysis - Average Balance Audit Imported from BI Publisher Description: Average Balance Audit Trail Report Application: General Ledger Source: Account Analysis - Average Balance Audit (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG ZHS GL 账户分析 - 平均余额审核 Imported from BI Publisher Description: 平均余额审核跟踪报表 Application: 总帐管理系统 Source: 账户分析 - 平均余额审核 (XML) Short Name: GLXAVADT_XML DB package: GL_GLXAVADT_XMLP_PKG BI Publisher &orderby_acct &orderby_all &orderby_bal &where_das &where_flex_range :access_set_name :last_ccid :last_eod :ledger_currency :ledger_name :opening_bal :orderby_acct :orderby_all :orderby_bal :p_access_set_id :p_balance_type :p_conc_request_id :p_currency_type :p_entered_currency :p_ledger_id :p_max_flex :p_min_flex :p_reporting_date :period_num :period_set_name :period_set_name_1 :period_type :period_type_1 :period_year_1 :quarter_num :reporting_curr :select_all :select_bal :start_date :start_period_name :struct_num :where_das :where_flex_range 1 -30 :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 -20 :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 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 分类账 分类账 4 20 :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 币种类型 币种类型 5 30 :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 输入币种 输入币种 6 40 :p_reporting_date Date Y AR تاريخ التقرير تاريخ التقرير D Auswertungsdatum Auswertungsdatum E Fecha del Informe Fecha del Informe F Date de déclaration Date de déclaration I Data dichiarazione Data della dichiarazione JA 日付 日付 KO 보고 일자 보고 일자 PTB Data de Geração do Relatório Data de Geração do Relatório RU Отчетная дата Отчетная дата S Rapportdatum Rapportdatum TR Raporlama Tarihi Raporlama Tarihi US Reporting Date Reporting Date ZHS 报告日期 报告日期 7 50 :p_balance_type LOV Oracle GL_SRS_AVERAGE_BALANCE_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='AVERAGE_BALANCE_TYPE' order by 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 金额类型 金额类型 8 60 :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 账户自 账户自 9 70 :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 账户至 账户至 :$flex$.currency_type Currency Type Entered Currency :$flex$.gl_srs_currency_type Currency Type Entered Currency