Search Results igi_rpi_items




Overview
Explore in AI Chat

Overview

APPS.IGI_RPI_ITEMS_V is a reporting and integration view within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema. The view consolidates item-level price and tax configuration data used by the Oracle Retail/Public Sector/Projects-related pricing item functionality (historical IGI — Oracle Public Sector Financials / Grants-related and Retail Price Item lineage). Its primary purpose is to expose pricing item records alongside their associated tax rate code, allowing tax and price information to be retrieved in a single query rather than requiring separate joins against tax and pricing item tables.

The view is a denormalizing construct: it joins stored item pricing records with tax rate definitions so that consumers (reports, concurrent programs, or integration interfaces) do not need to resolve the tax rate relationship themselves. Because it is an APPS-owned synonym-based object, it is typically consumed through the APPS schema rather than accessed directly at the underlying table level.

Underlying Base Objects

According to the documented ETRM metadata (12.2.2), the view is defined over two referenced base objects, both exposed to the view as synonyms:

  • IGI_RPI_ITEMS (SYNONYM) — the driving table supplying the item-level attributes (pricing items, effective dates, price amounts, revenue account, VAT tax reference, and organization).
  • ZX_RATES_B (SYNONYM) — the EBS tax rates base table, supplying the tax rate code associated with the item's VAT tax identifier.

The join is an outer join (indicated by the (+) operator on ZSV.TAX_RATE_ID), meaning items are returned regardless of whether a matching tax rate exists. The join condition is ZX_RATES_B.TAX_RATE_ID = IGI_RPI_ITEMS.VAT_TAX_ID. This design ensures items without a configured tax rate are still reported, with a null tax rate code.

Key Columns

The view exposes the full column list of IGI_RPI_ITEMS plus one column (TAX_RATE_CODE) from ZX_RATES_B. Notable columns include:

Common Use Cases and Queries

The view is commonly used to report current pricing items with their tax treatment, to validate that items have valid tax rate assignments, and as a source for integration extracts. A representative query listing enabled items for a given operating unit is shown below.

  • Price validation and listing: retrieve items with price and tax rate code.
  • Tax exception reporting: identify items where TAX_RATE_CODE is null (no matching tax rate).
  • Effective-dated extracts: filter by effective dates for point-in-time pricing snapshots.

Sample SQL:

SELECT item_code, description, price, unit_of_measure, tax_rate_code
FROM apps.igi_rpi_items_v
WHERE org_id = :p_org_id
  AND enabled_flag = 'Y'
  AND (inactive_date IS NULL OR inactive_date > SYSDATE);

A second pattern targets tax gaps:

SELECT item_code, vat_tax_id
FROM apps.igi_rpi_items_v
WHERE tax_rate_code IS NULL;

Because the tax join is an outer join, null tax rate codes indicate items whose VAT_TAX_ID does not resolve to an enabled ZX_RATES_B row, which is a frequent data-quality check.