Oracle Fusion General Ledger GL Extract From Base Tables
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|
Category: OracleSaaS