select
to_char(null) action_,
to_char(null) status_,
to_char(null) message_,
to_char(null) ledger,
gcck.concatenated_segments,
ffvv.description account_type,
xxen_util.meaning(gcck.summary_flag,'YES_NO',0) summary,
--fifs.id_flex_structure_name chart_of_accounts_name,
xxen_util.meaning(gcck.enabled_flag,'YES_NO',0) enabled,
gcck.start_date_active,
gcck.end_date_active,
xxen_util.meaning(gcck.detail_budgeting_allowed,'YES_NO',0) detail_budgeting_allowed,
xxen_util.meaning(gcck.detail_posting_allowed,'YES_NO',0) detail_posting_allowed,
gcck.code_combination_id,
--gccka.concatenated_segments alternate_account,
--gcck.igi_balanced_budget_flag balanced_budget,
gcck.segment1 gl_segment1,
gcck.segment2 gl_segment2,
gcck.segment3 gl_segment3,
gcck.segment4 gl_segment4,
gcck.segment5 gl_segment5,
gcck.segment6 gl_segment6,
gcck.segment7 gl_segment7,
gcck.segment8 gl_segment8,
gcck.segment9 gl_segment9,
gcck.segment10 gl_segment10
from
gl_code_combinations_kfv gcck,
gl_code_combinations_kfv gccka,
fnd_flex_values_vl ffvv,
fnd_flex_value_sets ffvs,
fnd_id_flex_structures_tl fifs,
gl_ledgers gl
where
1=1 and
gl.chart_of_accounts_id=gcck.chart_of_accounts_id and
gcck.gl_account_type=ffvv.flex_value and
ffvv.flex_value_set_id=ffvs.flex_value_set_id and
ffvs.flex_value_set_name='GL_SRS_ACCOUNT_TYPE' and
gcck.alternate_code_combination_id=gccka.code_combination_id(+) and
fifs.id_flex_num =gcck.chart_of_accounts_id and
fifs.application_id = 101 and
fifs.id_flex_code = 'GL#' and
fifs.language = userenv ('LANG')
¬_use_first_block
&report_table_select &report_table_name &report_table_where_clause &success_records
&processed_run |