Search Results final_version_flag




Overview
Explore in AI Chat

Overview

APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite. It is part of the Oracle Grants Management (IGW/IGWF) product family, which supports the capture, budgeting, and costing of sponsored research and grant proposals. The view presents a denormalized, report-oriented projection of grant proposal budget version data, joining proposal header information to budget version records and rate class definitions. Its FND Design Data registration is IGW.IGWFV_GRANT_PRPSL_BDGT_VERSION, and the object carries a VALID status in the documented releases (12.1.1 and 12.2.2).

The view is designed primarily for downstream reporting, analytics, and integration rather than for transactional data entry. Because it exposes budget totals, cost-sharing figures, and the FINAL_VERSION_FLAG indicator alongside descriptive proposal attributes, it is well suited to reporting on which budget version of a proposal represents the approved or definitive submission, and to comparing multiple budget iterations for the same proposal.

Underlying Base Objects

The documented dependencies for this view are:

  • IGW_BUDGETS — stores the budget version records that supply budget identity, dates, and monetary amounts.
  • IGW_PROPOSALS_ALL — the proposal master table, supplying the proposal number and proposal ID context.
  • IGW_RATE_CLASSES — provides rate class definitions, surfaced through the rate class description and identifier columns.

The view is not referenced by any other database object, confirming its role as a terminal reporting object. It therefore inherits data integrity from the underlying IGW tables, and any changes to those base tables are reflected directly through the view without intermediate caching.

Key Columns

The view exposes columns spanning proposal identification, budget version specifics, and financial aggregates.

The _LA:BUDGET_TYPE and _DF columns are Flexfield-related descriptive columns generated from the underlying descriptive flexfield and key flexfield definitions, respectively.

Common Use Cases and Queries

The most common scenario is retrieving the current or final budget version for a proposal. A typical query filters on FINAL_VERSION_FLAG to isolate the approved version, and aggregates or compares against prior versions.

Example — retrieve the final version of each proposal:

  • SELECT PROPOSAL_NUMBER, BUDGET_VERSION_ID, TOTAL_COST, TOTAL_INDIRECT_COST, START_DATE, END_DATE FROM APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION WHERE FINAL_VERSION_FLAG = 'Y';

Example — list all versions for a specific proposal to compare totals:

  • SELECT BUDGET_VERSION_ID, FINAL_VERSION_FLAG, TOTAL_COST, TOTAL_DIRECT_COST, TOTAL_INDIRECT_COST FROM APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION WHERE PROPOSAL_NUMBER = :proposal_number ORDER BY BUDGET_VERSION_ID;

Example — summarize cost sharing across final versions of all proposals:

  • SELECT PROPOSAL_NUMBER, TOTAL_COST, COST_SHARING_AMOUNT, UNDERRECOVERY_AMOUNT FROM APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION WHERE FINAL_VERSION_FLAG = 'Y';

Because the view is registered as BIS, it can be consumed by Oracle Business Intelligence, Discoverer, and custom concurrent programs. It should not be used for transactional updates; all modifications must be performed through the underlying IGW budget maintenance forms and APIs.