Search Results igw_oh_temp_v




Overview
Explore in AI Chat

Overview

The IGW_OH_TEMP_V view is a reporting object within the Oracle E-Business Suite Grants Proposal (IGW) module. It presents aggregated overhead amounts calculated for grant proposal budget lines and organizes them by proposal, budget version, budget period, and rate class. The view functions as a read-only consolidation layer that allows organizations to review the indirect cost burden applied to sponsored project budgets without navigating the normalized transaction tables that hold individual calculation details.

In the EBS 12.1.1 and 12.2.2 releases, IGW forms part of the Oracle Grants Accounting and Proposal family used by research institutions, universities, and other sponsored-program offices. The view is owned by the APPS schema and carries a VALID status, indicating it compiles correctly and is available for use in custom reports, views, and extracts. Because it performs aggregation at the database level, it is well suited for inquiry screens, budget review reports, and integration extracts that must summarize overhead by rate classification.

Underlying Base Objects

The view is defined over three base objects that supply the calculation amounts, rate type definitions, and rate class descriptions:

  • IGW_BUDGET_DETAILS_CAL_AMTS — stores the calculated cost amounts for budget detail lines, keyed by rate class and rate type.
  • IGW_RATE_TYPES — defines the rate types associated with each rate class, forming the join between calculated amounts and their rate classification.
  • IGW_RATE_CLASSES — provides the rate class identifier and its descriptive text.

The defining SQL joins IGW_BUDGET_DETAILS_CAL_AMTS to IGW_RATE_TYPES on both RATE_CLASS_ID and RATE_TYPE_ID, and then joins IGW_RATE_TYPES to IGW_RATE_CLASSES on RATE_CLASS_ID. The result set is grouped by PROPOSAL_ID, VERSION_ID, BUDGET_PERIOD_ID, RATE_CLASS_ID, and the rate class DESCRIPTION, with SUM(CALCULATED_COST) producing the aggregated overhead figure. This design means each row represents one rate class within one budget period of one proposal version, rather than an individual calculation line.

Key Columns

The view exposes six columns:

  • PROPOSAL_ID — identifier of the grant proposal to which the overhead amounts belong.
  • VERSION_ID — the budget version under which the amounts were calculated, allowing comparison across revisions.
  • BUDGET_PERIOD_ID — the budget period (for example, a project year) that the overhead applies to.
  • CALCULATED_COST — the summed overhead amount for the rate class within the period.
  • RATE_CLASS_ID — identifier of the rate class used to categorize the overhead.
  • DESCRIPTION — descriptive name of the rate class, sourced from IGW_RATE_CLASSES.

Common Use Cases and Queries

Typical uses include budget-versus-actual overhead analysis, rate class breakdowns for proposal review, and extract feeds into institutional reporting warehouses. A representative query listing total overhead by rate class for a proposal and version is:

SELECT RATE_CLASS_ID, DESCRIPTION, SUM(CALCULATED_COST) OVERHEAD
FROM APPS.IGW_OH_TEMP_V
WHERE PROPOSAL_ID = :proposal_id
AND VERSION_ID = :version_id
GROUP BY RATE_CLASS_ID, DESCRIPTION;

A period-level inquiry retrieves overhead by budget period:

SELECT BUDGET_PERIOD_ID, RATE_CLASS_ID, DESCRIPTION, CALCULATED_COST
FROM APPS.IGW_OH_TEMP_V
WHERE PROPOSAL_ID = :proposal_id
ORDER BY BUDGET_PERIOD_ID, RATE_CLASS_ID;

Because the view is owned by APPS and performs joins and aggregation internally, it should be queried through a synonym or fully qualified name rather than modified. It is not documented as maintaining a materialized copy, so results reflect current data in the underlying IGW budget tables at query time.