Search Results igw_pi_v




Overview
Explore in AI Chat

Overview

IGW_PI_V is a reporting view within the Oracle E-Business Suite Grants Proposal (IGW) module, a product designation now marked Obsolete in the ETRM repository. The view presents the details of the Principal Investigator (PI) associated with a proposal — that is, the Proposal Manager or lead investigator recorded on a grant or contract proposal. The view name reflects this purpose: "IGW" denotes the Grants Proposal application, and "PI" denotes Principal Investigator.

Its role is purely presentational: it consolidates person, proposal, assignment, location, and lookup data into a single denormalized row per PI/proposal combination, allowing Grants Proposal reports and concurrent programs to retrieve formatted investigator information — including composite name strings, job title, academic degrees, and contact details — without embedding complex joins in each report.

The ETRM entry records that the view is not implemented in the reference database and that no base objects are documented in the 12.2.2 metadata, although the view text itself fully describes the underlying tables. The view applies to Oracle EBS releases 12.1.1 and 12.2.2, in which the IGW product family remains present but deprecated.

Underlying Base Objects

The view text identifies the following base objects:

The joins are structured so that proposal and PI data are mandatory, while assignment, location, and lookup data are optional (outer joins). This design ensures the PI record is returned even when assignment or address data is missing.

Key Columns

The view exposes the following significant columns:

Common Use Cases and Queries

Typical uses include producing PI rosters for proposal packages, generating investigator contact sheets for sponsored research offices, and feeding downstream grant reports. A representative query retrieving the PI name and contact details for a proposal is:

SELECT proposal_number, last_first_middle_name, middle_names, job_name, degrees, work_phone, email_address FROM igw_pi_v WHERE proposal_id = :p_proposal_id;

To locate PIs by middle name, a report may use:

SELECT proposal_number, full_name, middle_names FROM igw_pi_v WHERE UPPER(middle_names) LIKE UPPER('%' || :search_term || '%');

Because the view is obsolete and not implemented in current reference databases, organizations on 12.1.1 and 12.2.2 should confirm its presence before relying on it, and plan migration toward supported proposal-management reporting alternatives.