ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C319C51DEFDEFFDAE0530100007F6B19 select gl.name ledger, xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101) ledger_category, xtdv.definition_code, xtdv.name, xtdv.description, xtdjs.je_source_name journal_source, xxen_util.meaning(xtdv.enabled_flag,'XLA_YES_NO',602) enabled, xxen_util.meaning(xtdv.balance_side_code,'XLA_ACCT_NATURAL_SIDE',602) balance_side_code, xxen_util.meaning(xtdv.defined_by_code,'XLA_TB_DEFINED_BY',602) defined_by_code, xtdv.definition_status_code, initcap(xtdv.definition_status_code) definition_status, xxen_util.meaning(xtdv.owner_code,'XLA_OWNER_TYPE',602) owner, xtdd.flexfield_segment_code, xtdd.segment_value_from, xtdd.segment_value_to, gcck.concatenated_segments account, fifsv.id_flex_structure_name chart_of_accounts, (select distinct listagg(fifsv.form_left_prompt,'.') within group (order by fifsv.segment_num) over (partition by xtdv.definition_code,fifsv.id_flex_num) gl_account_segments from fnd_id_flex_segments_vl fifsv where fifsv.application_id = 101 and fifsv.id_flex_code = 'GL#' and fifsv.id_flex_num = gl.chart_of_accounts_id ) gl_segment_names, (select distinct listagg(fifsv.application_column_name,'.') within group (order by fifsv.segment_num) over (partition by xtdv.definition_code,fifsv.id_flex_num) gl_account_segments from fnd_id_flex_segments_vl fifsv where fifsv.application_id = 101 and fifsv.id_flex_code = 'GL#' and fifsv.id_flex_num = gl.chart_of_accounts_id ) gl_segment_columns, gl.chart_of_accounts_id, xtdv.ledger_id from xla_tb_definitions_vl xtdv, xla_tb_defn_je_sources xtdjs, gl_ledgers gl, xla_tb_defn_details xtdd, fnd_id_flex_structures_vl fifsv, gl_code_combinations_kfv gcck where xtdjs.definition_code (+) = xtdv.definition_code and xtdd.definition_code (+) = xtdv.definition_code and gl.ledger_id (+) = xtdv.ledger_id and fifsv.application_id (+) = 101 and fifsv.id_flex_code (+) = 'GL#' and fifsv.id_flex_num (+) = gl.chart_of_accounts_id and gcck.code_combination_id (+) = xtdd.code_combination_id and 1=1 order by gl.name, xtdv.definition_code Y SQLAP US AP Trial Balance Report Definitions Accounts Payable Trial Balance Report Definitions Enginatics R12 only 1=1 1 -70 1=1 :p_application_id=:p_application_id LOV Oracle XLA_SRS_SUBLEDGERS Y select application_id id, application_name value, null description from (select application_name,application_id from xla_subledgers_fvl union select application_name,application_id from fnd_application_vl where application_id=101) order by value,description nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID) US XLA_SRS_SUBLEDGERS 2 20 1=1 xtdv.definition_code=:p_definition_code LOV Oracle XLA_SRS_TB_DEFINITIONS_ALL Y select definition_code id, name value, description description from xla_tb_definitions_vl where enabled_flag='Y' and ( definition_code in ( select xtd.definition_code from xla_tb_defn_je_sources xtd ,xla_subledgers xs where xtd.je_source_name=xs.je_source_name and xs.application_id=:$flex$.xla_srs_subledgers ) or decode(:$flex$.xla_srs_subledgers,101,'GL','OTHERS')='GL' ) and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists ( select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and asa.ledger_id=xla_tb_definitions_vl.ledger_id and (gas.access_set_id= nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id= nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'), '-1'))))) order by value,description AR تعريف التقرير D Auswertungsdefinition F Définition du rapport US Report Definition ZHS 报表定义 :$flex$.xla_srs_subledgers XLA_SRS_SUBLEDGERS Report Definition