Search Results igwfv_grant_prpsl_bdgt_version

Overview

IGWFV_GRANT_PRPSL_BDGT_VERSION is a read-only view owned by the APPS schema within the Oracle E-Business Suite Grants Proposal (IGW) module. It presents proposal budget version information for grant proposals, consolidating header-level budget figures, proposal identifiers, and rate class descriptions into a single reporting surface. The view is defined with a WITH READ ONLY clause, confirming that it is intended purely for query and reporting purposes rather than for transactional data manipulation. In Oracle EBS 12.1.1 and 12.2.2, objects of this type serve as the primary access layer for Oracle Grants Management reporting, form-based inquiry, and downstream integration. Because it joins budget records to their parent proposal and to the overhead rate class, it allows users to retrieve a complete budget version snapshot without writing multi-table joins directly against the base tables.

Underlying Base Objects

The view is defined over three documented base objects:

• IGW_BUDGETS (aliased BUDGETS) — the primary source of budget version data, supplying version identifiers, dates, cost totals, cost sharing, and rate class references.
• IGW_PROPOSALS_ALL (aliased PR) — supplies the parent proposal, including PROPOSAL_ID and PROPOSAL_NUMBER, joined on PROPOSAL_ID.
• IGW_RATE_CLASSES (aliased OH) — supplies the rate class description (OH.DESCRIPTION), joined on OH_RATE_CLASS_ID.

The join predicates are straightforward: PR.PROPOSAL_ID = BUDGETS.PROPOSAL_ID and BUDGETS.OH_RATE_CLASS_ID = OH.RATE_CLASS_ID. The relationship is therefore one row per budget version, enriched with its proposal and rate class context. The view also embeds two descriptive flexfield/lookup tokens — _LA:BUDGET_TYPE (resolved through IGW_LOOKUPS_V and the IGW_BUDGET_TYPES lookup) and _DF (the IGW_BUDGETS_DESC_FLEX descriptive flexfield) — which the EBS framework interprets at runtime to render lookup meanings and flexfield segments.

Key Columns

• PROPOSAL_NUMBER / PROPOSAL_ID — human-readable and surrogate identifiers of the parent proposal.
• BUDGET_VERSION_ID (VERSION_ID) — the unique budget version identifier for the proposal.
• START_DATE / END_DATE — the effective date range of the budget version.
• TOTAL_COST, TOTAL_DIRECT_COST, TOTAL_INDIRECT_COST — aggregate budget cost figures.
• COST_SHARING_AMOUNT, UNDERRECOVERY_AMOUNT, RESIDUAL_FUNDS_AMOUNT, TOTAL_COST_LIMIT — financial control and cost-sharing metrics.
• FINAL_VERSION_FLAG — indicates whether the version is the final approved budget version.
• _LA:BUDGET_TYPE — the budget type (e.g., proposed, awarded) resolved to its lookup meaning.
• RATE_CLASS_DESCRIPTION / OH_RATE_CLASS_ID — overhead rate class context.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include budget version reporting, cost comparison across versions, and integration feeds into financial or reporting systems. A representative query retrieves the final budget version for a given proposal:

SELECT proposal_number,
       budget_version_id,
       start_date,
       end_date,
       total_cost,
       total_indirect_cost,
       "_LA:BUDGET_TYPE" AS budget_type
FROM   apps.igwfv_grant_prpsl_bdgt_version
WHERE  final_version_flag = 'Y'
AND    proposal_number = :p_proposal_number;

Analysts also use the view to reconcile direct, indirect, and cost-sharing amounts per rate class, or to list all non-final versions during budget preparation. Because it is read-only, all access is limited to SELECT statements, making it safe for concurrent reporting workloads.