ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727351A9E05362FB09050512Y select ffv.flex_value PARENT_VALUE, ffvt.description PARENT_DESCRIPTION, ffh.hierarchy_name ROLLUP_GROUP, ffv.start_date_active START_DATE, ffv.end_date_active END_DATE, fl.meaning ENABLED, ffvh.child_flex_value_low CHILD_LOW, ffvh.child_flex_value_high CHILD_HIGH from fnd_lookups fl, fnd_flex_hierarchies_tl ffh, fnd_flex_value_hierarchies ffvh, fnd_flex_values_tl ffvt, fnd_flex_values ffv, fnd_id_flex_segments fifs where ffh.flex_value_set_id (+) = ffv.flex_value_set_id and ffh.hierarchy_id (+) = ffv.structured_hierarchy_level and ffh.language (+) = userenv('LANG') and ffvh.flex_value_set_id = ffv.flex_value_set_id and ffvh.parent_flex_value = ffv.flex_value and ffvt.flex_value_id = ffv.flex_value_id + 0 and ffvt.language = userenv('LANG') and ffv.flex_value_set_id = fifs.flex_value_set_id and fifs.application_id = 101 and fifs.id_flex_code = 'GL#' and fifs.id_flex_num = :P_STRUCT_NUM and fifs.segment_name = :P_SEGMENT_NAME and fl.lookup_type = 'YES_NO' and fl.lookup_code = ffv.enabled_flag order by ffv.flex_value, ffvh.child_flex_value_low, ffvh.child_flex_value_high SQLGL GLXRLRUR_XML AR GL جدول تصنيف الحسابات - قائمة مدى الاحتساب (بتنسيق XML) Imported from BI Publisher Description: تقارير جداول مختارة رئيسية/فرعية بواسطة المدى Application: الأستاذ العام Source: جدول تصنيف الحسابات - قائمة مدى الاحتساب (بتنسيق XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG D GL Kontenplan - Summierungsbereichs-Liste Imported from BI Publisher Description: Wertet Summierungsdetails nach Bereich aus. Application: Rechnungswesen Source: Kontenplan - Summierungsbereichs-Liste (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG E GL Plan de Cuentas - Listado de Rangos de Acumulación Imported from BI Publisher Description: Informa sobre acumulaciones principales/secundarias por rango Application: General Ledger Source: Plan de Cuentas - Listado de Rangos de Acumulación (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG F GL Plan de comptes - Liste des regroupements Imported from BI Publisher Description: Regroupements parent/enfant par fourchette Application: General Ledger Source: Plan de comptes - Liste des regroupements (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG I GL Piano dei conti - Elenco intervalli di aggregazione Imported from BI Publisher Description: Rapporti sulle aggregazioni padre/figlio per intervallo Application: General Ledger Source: Piano dei conti - Elenco intervalli di aggregazione (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG JA GL 勘定体系 - 積上範囲リスト Imported from BI Publisher Description: 範囲別親/子積上レポート Application: General Ledger Source: 勘定体系 - 積上範囲リスト (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG KO GL 계정 코드집 - 적상 범위 목록 Imported from BI Publisher Description: 범위별 상위/하위 적상에 대한 보고서 Application: General Ledger Source: 계정 코드집 - 적상 범위 목록(XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG PTB GL Plano de Contas - Lista de Faixas de Totalização Imported from BI Publisher Description: Relatórios sobre sumariações pai/filho por faixa Application: General Ledger Source: Plano de Contas - Lista de Faixas de Totalização (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG RU GL План счетов - список диапазонов сведения Imported from BI Publisher Description: Отчет о сведении родительских/дочерних значений по диапазонам Application: Главная книга Source: План счетов - список диапазонов сведения (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG S GL Kontoplan - Lista över övergrupper Imported from BI Publisher Description: Rapporter över överordnade/underordnade summeringar per intervall Application: General Ledger Source: Kontoplan - Lista över övergrupper (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG TR GL Hesap Planı - Özet Aralığı Listesi Imported from BI Publisher Description: Aralık bazında üst/alt özetleri raporlar. Application: Genel Muhasebe Source: Hesap Planı - Özet Aralığı Listesi (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG US GL Chart of Accounts - Rollup Range Listing Imported from BI Publisher Description: Reports on parent/child rollups by range Application: General Ledger Source: Chart of Accounts - Rollup Range Listing (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG ZHS GL 科目表 - 累计范围列表 Imported from BI Publisher Description: 按范围报告母公司/子公司累计额 Application: 总帐管理系统 Source: 科目表 - 累计范围列表 (XML) Short Name: GLXRLRUR_XML DB package: GL_GLXRLRUR_XMLP_PKG BI Publisher :coa_name :p_conc_request_id :p_segment_name :p_struct_num :struct_num 1 -20 :p_struct_num Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR GL_SRS_COA_UNVALIDATED معرف جدول تصنيف الحسابات D GL_SRS_COA_UNVALIDATED Kontenplankennung E GL_SRS_COA_UNVALIDATED Id Plan de Cuentas F GL_SRS_COA_UNVALIDATED ID plan de comptes I GL_SRS_COA_UNVALIDATED Id piano dei conti JA GL_SRS_COA_UNVALIDATED 勘定体系ID KO GL_SRS_COA_UNVALIDATED 계정 코드집 ID PTB GL_SRS_COA_UNVALIDATED Id do Plano de Contas RU GL_SRS_COA_UNVALIDATED Идент. плана счетов S GL_SRS_COA_UNVALIDATED Kontoplans-id TR GL_SRS_COA_UNVALIDATED Hesap Planı No US GL_SRS_COA_UNVALIDATED Chart of Accounts Id ZHS GL_SRS_COA_UNVALIDATED 科目表标识 2 10 :p_segment_name LOV Oracle GL_SRS_SEGMENT_NAME Y select segment_name id, segment_name value, description description from fnd_id_flex_segments_vl where id_flex_code='GL#' and id_flex_num=:$flex$.gl_srs_coa_unvalidated and enabled_flag='Y' order by value,description Y AR اسم المقطع اسم المقطع D Segmentbezeichnung Segmentbezeichnung E Nombre de Segmento Nombre de Segmento F Nom de segment Nom de segment I Nome segmento Nome segmento JA セグメント名 セグメント名 KO 세그먼트명 세그먼트명 PTB Nome do Segmento Nome do Segmento RU Имя сегмента Имя сегмента S Segmentnamn Segmentnamn TR Segment Adı Segment Adı US Segment Name Segment Name ZHS 段名 段名