ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725E51A9E05362FB09050512Y SELECT lr.target_ledger_name C_LEDGER_NAME, null C_MASTER, null C_FLEXDATA_MASTER, &P_ENDING_BALANCE Ending_Balance, &P_PATD P_PATD1, &P_QATD P_QATD1, &P_YATD P_YATD1, &P_PTD_AGGREGATE PTD_Aggregate, &P_QTD_AGGREGATE QTD_Aggregate, &P_YTD_AGGREGATE YTD_Aggregate, DECODE(dbs.currency_type, 'O', '*', NULL) C_TYPE, --null DISP_BAL_LPROMPT, fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_bal_val', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') DISP_BAL_VAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_bal_desc', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') DISP_BAL_DESC, GL_GLXAVTRB_XMLP_PKG.end_bal(:END_BAL_Total) END_BAL, GL_GLXAVTRB_XMLP_PKG.patd(:PTD_Aggregate_Total) PATD, GL_GLXAVTRB_XMLP_PKG.qatd(:QTD_Aggregate_Total) QATD, GL_GLXAVTRB_XMLP_PKG.yatd(:YTD_Aggregate_Total) YATD, 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', 'Y', 'SECURITY') BAL_SECURE, fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') DISP_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') DISP_DESC_ALL, 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_DAILY_BALANCES dbs, GL_LEDGERS l, GL_LEDGER_SET_ASSIGNMENTS ls, GL_LEDGER_RELATIONSHIPS lr WHERE cc.code_combination_id = dbs.code_combination_id AND &WHERE_lexical AND l.ledger_id = :P_LEDGER_ID AND ls.ledger_set_id (+) = l.ledger_id AND lr.source_ledger_id = NVL(ls.ledger_id, :P_LEDGER_ID) AND lr.target_ledger_id = NVL(ls.ledger_id, :P_LEDGER_ID) AND lr.target_currency_code = :P_LEDGER_CURRENCY &WHERE_DAS AND dbs.period_name = :PERIOD_NAME AND dbs.currency_code = :RESULTING_CURRENCY AND dbs.template_id is NULL AND &CURR_TYPE AND dbs.ledger_id = lr.target_ledger_id AND cc.chart_of_accounts_id = :STRUCT_NUM ORDER BY lr.target_ledger_name, &ORDERBY SQLGL GLXAVTRB_XML AR GL ميزان المراجعة - المتوسط (بتنسيق XML) Imported from BI Publisher Description: تقرير ميزان المراجعة للأرصدة المتوسطة Application: الأستاذ العام Source: ميزان المراجعة - المتوسط (بتنسيق XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG D GL Summen-/Saldenliste - Durchschnitt Imported from BI Publisher Description: Summen-/Saldenliste - Durchschnitt Application: Rechnungswesen Source: Summen-/Saldenliste - Durchschnitt (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG E GL Balance de Comprobación - Saldos Medios Imported from BI Publisher Description: Informe de Balance de Comprobación de Saldos Medios Application: General Ledger Source: Balance de Comprobación - Saldos Medios (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG F GL Balance - Moyenne Imported from BI Publisher Description: Balance des soldes moyens Application: General Ledger Source: Balance - Moyenne (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG I GL Bilancio di verifica - Medio Imported from BI Publisher Description: Rapporto Bilancio di verifica saldi medi Application: General Ledger Source: Bilancio di verifica - Medio (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG JA GL 残高試算表 - 平均 Imported from BI Publisher Description: 平均残高試算表 Application: General Ledger Source: 残高試算表 - 平均 (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG KO GL 시산표 - 평균 Imported from BI Publisher Description: 평균 잔액 시산표 보고서 Application: General Ledger Source: 시산표 - 평균(XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG PTB GL Balancete - Média Imported from BI Publisher Description: Relatório de Balancete de Saldo Médio Application: General Ledger Source: Balancete - Média (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG RU GL Пробный баланс средних сальдо Imported from BI Publisher Description: Пробный баланс средних сальдо Application: Главная книга Source: Пробный баланс средних сальдо (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG S GL Råbalans - Genomsnitt Imported from BI Publisher Description: Genomsnittligt saldo: Råbalansrapport Application: General Ledger Source: Råbalans - Genomsnitt (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG TR GL Mizan - Ortalama Imported from BI Publisher Description: Ortalama Bakiye Mizan Raporu Application: Genel Muhasebe Source: Mizan - Ortalama (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG US GL Trial Balance - Average Imported from BI Publisher Description: Average Balance Trial Balance Report Application: General Ledger Source: Trial Balance - Average (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG ZHS GL 试算表 - 平均 Imported from BI Publisher Description: 平均余额试算表报表 Application: 总帐管理系统 Source: 试算表 - 平均 (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG BI Publisher &curr_type &orderby &p_ending_balance &p_patd &p_ptd_aggregate &p_qatd &p_qtd_aggregate &p_yatd &p_ytd_aggregate &where_das &where_lexical :access_set_name :curr_type :end_bal_total :mau :orderby :p_access_set_id :p_conc_request_id :p_currency_type :p_ending_balance :p_entered_currency :p_ledger_currency :p_ledger_id :p_max_flex :p_min_flex :p_patd :p_ptd_aggregate :p_qatd :p_qtd_aggregate :p_reporting_date :p_yatd :p_ytd_aggregate :period_name :period_start_date :precision :ptd_aggregate_total :ptd_position :qtd_aggregate_total :qtd_position :quarter_start_date :resulting_currency :select_bal :select_flexdata :struct_num :where_das :where_lexical :year_start_date :ytd_aggregate_total :ytd_position 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_ledger_id Number select gl_ledger_utils_pkg.get_ledger_id_of_short_name(:$flex$.ledger_ledger_set) from dual 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 分类账标识 4 10 :p_ledger_short_name LOV Oracle GL_SRS_LEDGER_WITH_SETS_AND_ALCS_STORE_SHORT_NAME Y select nvl(rel.target_ledger_short_name,led.short_name) id, nvl(rel.target_ledger_name,led.name) value, led.description description from gl_access_set_ledgers ac,gl_ledgers led,gl_ledger_relationships rel where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and rel.source_ledger_id(+)=ac.ledger_id and rel.target_ledger_id(+)=ac.ledger_id and rel.application_id(+)=101 order by nvl(rel.target_ledger_name,led.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 分类账/分类账集 分类账/分类账集 5 20 :p_ledger_currency LOV Oracle GL_SRS_LEDGER_CURRENCIES Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code in (select rel.target_currency_code from gl_ledger_relationships rel where rel.target_ledger_short_name=:$flex$.gl_srs_ledger_with_sets_and_alcs_store_short_name union select rel.target_currency_code from gl_ledger_set_assignments ls,gl_ledger_relationships rel where ls.ledger_set_id=:$flex$.gl_srs_ledger_id_unvalidated and rel.source_ledger_id=ls.ledger_id and rel.target_ledger_id=ls.ledger_id) order by value,description select gl_ledger_utils_pkg.get_default_ledger_currency(:$flex$.ledger_ledger_set) from dual 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_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 报告日期 报告日期 9 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 账户自 账户自 10 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 账户至 账户至