Search Results igc_cbcjeb




Overview
Explore in AI Chat

Overview

APPS.IGCBV_CBC_MC_JOURNAL_LINES is a read-only Oracle EBS view belonging to the Intercompany (IGC) subsystem, specifically the Cash Balancing and Cash Balancing Multi-Currency (CBC) feature area. It exposes journal line detail for multi-currency cash balancing journal entries, joining each line to its parent journal batch and to the reporting set of books defined in General Ledger. The view is defined WITH READ ONLY, confirming that it is intended strictly for query and reporting consumption rather than for DML.

The user's search term "igc_cbcjeb" corresponds to the alias assigned to the base object IGC_CBC_JE_BATCHES within the view text, which is the source of the BATCH_NAME column. This view therefore serves as a flattened, report-friendly projection across the CBC journal batch, journal line, and multi-currency line tables, allowing developers and analysts to retrieve journal line amounts in both entered and reporting currencies without navigating the underlying normalized table structure.

Underlying Base Objects

The view is defined over four referenced objects, three of which are synonyms and one a view:

The join relationships are therefore keyed on journal line number, journal batch identifier, and reporting set of books identifier. All three joins are equijoins, and the view applies no additional filter predicates, so it returns every multi-currency CBC journal line that resolves to a valid batch and set of books.

Key Columns

Common Use Cases and Queries

Typical uses include reconciliation of intercompany cash balancing entries across sets of books, verification of conversion rates and dates applied to multi-currency journal lines, and extraction of journal activity for reporting or audit purposes.

To retrieve all lines for a specific batch name:

  • SELECT batch_name, journal_line_number, entered_dr, entered_credit FROM apps.igcbv_cbc_mc_journal_lines WHERE batch_name = :p_batch_name ORDER BY journal_line_number;

To summarize entered amounts by set of books and currency:

  • SELECT sets_of_books_short_name, currency_code, SUM(entered_dr) total_dr, SUM(entered_cr) total_cr FROM apps.igcbv_cbc_mc_journal_lines GROUP BY sets_of_books_short_name, currency_code;

To inspect conversion detail for a given conversion type:

  • SELECT batch_id, journal_line_number, currency_conversion_type, currency_conversion_date, currency_conversion_rate FROM apps.igcbv_cbc_mc_journal_lines WHERE currency_conversion_type = :p_conv_type;

Because the view is read-only and unfiltered, queries should always be constrained by batch, set of books, or date-related columns from the underlying lines to limit result size on high-volume installations.