GL_OFSAA_LEDGER_COA_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name

LEDGER_NAME SHORT_NAME CURRENCY_CODE ACCOUNTING_METHOD_NAME COA_NAME COA_ID COA_SEGMENT1_NAME COA_SEGMENT2_NAME COA_SEGMENT3_NAME COA_SEGMENT4_NAME COA_SEGMENT5_NAME COA_SEGMENT6_NAME COA_SEGMENT7_NAME COA_SEGMENT8_NAME COA_SEGMENT9_NAME COA_SEGMENT10_NAME COA_SEGMENT11_NAME COA_SEGMENT12_NAME COA_SEGMENT13_NAME COA_SEGMENT14_NAME COA_SEGMENT15_NAME COA_SEGMENT16_NAME COA_SEGMENT17_NAME COA_SEGMENT18_NAME COA_SEGMENT19_NAME COA_SEGMENT20_NAME COA_SEGMENT21_NAME COA_SEGMENT22_NAME COA_SEGMENT23_NAME COA_SEGMENT24_NAME COA_SEGMENT25_NAME COA_SEGMENT26_NAME COA_SEGMENT27_NAME COA_SEGMENT28_NAME COA_SEGMENT29_NAME COA_SEGMENT30_NAME

Query

SQL_Statement

select l.name ledger_name, l.short_name short_name, l.currency_code currency_code, m.name accounting_method_name, f.name coa_name, l.chart_of_accounts_id coa_id, max(decode(b.column_name, 'SEGMENT1', segment_code)) coa_segment1_name, max(decode(b.column_name, 'SEGMENT2', segment_code)) coa_segment2_name, max(decode(b.column_name, 'SEGMENT3', segment_code)) coa_segment3_name, max(decode(b.column_name, 'SEGMENT4', segment_code)) coa_segment4_name, max(decode(b.column_name, 'SEGMENT5', segment_code)) coa_segment5_name, max(decode(b.column_name, 'SEGMENT6', segment_code)) coa_segment6_name, max(decode(b.column_name, 'SEGMENT7', segment_code)) coa_segment7_name, max(decode(b.column_name, 'SEGMENT8', segment_code)) coa_segment8_name, max(decode(b.column_name, 'SEGMENT9', segment_code)) coa_segment9_name, max(decode(b.column_name, 'SEGMENT10', segment_code)) coa_segment10_name, max(decode(b.column_name, 'SEGMENT11', segment_code)) coa_segment11_name, max(decode(b.column_name, 'SEGMENT12', segment_code)) coa_segment12_name, max(decode(b.column_name, 'SEGMENT13', segment_code)) coa_segment13_name, max(decode(b.column_name, 'SEGMENT14', segment_code)) coa_segment14_name, max(decode(b.column_name, 'SEGMENT15', segment_code)) coa_segment15_name, max(decode(b.column_name, 'SEGMENT16', segment_code)) coa_segment16_name, max(decode(b.column_name, 'SEGMENT17', segment_code)) coa_segment17_name, max(decode(b.column_name, 'SEGMENT18', segment_code)) coa_segment18_name, max(decode(b.column_name, 'SEGMENT19', segment_code)) coa_segment19_name, max(decode(b.column_name, 'SEGMENT20', segment_code)) coa_segment20_name, max(decode(b.column_name, 'SEGMENT21', segment_code)) coa_segment21_name, max(decode(b.column_name, 'SEGMENT22', segment_code)) coa_segment22_name, max(decode(b.column_name, 'SEGMENT23', segment_code)) coa_segment23_name, max(decode(b.column_name, 'SEGMENT24', segment_code)) coa_segment24_name, max(decode(b.column_name, 'SEGMENT25', segment_code)) coa_segment25_name, max(decode(b.column_name, 'SEGMENT26', segment_code)) coa_segment26_name, max(decode(b.column_name, 'SEGMENT27', segment_code)) coa_segment27_name, max(decode(b.column_name, 'SEGMENT28', segment_code)) coa_segment28_name, max(decode(b.column_name, 'SEGMENT29', segment_code)) coa_segment29_name, max(decode(b.column_name, 'SEGMENT30', segment_code)) coa_segment30_name from gl_ledgers l, xla_acctg_methods_vl m, fnd_kf_str_instances_vl f, fnd_kf_segments_b b where m.accounting_method_type_code = l.sla_accounting_method_type and m.accounting_method_code = l.sla_accounting_method_code and f.application_id = 101 and f.key_flexfield_code = 'GL#' and f.structure_instance_number = l.chart_of_accounts_id and f.structure_id = b.structure_id group by l.name, l.short_name, l.currency_code, m.name, f.name, l.chart_of_accounts_id