Search Results igw_prop_locations_v




Overview
Explore in AI Chat

Overview

IGW_PROP_LOCATIONS_V is a reporting view owned by the APPS schema within the IGW (Grants Proposal) product family. The ETRM metadata designates this object as "10SC Only," indicating that it is specific to the Oracle Grants Proposal functionality rather than a general-purpose foundation object. Its role is to present a denormalized, human-readable projection of proposal performance locations — the organizations responsible for executing grant-funded work — together with their associated postal addresses. Proposal tracking in Oracle Grants Management requires associating each proposal with one or more performing organizations, and downstream reporting, inquiry screens, and integrations must resolve a performing organization identifier into an organization name and a formatted address. This view centralizes that resolution logic so that consumers avoid re-implementing the multi-table joins between proposal location assignments and HR organization and location data. Because it exposes ROWID along with standard Who columns (creation and last-update audit attributes), it is suitable for both read-only reporting and Oracle Forms-based maintenance contexts.

Underlying Base Objects

The view is defined over three base objects: IGW_PROP_LOCATIONS, HR_ORGANIZATION_UNITS, and HR_LOCATIONS. IGW_PROP_LOCATIONS is the driving table and stores the association between a PROPOSAL_ID and a PERFORMING_ORGANIZATION_ID. Each row is joined to HR_ORGANIZATION_UNITS on ORGANIZATION_ID = PERFORMING_ORGANIZATION_ID to obtain the organization name, and to HR_LOCATIONS on LOCATION_ID in an outer-join fashion (LOC.LOCATION_ID(+) = H.LOCATION_ID). The outer join is significant: performing organizations that have no location defined in HR still appear in the result set, with address components resolving to null. The view text applies nested REPLACE functions to the concatenated address lines, collapsing artifacts such as double commas and orphaned separators that arise when individual address lines are blank. Standard ETRM metadata does not document additional referenced objects beyond these three.

Key Columns

  • ROW_ID — the ROWID of the underlying IGW_PROP_LOCATIONS row, supporting direct row addressing.
  • PROPOSAL_ID — identifier of the parent grant proposal to which the location assignment belongs.
  • PERFORMING_ORGANIZATION_ID — the organization identifier of the performing organization; this is the column most frequently used in joins and filter predicates.
  • PERFORMING_ORG_NAME — the organization name sourced from HR_ORGANIZATION_UNITS.NAME.
  • PERFORMING_ORG_ADDRESS — a single concatenated string combining address lines 1–3, town or city, region 2, and postal code, cleaned of duplicated comma delimiters.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard audit columns carried through from IGW_PROP_LOCATIONS.

Common Use Cases and Queries

Typical usage includes proposal inquiry reports listing performing organizations and their addresses, extracts feeding institutional reporting or sponsor-facing documentation, and validation queries confirming that each proposal's performing organization resolves to a valid HR organization. A representative query filtering on the searched attribute is:

  • SELECT proposal_id, performing_organization_id, performing_org_name, performing_org_address
  • FROM apps.igw_prop_locations_v
  • WHERE performing_organization_id = :organization_id;

To retrieve all performing locations for a given proposal:

  • SELECT performing_organization_id, performing_org_name, performing_org_address
  • FROM apps.igw_prop_locations_v
  • WHERE proposal_id = :proposal_id;

Because the view is a simple join projection without aggregation, it can be safely joined to other proposal-level views on PROPOSAL_ID. Note that its "10SC Only" designation means availability and behavior should be confirmed against the specific 12.1.1 or 12.2.2 instance before relying on it in custom integrations.