Search Results igf_aw_fed_fund




Overview
Explore in AI Chat

Overview

IGF_AW_REPKG_PRTY_V is a reporting view in the Oracle E-Business Suite (EBS) Grants Management module, owned by the APPS schema. It exposes the data held in the IGF_AW_REPKG_PRTY base table — the "Award Re-Packaging Priority" entity — in a denormalized, human-readable form. The base table stores fund allocation priority rules as numeric lookup codes; the view joins those codes to the IGF_LOOKUPS_VIEW to resolve each code into its displayable meaning. This makes the view suitable for direct consumption by reports, concurrent programs, OAF pages, and downstream integrations without the caller having to re-implement the lookup joins.

The view is relevant to the search term "igf_aw_fed_fund" because one of its three lookup joins is driven specifically by the lookup type IGF_AW_FED_FUND. This lookup type is the federal fund classification used by Grants Management to distinguish funding strings derived from the federal award structure. The view therefore serves as the primary read interface for re-packaging priority records together with their federal fund designation.

Underlying Base Objects

The view is defined over four objects. The driving table is IGF_AW_REPKG_PRTY, referenced with the alias RPP. It supplies the priority record itself, identified by ROWID, along with the fund order number and the three lookup codes. The remaining three objects are all instances of IGF_LOOKUPS_VIEW, aliased FNDS1, FNDS2, and FNDS3, and are joined to resolve each code to its meaning. No other base tables are documented in the ETRM metadata, and the view text is a single flat SELECT with an inner join in the WHERE clause rather than an ANSI join syntax.

Because all three lookup joins are expressed as equality predicates in the WHERE clause with no outer-join operator, the view behaves as an inner join throughout. A re-packaging priority row will only appear in the result set if all three of its lookup codes are valid, enabled lookup codes in their respective lookup types. Rows whose SYS_FUND_TYPE_CODE, FUND_SOURCE_CODE, or SYS_FUND_CODE is null or obsolete will be silently excluded. This is an important behavioral characteristic for anyone diagnosing apparent missing records.

Key Columns

Common Use Cases and Queries

The view is typically used to display or report the configured fund priority hierarchy for an award, to verify that federal fund designations have been correctly mapped, or to feed external budget and drawdown processes that require readable fund descriptions rather than raw codes. A representative query returning the full priority list ordered by sequence is:

  • SELECT fund_order_num, sys_fund_type_desc, fund_source_desc, sys_fund_code_desc FROM apps.igf_aw_repkg_prty_v ORDER BY fund_order_num;

To isolate only the federal fund dimension, filter on the federal fund description:

  • SELECT fund_order_num, sys_fund_code, sys_fund_code_desc FROM apps.igf_aw_repkg_prty_v WHERE sys_fund_code_desc IS NOT NULL ORDER BY fund_order_num;

Because the view exposes ROWID and the WHO columns, it can also be used as the basis for a modifiable framework region, although the three inner lookup joins mean any code value must exist in its lookup type before the record becomes visible. When troubleshooting discrepancies between the base table and the view, query IGF_AW_REPKG_PRTY directly and compare the code values against the IGF_AW_SYS_FUND_TYPE, IGF_AW_FUND_SOURCE, and IGF_AW_FED_FUND lookup types to identify the missing or disabled code responsible for the row's exclusion.