ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727051A9E05362FB09050512 select null FLEX_DATA_ALL, null FLEX_DATA_BAL, null FLEX_DATA_ACCT, ghr.period_year PERIOD_YEAR, ghr.period_num PERIOD_NUM, ghr.period_name PERIOD_NAME, ghr.target_currency TARGET_CURRENCY, gl1.meaning RATE_TYPE, ghr.translated_rate RATE, ghr.translated_amount AMOUNT, gl2.meaning ACCOUNT_TYPE, gl3.meaning USAGE_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') FLEX_DESC_ACCT from gl_lookups gl1, gl_lookups gl2, gl_lookups gl3, gl_code_combinations gcc, gl_historical_rates ghr where ghr.ledger_id = :P_LEDGER_ID and ghr.code_combination_id = gcc.code_combination_id and gl1.lookup_type (+) = 'RATE_TYPE' and gl1.lookup_code (+) = ghr.rate_type and gl2.lookup_type (+) = 'ACCOUNT TYPE' and gl2.lookup_code (+) = ghr.account_type and gl3.lookup_type(+) = 'CONSOLIDATION_USAGE' and gl3.lookup_code(+) = ghr.usage_code and ghr.period_year * 10000 + ghr.period_num between :FROM_EFF_PERIOD_NUM and :TO_EFF_PERIOD_NUM &WHERE_DAS order by ghr.period_year, ghr.period_num, ghr.target_currency, &FLEX_ORDERBY_BAL_D, &FLEX_ORDERBY_BAL_I, &FLEX_ORDERBY_ACCT_D, &FLEX_ORDERBY_ACCT_I, &FLEX_ORDERBY_ALL Y SQLGL GLXRLHST_XML AR GL العملة - قائمة الأسعار التاريخية (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة الأسعار التاريخية Application: الأستاذ العام Source: العملة - قائمة الأسعار التاريخية (بتنسيق XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG D GL Währungen - Historische Wechselkurse Imported from BI Publisher Description: Historische Kurse Application: Rechnungswesen Source: Währungen - Historische Wechselkurse (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG E GL Divisa - Listado de Tipos de Cambio Históricos Imported from BI Publisher Description: Divisa - Listado de Tipos de Cambio Históricos Application: General Ledger Source: Divisa - Listado de Tipos de Cambio Históricos (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG F GL Devise - Liste des taux historiques Imported from BI Publisher Description: Liste des taux historiques Application: General Ledger Source: Devise - Liste des taux historiques (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG I GL Divisa - Elenco tassi storici Imported from BI Publisher Description: Rapporto Elenco tassi storici Application: General Ledger Source: Divisa - Elenco tassi storici (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG JA GL 通貨 - 取得時レート・リスト Imported from BI Publisher Description: 取得時レート・リスト・レポート Application: General Ledger Source: 通貨 - 取得時レート・リスト(XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG KO GL 통화 - 역사적 환율 목록 Imported from BI Publisher Description: 역사적 환율 목록 보고서 Application: General Ledger Source: 통화 - 역사적 환율 목록(XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG PTB GL Moeda - Lista de Taxas Históricas Imported from BI Publisher Description: Relatório de Lista de Taxas Históricas Application: General Ledger Source: Moeda - Lista de Taxas Históricas (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG RU GL Валюта - список исторических курсов Imported from BI Publisher Description: Список исторических курсов Application: Главная книга Source: Валюта - список исторических курсов (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG S GL Valuta - Lista över kurshistorik Imported from BI Publisher Description: Historik över kurser - listrapport Application: General Ledger Source: Valuta - Lista över kurshistorik (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG TR GL Para Birimi - Tarihsel Kurlar Listesi Imported from BI Publisher Description: Tarihsel Kurlar Liste Raporu Application: Genel Muhasebe Source: Para Birimi - Tarihsel Kurlar Listesi (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG US GL Currency - Historical Rates Listing Imported from BI Publisher Description: Historical Rates Listing Report Application: General Ledger Source: Currency - Historical Rates Listing (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG ZHS GL 币种 - 历史汇率列表 Imported from BI Publisher Description: 历史汇率列表报表 Application: 总帐管理系统 Source: 币种 - 历史汇率列表 (XML) Short Name: GLXRLHST_XML DB package: GL_GLXRLHST_XMLP_PKG BI Publisher &flex_orderby_acct_d &flex_orderby_acct_i &flex_orderby_all &flex_orderby_bal_d &flex_orderby_bal_i &where_das :average_balances_flag :flex_orderby_acct_d :flex_orderby_acct_i :flex_orderby_all :flex_orderby_bal_d :flex_orderby_bal_i :flex_select_acct :flex_select_all :flex_select_bal :from_eff_period_num :functional_currency :ledger_name :p_access_set_id :p_conc_request_id :p_from_period :p_ledger_id :p_min_precision :p_to_period :struct_num :to_eff_period_num :where_das 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_min_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') AR الحد الأدنى للدقة الحد الأدنى للدقة D Mindestanzahl Nachkommastellen Mindestanzahl Nachkommastellen E Precisión Mínima Precisión Mínima F Précision minimale Précision minimale I Precisione minima Precisione minima JA 最小精度 最小精度 KO 최소 소수점 자리 최소 소수점 자리 PTB Precisão mínima Precisão mínima RU Минимальная точность Минимальная точность S Minsta precision Minsta precision TR Minimum duyarlılık Minimum duyarlılık US Minimum precision Minimum precision 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_from_period LOV Oracle GL_SRS_PERIODS_LEDGER_NO_SETS Y select p.period_name id, p.period_name value, null description from gl_period_statuses p where p.application_id=101 and p.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and p.closing_status in ('O','C','P') order by p.period_year desc,p.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 自期间 自期间 5 30 :p_to_period LOV Oracle GL_SRS_END_PERIODS_LEDGER_NO_SETS Y select p2.period_name id, p2.period_name value, null description from gl_period_statuses p,gl_period_statuses p2 where p.application_id=101 and p.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and p.period_name=:$flex$.gl_srs_periods_ledger_no_sets and p2.application_id=101 and p2.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and p2.closing_status in ('O','C','P') and p2.effective_period_num>=p.effective_period_num order by p2.period_year desc,p2.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 至期间 至期间 :$flex$.gl_srs_ledger_no_sets_store_id Ledger From Period :$flex$.gl_srs_ledger_no_sets_store_id Ledger To Period :$flex$.gl_srs_periods_ledger_no_sets From Period To Period