Search Results igf_aw_fn_rpkg_prty_v




Overview
Explore in AI Chat

Overview

IGF_AW_FN_RPKG_PRTY_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Financial Aid (IGF) module. In the context of EBS 12.1.1 and 12.2.2, the view exposes the configuration that governs the re-packaging priority of financial aid funds at the fund level. Re-packaging controls the sequence in which awarded funds are redistributed or reallocated against a student's outstanding need when an award package is recalculated, so the priority order recorded here directly influences automated packaging outcomes. The view denormalizes the underlying priority records into a human-readable form by resolving the fund code, fund description, and the various lookup meanings that describe the fund. It is read-only reference data and is typically consumed by reporting tools, concurrent programs, and integration interfaces that need to display or validate fund ordering without joining the transactional priority table to multiple lookup and calendar structures.

Underlying Base Objects

The view is defined over five referenced objects. The driving table is IGF_AW_FN_RPKG_PRTY (aliased RPP), which stores the fund-level re-packaging priority rows, including the ordering number and the calendar instance reference. IGF_AW_FUND_MAST_V (aliased FM) supplies the fund master attributes such as FUND_CODE, DESCRIPTION, SYS_FUND_TYPE, FUND_SOURCE, and FED_FUND_CODE, and is joined to the priority row on FUND_ID. Three instances of the lookup view IGF_LOOKUPS_VIEW (FNDS1, FNDS2, FNDS3) translate lookup codes into descriptive meaning text for the system fund type, fund source, and the federal fund code respectively. Finally, IGS_CA_INST (aliased CA) provides the calendar instance alternate code, joined on CAL_TYPE and SEQUENCE_NUMBER to match the priority row's CI_CAL_TYPE and CI_SEQUENCE_NUMBER. All joins are inner joins, so a priority row is returned only when valid fund, lookup, and calendar instance data exist.

Key Columns

Common Use Cases and Queries

Typical uses include reporting the fund packaging order for an aid year, verifying lookup decoding, and feeding integration extracts. A representative query listing priorities for a given aid year:

SELECT fund_code, fund_desc, sys_fund_code_desc,
       fund_source_desc, fund_order_num
FROM   apps.igf_aw_fn_rpkg_prty_v
WHERE  ci_alternate_code = :aid_year
ORDER  BY fund_order_num;

To isolate the federal fund code description the user searched for, filter directly on the decoded column, for example WHERE sys_fund_code_desc = 'FEDERAL PELL'. Because the view performs the lookup joins internally, it eliminates the need to duplicate the IGF_LOOKUPS_VIEW logic in reporting SQL, keeping custom reports consistent with the delivered fund re-packaging configuration.