Search Results igwfv_grant_proposal_rate_type

Overview

The IGWFV_GRANT_PROPOSAL_RATE_TYPE view is a read-only database object owned by the APPS schema within the IGW (Grants Proposal) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the relationship between grant proposal rate classes and their associated rate types, presenting descriptive text for both entities alongside the identifier and audit columns required to trace record provenance. The view functions as a denormalized reporting surface over the IGW rate configuration tables, allowing both rate class and rate type descriptions to be retrieved from a single query without requiring consumers to join the underlying tables themselves.

Rate classes and rate types are foundational setup constructs in grants management. Rate classes group related rates under a common category, while rate types define the individual rates applied during proposal costing and indirect cost calculation. By surfacing this combination as a single view, the IGW module supports concurrent programs, form-based navigation, and reporting layers that need to enumerate valid rate type values in the context of their parent class. The view text is explicitly defined with the WITH READ ONLY clause, confirming that it carries no maintenance responsibility and exists purely for query consumption.

Underlying Base Objects

The view is defined over two base tables in the APPS schema:

• IGW_RATE_TYPES (alias RTYP) — the primary rate type table, supplying the rate type description, rate class foreign key, rate type primary key, and audit columns.
• IGW_RATE_CLASSES (alias RCLASS) — the parent rate class table, supplying the rate class description and rate class identifier.

The two tables are joined on RATE_CLASS_ID, with IGW_RATE_TYPES as the driving table. The join is an equijoin on a mandatory relationship: each rate type belongs to exactly one rate class. The view therefore inherits the cardinality of IGW_RATE_TYPES, filtered to rows whose parent class exists in IGW_RATE_CLASSES.

Key Columns

• RATE_CLASS_DESCRIPTION — Text description of the parent rate class, sourced from IGW_RATE_CLASSES.DESCRIPTION.
• RATE_TYPE_DESCRIPTION — Text description of the rate type itself, sourced from IGW_RATE_TYPES.DESCRIPTION.
• RATE_CLASS_ID — Primary key of the parent rate class. Used to group or filter rate types by class.
• RATE_TYPE_ID — Primary key of the rate type. This is the value referenced by downstream rate setup and proposal costing records.
• LAST_UPDATE_DATE — Date the rate type record was last modified.
• LAST_UPDATED_BY — User identifier responsible for the most recent update.
• CREATION_DATE — Date the rate type record was created.
• CREATED_BY — User identifier who created the rate type record.

The two identifier columns support joins and programmatic lookups, while the description columns provide human-readable output for reports and lists of values.

Common Use Cases and Queries

Typical uses include populating rate type selection lists, validating setup completeness, and producing reference reports of rate configuration. A representative query listing all rate types grouped by class follows:

• SELECT rate_class_description, rate_type_description, rate_type_id FROM igwfv_grant_proposal_rate_type ORDER BY rate_class_description, rate_type_description;
• SELECT rate_type_description FROM igwfv_grant_proposal_rate_type WHERE rate_class_id = :p_rate_class_id;
• SELECT rate_class_description, COUNT(*) FROM igwfv_grant_proposal_rate_type GROUP BY rate_class_description;

Because the view is read-only and based on setup tables, it is safe for concurrent reports and integration extracts. It should not be used as a target for DML; maintenance is performed directly against IGW_RATE_TYPES and IGW_RATE_CLASSES.