Results for “igf_aw_system_award_year”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_LKUPS_OVRD_V is a reporting and inquiry view in the Oracle E-Business Suite (EBS) Grants Management / ETRM (Enterprise Tracking and Reporting) module, owned by the APPS schema. It presents lookup override records maintained against the system award year domain used by the Award (IGF) application family. The view joins the override table IGF_AW_LKUPS_OVRD to the multilingual lookup type translation table FND_LOOKUP_TYPES_TL, so that consumers see both the raw override row and the language-specific meaning and description of the associated lookup type.

The user search term igf_aw_system_award_year corresponds to the lookup type passed to IGF_AW_GEN.LOOKUP_DESC within the view definition. This confirms that the view exists in part to resolve and expose descriptive text for the system award year lookup, complementing the stored SYS_AWARD_YEAR value with its human-readable description. The view is read-only by construction and is intended for reporting, validation, and integration rather than for maintenance of override data.

Underlying Base Objects

The view is defined over two documented base objects:

• IGF_AW_LKUPS_OVRD (alias AW) — the primary table holding lookup override rows, including the system award year, lookup type, and standard WHO audit columns.
• FND_LOOKUP_TYPES_TL (alias TL) — the translated lookup type table, filtered to VIEW_APPLICATION_ID = 8406 and LANGUAGE = USERENV('LANG'). This restricts results to the Grants/IGF application view and to the session language.

The join condition is TL.LOOKUP_TYPE = AW.LOOKUP_TYPE, so each override row is enriched with the translated lookup type meaning and description. The view also invokes the stored function IGF_AW_GEN.LOOKUP_DESC against the IGF_AW_SYSTEM_AWARD_YEAR lookup type, deriving a decoded description for the stored system award year value. No additional base objects are documented beyond these two tables and the referenced function.

Key Columns

• ROWID — the physical row identifier of the underlying override record, useful for direct DML or debugging.
• SYS_AWARD_YEAR — the stored system award year value held on the override row.
• LOOKUP_DESC('IGF_AW_SYSTEM_AWARD_YEAR', SYS_AWARD_YEAR) — the decoded, descriptive text for the system award year, returned by IGF_AW_GEN.LOOKUP_DESC.
• LOOKUP_TYPE — the lookup type to which the override applies.
• MEANING / DESCRIPTION — the translated meaning and description sourced from FND_LOOKUP_TYPES_TL for the session language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the override table.

Common Use Cases and Queries

Typical uses include reporting on award year lookup overrides, validating that override records resolve to a defined lookup type in the active language, and feeding decoded award year descriptions into integrations. Because the view filters on session language, results vary by USERENV('LANG'), which should be considered in concurrent programs and interfaces.

Sample query listing overrides with their decoded system award year:

• SELECT lookup_type, sys_award_year, meaning, description FROM apps.igf_aw_lkups_ovrd_v ORDER BY lookup_type, sys_award_year;

Sample query filtered to the system award year domain:

• SELECT sys_award_year, meaning FROM apps.igf_aw_lkups_ovrd_v WHERE lookup_type = 'IGF_AW_SYSTEM_AWARD_YEAR';

Sample query auditing recent changes:

• SELECT lookup_type, sys_award_year, last_updated_by, last_update_date FROM apps.igf_aw_lkups_ovrd_v WHERE last_update_date >= SYSDATE - 30;