Query to GL Journal Details in Oracle Cloud

  SELECT b.name je_batch_name,

         b.description je_batch_description,

         b.running_total_accounted_dr je_batch_total_dr,

         b.running_total_accounted_cr je_batch_total_cr,

         b.status je_batch_status,

         b.default_effective_date je_batch_effective_date,

         b.default_period_name je_batch_period_name,

         b.creation_date je_batch_creation_date,

         h.je_category je_header_category,

         h.je_source je_header_source,

         h.period_name je_header_period_name,

         h.name je_header_journal_name,

         h.status je_header_journal_status,

         h.creation_date je_header_created_date,

         h.description je_header_description,

         h.running_total_accounted_dr je_header_total_acctd_dr,

         h.running_total_accounted_cr je_header_total_acctd_cr,

         l.je_line_num je_lines_line_number,

         l.ledger_id je_lines_ledger_id,

         l.entered_dr je_lines_entered_dr,

         l.entered_cr je_lines_entered_cr,

         l.accounted_dr je_lines_accounted_dr,

         l.accounted_cr je_lines_accounted_cr,

         l.description je_lines_description,

         xlal.accounting_class_code xla_lines_acct_class_code,

         xlal.accounted_dr xla_lines_accounted_dr,

         xlal.accounted_cr xla_lines_accounted_cr,

         xlal.description xla_lines_description,

         xlal.accounting_date xla_lines_accounting_date

    FROM gl_je_batches b,

         gl_je_headers h,

         gl_je_lines l,

         gl_import_references gir,

         xla_ae_lines xlal,

         xla_ae_headers xlah,

         xla_events xlae

   WHERE     b.je_batch_id = h.je_batch_id

         AND h.je_header_id = l.je_header_id

         AND l.je_header_id = gir.je_header_id

         AND l.je_line_num = gir.je_line_num

         AND gir.gl_sl_link_table = xlal.gl_sl_link_table

         AND gir.gl_sl_link_id = xlal.gl_sl_link_id

         AND xlal.application_id = xlah.application_id

         AND xlal.ae_header_id = xlah.ae_header_id

         AND xlah.application_id = xlae.application_id

         AND xlah.event_id = xlae.event_id

         AND b.default_period_name = 'FEB-19'

ORDER BY h.je_category;

Below are the descriptions of the table and to answer the question regarding CST_TRANSACTIONS.

XLA_AE_HEADERS: This table contains subledger accounting journal entries.

XLA_AE_LINES: This table contains the journal entry lines for each subledger accounting journal entry.

GL_JE_HEADERS: This table contains journal entries. There is a one-to-many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about the journal entry. This table corresponds to the Journals window of the Enter Journals form. STATUS is 'U' for unposted and 'P' for posted. CTA account failed validation b -- No write access to generated ledger account d -- No write access to reporting currency/segment e -- Invalid segment in generated ledger account h -- Invalid account in chart of accounts mapping i -- Unable to determine journal effective date.

GL_JE_LINES: This table contains the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is 'U' for unposted or 'P' for posted.

CST_TRANSACTIONS: These are costing transactions. The imported inventory transactions are converted to costing transaction type, exploded for Cost Org - Book and stamped with suitable costing setup like item cost profile, valuation unit and costing method etc.