Search Results igf_aw_sys_fund_type




Overview
Explore in AI Chat

Overview

IGF_AW_FN_RPKG_PRTY_V is a reporting view in the Oracle E-Business Suite (EBS) Oracle Grants/Funds Management (IGF) schema, owned by APPS. It presents the funding priority records held in IGF_AW_FN_RPKG_PRTY, enriched with descriptive attributes drawn from the fund master and from Oracle lookups, and joined to the calendar instance that identifies the award or proposal period to which the priority applies. The view is therefore a denormalized presentation layer: it converts code values stored on the fund record — system fund type, fund source, and federal fund code — into their human-readable lookup meanings, so that downstream reports, concurrent programs, and integration extracts do not need to repeat the lookup resolution logic.

Within the ETRM 12.1.1 and 12.2.2 documentation set, the object is documented as a view over the IGF_AW (Award Management) family of tables. It is relevant to users who search on "igf_aw_fund_source," because one of its projected columns, FUND_SOURCE_DESC, is derived precisely from the IGF_AW_FUND_SOURCE lookup applied to the fund master's FUND_SOURCE value. The view returns no base-table identifiers of its own; it is a query-only construct and carries no independent storage, privileges beyond those granted on APPS, or triggers.

Underlying Base Objects

The view is defined over the following objects, as documented in the view text:

The joins are inner joins throughout, so a priority row appears only when a matching fund, all three lookup codes, and a matching calendar instance exist. Calendar type and sequence number are concatenated into the join, reflecting the IGS_CA_INST composite key design.

Key Columns

  • ROWID — the row identifier of the underlying priority record; useful for targeted updates and diagnostics.
  • FUND_ORDER_NUM — the ordering/priority rank assigned to the fund.
  • CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and instance sequence identifying the award or proposal period.
  • ALTERNATE_CODE — the user-facing code of the resolved calendar instance.
  • FUND_ID, FUND_CODE, DESCRIPTION — the fund identity and its descriptive text.
  • SYS_FUND_TYPE_DESC, FUND_SOURCE_DESC, SYS_FUND_CODE_DESC — decoded meanings for the fund's system fund type, fund source, and federal fund code.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns propagated from the priority table.

Common Use Cases and Queries

The view is typically used to report funding priority by award period, to validate that a fund carries the expected fund source before it is considered in an award budget, and to feed extracts that must present descriptions rather than lookup codes. A representative query listing priorities for a given award period follows:

SELECT fund_order_num, fund_code, description, fund_source_desc, alternate_code
FROM apps.igf_aw_fn_rpkg_prty_v
WHERE alternate_code = :p_award_number
ORDER BY fund_order_num;

To isolate funds by source — the scenario implied by the "igf_aw_fund_source" search — filter on the decoded column rather than on the base fund master:

SELECT fund_code, description, fund_source_desc, sys_fund_type_desc
FROM apps.igf_aw_fn_rpkg_prty_v
WHERE fund_source_desc = 'Federal';

Because all joins are inner, rows with unmapped lookup codes or missing calendar instances are silently excluded. When reconciliations differ from IGF_AW_FN_RPKG_PRTY, the discrepancy should be traced to the lookup tables, the fund master, or IGS_CA_INST rather than to the view itself.