Search Results item_category_code

Overview

IGF_AW_ITEM_V is a reporting view within the Oracle E-Business Suite product family designated IGF — Financial Aid, a module that is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view exposes the details of cost of attendance (COA) items, which are the individual budget components — such as tuition, fees, books, supplies, room, board, transportation, and personal expenses — used in financial aid packaging and needs analysis. Its role is strictly read-only presentation: it denormalizes the base item table and augments each record with a human-readable category description resolved through an Oracle EBS lookup, allowing downstream reporting, extracts, and integrations to surface cost of attendance item master data without repeating lookup translation logic.

Underlying Base Objects

The view is defined over a single documented base object, IGF_AW_ITEM, aliased as ITEM in the view text. No other base tables or objects are documented in the ETRM metadata. Every column except one is a direct pass-through from IGF_AW_ITEM; the sole derived column is ITEM_CATEGORY_DESC, which is produced by a call to the database function IGF_AW_GEN.LOOKUP_DESC('IGF_AW_COA_ITEM_CATEGORY', ITEM.ITEM_CATEGORY_CODE). This function maps the stored ITEM_CATEGORY_CODE against the IGF_AW_COA_ITEM_CATEGORY lookup type and returns the associated description. Because no joins are present in the view text, ITEM_CATEGORY_DESC is resolved per row via a scalar function call rather than a conventional join to FND_LOOKUP_VALUES or an equivalent lookup table.

Key Columns

• ROW_ID — The ROWID of the underlying IGF_AW_ITEM row, used to uniquely identify a record and typically employed for locking or direct row access.
• ITEM_CODE — The unique code identifying the cost of attendance item.
• DESCRIPTION — The descriptive name of the item as maintained on the base record.
• ACTIVE — The active/inactive flag controlling whether the item is available for use.
• ITEM_CATEGORY_CODE — The category classification code for the item. This is the column most relevant to the search term item_category_code; it is returned directly from IGF_AW_ITEM.
• ITEM_CATEGORY_DESC — The translated description of ITEM_CATEGORY_CODE, obtained through IGF_AW_GEN.LOOKUP_DESC for lookup type IGF_AW_COA_ITEM_CATEGORY.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns identifying the creating and last-updating user sessions and timestamps, supporting audit and change tracking.

Common Use Cases and Queries

The primary uses are reporting on the cost of attendance item master, validating categorization of COA items, and feeding external or downstream processes with item metadata. Filtering by ITEM_CATEGORY_CODE is a natural access path for the view. A typical query retrieving active items and their category descriptions follows:

SELECT item_code,
       description,
       item_category_code,
       item_category_desc
FROM   igf_aw_item_v
WHERE  active = 'Y'
AND    item_category_code = :p_category_code
ORDER BY item_code;

Because the view performs no joins and derives ITEM_CATEGORY_DESC through a function call, queries that filter or group heavily on the descriptive category may benefit from filtering on ITEM_CATEGORY_CODE and resolving the description afterward. A grouped summary by category is also common:

SELECT item_category_code,
       item_category_desc,
       COUNT(*) item_count
FROM   igf_aw_item_v
WHERE  active = 'Y'
GROUP BY item_category_code, item_category_desc;

Note that the ETRM metadata records this view as associated with the obsolete IGF Financial Aid module and states "Not implemented in this database" for the implementation/DBA data. As a result, in a live 12.1.1 or 12.2.2 instance the view may not exist, or may retain residual objects from prior financial aid deployments. Teams evaluating it for ongoing use should confirm availability and confirm that IGF_AW_GEN.LOOKUP_DESC and lookup type IGF_AW_COA_ITEM_CATEGORY are present before relying on the derived description column, since the view text depends on both.