Search Results line_item_description




Overview
Explore in AI Chat

Overview

The view APPS.IGW_BUDGET_DETAILS_V is a reporting and integration access point for budget line-item data maintained within the Oracle E-Business Suite Grants and Proposals (IGW) schema. It exposes the detail records that describe individual budget lines associated with a proposal version, budget period, and line item, providing budget category classification, cost components, cost-sharing, underrecovery, and inflation treatment. In the context of EBS 12.1.1 and 12.2.2, this view serves as the primary read interface through which budget detail information is surfaced for inquiry, reporting, and downstream downstream processing of proposal budgets, including integration into project and award costing structures.

The view is particularly relevant to users searching for the APPLY_INFLATION_FLAG attribute, since that column is one of the key budget-line attributes exposed. The flag indicates whether inflation escalation is applied to the line item during budget calculation, and it is used in conjunction with the line item cost and related amount columns to determine the escalated versus base budget value.

Underlying Base Objects

Per the documented metadata, the view is defined over a single base object: the table IGW_BUDGET_DETAILS. The view is a direct projection, selecting all listed columns from that table without documented joins, aggregations, or filters to additional objects. No other referenced base objects are documented for this view in the ETRM 12.2.2 metadata.

Because the view selects directly from IGW_BUDGET_DETAILS without a restricting WHERE clause, it returns the same row population as the underlying table. This makes the view row-equivalent to the base table at the detail level, with the view serving as a stable, named interface over the physical table. Applications and reports that consume this view therefore inherit the full detail set of budget lines recorded for each proposal version and budget period.

Key Columns

Common Use Cases and Queries

Typical uses include retrieving budget details for a proposal version, analyzing inflation-applied lines, and reconciling cost-sharing and underrecovery amounts. A representative query filters by proposal and version and inspects the inflation flag:

  • SELECT proposal_id, version_id, line_item_id, expenditure_type, line_item_cost, apply_inflation_flag FROM apps.igw_budget_details_v WHERE proposal_id = :p_proposal_id AND version_id = :p_version_id;
  • SELECT line_item_id, line_item_cost, apply_inflation_flag FROM apps.igw_budget_details_v WHERE apply_inflation_flag = 'Y' AND budget_period_id = :p_period_id;
  • SELECT project_id, task_id, award_id, SUM(line_item_cost) FROM apps.igw_budget_details_v GROUP BY project_id, task_id, award_id;

These queries support budget review, inflation impact analysis, and integration of budget line data into project costing and award management processes.