Tech Trainings

Oracle Fusion General Ledger GL Extract From Base Tables

November 30, 2022 by admin

SELECT
    gl.name                                           ledger_name,
    to_char(gjh.default_effective_date, 'YYYY/MM/DD') effective_date_of_transaction,
    gjs.user_je_source_name                           je_source,
    gjc.user_je_category_name                         je_category,
    gjh.currency_code                                 currency_code,
    to_char(gjh.default_effective_date, 'YYYY/MM/DD') journal_entry_creation_date    ,
    gjh.actual_flag                                   actual_flag,
    gcc.segment1,
    gcc.segment2,
    gcc.segment3,
    gcc.segment4,
    gcc.segment5,
    gcc.segment6,
    gcc.segment7,
    gcc.segment8,
    gcc.segment9,
    gcc.segment10,
    gjl.entered_dr                                    entered_debit_amount,
    gjl.entered_cr                                    entered_credit_amount,
    gjl.accounted_dr                                  converted_debit_amount,
    gjl.accounted_cr                                  converted_credit_amount,
    gjb.name                                          batch_name,
    gjh.description,
    gjl.stat_amount                                   statistical_amount,
    gjh.currency_conversion_date                      currency_conversion_date    ,
    gjl.je_line_num                                   gl_line_num,
    gjh.status,
    gjb.created_by,
    gjb.creation_date
FROM
    gl_je_lines          gjl,
    gl_je_headers        gjh,
    gl_je_batches        gjb,
    gl_code_combinations gcc,
    gl_ledgers           gl,
    gl_je_sources        gjs,
    gl_je_categories     gjc
WHERE
        1 = 1
    AND gjb.je_batch_id = gjh.je_batch_id
    AND gjl.je_header_id = gjh.je_header_id
    AND gjh.je_batch_id = gjb.je_batch_id
    AND gjl.code_combination_id = gcc.code_combination_id
    AND gjh.ledger_id = gl.ledger_id
    AND gjh.je_source = gjs.je_source_name
    AND gjh.je_category = gjc.je_category_name

Comments |0|