Search Results charge_center




Overview
Explore in AI Chat

Overview

The APPS.IGI_ITR_CHARGE_LINES_ENTRY_V view is a reporting and entry support object within the Oracle E-Business Suite (EBS) ETRM (Global Intercompany Transaction Reconciliation / Intercompany Transfer Reconciliation) product family. It presents intercompany charge line records together with their associated charge center name, providing a denormalized, presentation-ready dataset suitable for forms, concurrent programs, and ad-hoc reporting. The view is owned by APPS and is shipped as part of the ETRM schema in both 12.1.1 and 12.2.2.

The view is not a table itself; it is a join between the charge center definition and the charge lines that reference it. Its design intent is to expose charge lines in a form that includes a human-readable CHARGE_CENTER name rather than only the surrogate CHARGE_CENTER_ID, which simplifies inquiry screens and reporting queries.

Underlying Base Objects

The documented base objects referenced by the view are:

The join is an inner equijoin on CC.CHARGE_CENTER_ID = LINES.CHARGE_CENTER_ID. Consequently, charge lines that have no matching charge center definition (or a null CHARGE_CENTER_ID) will not appear in the view. Only the NAME column from IGI_ITR_CHARGE_CENTER is projected; all other columns originate from IGI_ITR_CHARGE_LINES, plus LINES.ROWID exposed as ROW_ID to provide row-level identification.

Key Columns

Common Use Cases and Queries

The most common reason to query this view is to retrieve charge lines resolved to a charge center name, particularly in the context of the charge_center search term. Practical scenarios include: reconciling charge lines by charge center, reviewing lines in a given ledger period, and inspecting lines pending posting or rejected during reconciliation.

Representative queries:

  • List all charge lines for a specific charge center name:
    SELECT it_line_num, description, entered_dr, entered_cr, status_flag
    FROM apps.igi_itr_charge_lines_entry_v
    WHERE charge_center = :charge_center_name;
  • Filter by charge center id and ledger:
    SELECT charge_center, it_line_num, suggested_amount, effective_date
    FROM apps.igi_itr_charge_lines_entry_v
    WHERE charge_center_id = :p_charge_center_id
    AND set_of_books_id = :p_set_of_books_id;
  • Review unposted or rejected lines:
    SELECT it_header_id, it_line_num, charge_center, rejection_note
    FROM apps.igi_itr_charge_lines_entry_v
    WHERE posting_flag = 'N' OR rejection_note IS NOT NULL;

Because the view performs an inner join, queries expecting charge lines without a defined charge center should instead reference IGI_ITR_CHARGE_LINES directly with an outer join to IGI_ITR_CHARGE_CENTER.