Results for “award_number”

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

Overview

The GMS_SSA_AWARD_EXPTYPE_V view is a reporting and integration object owned by the APPS schema within the GMS – Grants Accounting product family in Oracle E-Business Suite (12.1.1 and 12.2.2). It exposes the relationship between an award and the expenditure types that are permitted against that award, resolved through the award's allowable cost schedule. In effect, the view flattens the many-to-many linkage between awards and allowable expenditure types into a denormalized result set that lists, for each award, every expenditure type carried on its associated allowability schedule.

The object is registered in ETRM with a status of VALID and an object type of VIEW. Because it is a view rather than a stored table, it holds no persistent data; it derives its rows at query time from two underlying synonyms, making it suitable for read-only reporting, data extraction, and integration interfaces that must validate whether a given expenditure type is allowable on a specific award.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both exposed as synonyms in the APPS schema:

• GMS_AWARDS — the awards master, supplying the award identifier, award number, the allowable schedule identifier, and the operating unit (ORG_ID).
• GMS_ALLOWABLE_EXPENDITURES — the allowable expenditure configuration, supplying the expenditure type and the allowability schedule to which it belongs.

The view text joins these two objects with the predicate GA.ALLOWABLE_SCHEDULE_ID = GAE.ALLOWABILITY_SCHEDULE_ID. This is an equi-join keyed on the schedule identifier, which is precisely the column referenced by the search term allowable_schedule_id. The join ensures that only expenditure types tied to the schedule currently assigned to the award are returned, so the result set reflects the award's active allowability configuration.

Key Columns

• AWARD_ID — the unique internal identifier of the award, sourced from GMS_AWARDS. This is the primary join key back to award-level data and the most common filter in downstream queries.
• AWARD_NUMBER — the user-facing award number, useful for display and cross-referencing without a lookup to GMS_AWARDS.
• ALLOWABLE_SCHEDULE_ID — the allowability schedule identifier that links the award to its permitted expenditure types. This is the join column and the pivot of the view's logic; changes to the award's schedule change the rows returned.
• EXPENDITURE_TYPE — the expenditure type name carried on the allowability schedule, identifying which cost categories may be charged to the award.
• ORG_ID — the operating unit (business group/legal entity context) of the award, supporting multi-org security and filtering.

Common Use Cases and Queries

A frequent requirement is to validate whether a specific expenditure type is allowable on a given award before a cost transaction is charged. The following query returns all allowable expenditure types for one award:

• SELECT award_number, expenditure_type FROM gms_ssa_award_exptype_v WHERE award_id = :p_award_id;

Reporting users commonly search by allowable_schedule_id to trace which awards share a schedule and therefore the same set of allowable expenditure types:

• SELECT award_number, allowable_schedule_id, expenditure_type FROM gms_ssa_award_exptype_v WHERE allowable_schedule_id = :p_schedule_id ORDER BY award_number, expenditure_type;

For operating-unit-scoped extracts, ORG_ID is applied as an additional predicate to honor multi-org access. Because the view performs a single join over two synonyms and exposes indexed identifier columns, it is efficient for lookup-style queries, though large-scale extracts against many awards should filter on AWARD_ID or ALLOWABLE_SCHEDULE_ID rather than scanning the full result set.