ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEE379D2E0530100007F1FF2 GL Chart of Accounts Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) order by fifsv.id_flex_structure_name AR مخطط حسابات جميع دفاتر الأستاذ التي يمكن الوصول إليها من خلال تعيين مجموعة الوصول إلى دفتر الأستاذ D Kontenplan aller Ledger, die über die Ledger-Zugriffs-Set-Zuordnung zugänglich sind E Plan de cuentas de todos los libros de contabilidad accesibles mediante la asignación de conjuntos de acceso a los libros de contabilidad F Plan comptable de tous les grands livres accessibles par affectation d'un ensemble d'accès aux grands livres I Piano dei conti di tutti i registri accessibili tramite l'assegnazione del set di accesso ai registri JA 元帳アクセスセットの割り当てでアクセス可能なすべての元帳の勘定科目一覧表 KO 원장 액세스 세트 할당으로 액세스 할 수있는 모든 원장의 계정과 목표 PTB Plano de contas de todos os ledgers acessíveis por atribuição de conjunto de acesso ao ledger RU План счетов всех бухгалтерских книг, доступных по назначению наборов доступа к бухгалтерским книгам S Kontoplan för alla reskontrar som är tillgängliga genom tilldelning av reservertillgång TR Defter erişim seti ataması ile erişilebilen tüm defterlerin hesap planı US Chart of accounts of all ledgers accessible by ledger access set assignment ZHS 通过分类账访问集分配可进入的所有分类账的账目表。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 8D31645BC0A6A9FFE0535754720ADF26 select gl.name ledger, gst.template_name, gst.description, &segment_columns gst.concatenated_description, gst.start_actuals_period_name earliest_period, xxen_util.meaning(gst.status,'SUMMARY_STATUS',101) status, xxen_util.user_name(gst.created_by) created_by, gst.creation_date, xxen_util.user_name(gst.last_updated_by) last_updated_by, gst.last_update_date, gst.template_id from gl_ledgers gl, gl_summary_templates gst where 1=1 and gl.ledger_id=gst.ledger_id order by gl.name, gst.template_name Y US GL Summary Templates Master data report showing GL summary and concatenation templates based on ledger, company, department, account, sub-account, and product segments, and including information for the group, ledger set, ledger, ledger category, currency and chart of accounts. Enginatics &segment_columns 1=1 1 10 &segment_columns select 'gst.'||lower(fifsv.application_column_name)||'_type "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num LOV GL Chart of Accounts 8E2FF36EDEE379D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) order by fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) F Plan comptable US Chart of Accounts 2 1=1 gl.chart_of_accounts_id=(select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts) F Plan comptable US Chart of Accounts 3 20 1=1 nvl(gst.segment1_type,'D') in ('D','T') and nvl(gst.segment2_type,'D') in ('D','T') and nvl(gst.segment3_type,'D') in ('D','T') and nvl(gst.segment4_type,'D') in ('D','T') and nvl(gst.segment5_type,'D') in ('D','T') and nvl(gst.segment6_type,'D') in ('D','T') and nvl(gst.segment7_type,'D') in ('D','T') and nvl(gst.segment8_type,'D') in ('D','T') and nvl(gst.segment9_type,'D') in ('D','T') and nvl(gst.segment10_type,'D') in ('D','T') and nvl(gst.segment11_type,'D') in ('D','T') and nvl(gst.segment12_type,'D') in ('D','T') and nvl(gst.segment13_type,'D') in ('D','T') and nvl(gst.segment14_type,'D') in ('D','T') and nvl(gst.segment15_type,'D') in ('D','T') and nvl(gst.segment16_type,'D') in ('D','T') and nvl(gst.segment17_type,'D') in ('D','T') and nvl(gst.segment18_type,'D') in ('D','T') and nvl(gst.segment19_type,'D') in ('D','T') and nvl(gst.segment20_type,'D') in ('D','T') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Non Rollup Group Only