Search Results igi_itr_charge_headers_v




Overview
Explore in AI Chat

Overview

IGI_ITR_CHARGE_HEADERS_V is a PL/SQL view owned by the APPS schema within the IGI – Public Sector Financials International product family. It presents a denormalized, reporting-friendly projection of intergovernmental transfer (ITR) charge header records held in IGI_ITR_CHARGE_HEADERS, enriching each row with translated lookup meanings, user names, and journal category descriptions. Because the base transactional table stores only encoded identifiers (lookup codes, user IDs, and category names), the view resolves those codes into human-readable values, making it suitable for concurrent program reports, Oracle Forms LOVs, and external integration extracts without requiring downstream joins.

The object was validated as VALID under ETRM 12.2.2 metadata and exists in the same form in 12.1.1. The user search term "it_source" corresponds directly to the IT_SOURCE column exposed by this view, which indicates the originating channel or reference for the charge header and is frequently used as a filtering predicate in reporting queries.

Underlying Base Objects

The view is defined over four documented referenced objects:

All four joins are inner joins, so a header row will not appear unless a matching lookup, user, and language-specific journal category exist. This is an important consideration when reconciling record counts against the base table.

Key Columns

Common Use Cases and Queries

The view is typically used to list or extract charge headers for review, to drive report parameters, or to filter records by source. To retrieve all headers originating from a specific IT_SOURCE:

SELECT it_header_id, name, it_source, submit_desc, originator_name,
  it_period_name, currency_code, entered_dr, entered_cred
  FROM apps.igi_itr_charge_headers_v
  WHERE it_source = :p_source
  ORDER BY gl_date DESC;

To review pending submissions by period:

SELECT it_header_id, name, submit_desc, it_category, category_display
  FROM apps.igi_itr_charge_headers_v
  WHERE submit_flag = 'N'
  AND it_period_name = :p_period;

Because language translation is applied through USERENV('LANG'), query results reflect the session language. Analysts should also remember that the inner joins to IGI_LOOKUPS, FND_USER, and GL_JE_CATEGORIES_TL may omit orphaned headers from the result set, so any reconciliation to IGI_ITR_CHARGE_HEADERS must account for those unmatched rows.