Search Results performing_organization_id




Overview
Explore in AI Chat

Overview

IGW_PROP_LOCATIONS_V is a seeded Oracle E-Business Suite view owned by the APPS schema, defined under the FND design data product IGW (Grants Management). It carries a VALID status in both 12.1.1 and 12.2.2 and is documented in the ETRM repository as an inquiry-only reporting and integration object. The view presents the performing-location details recorded against a grant or proposal, joining proposal location rows to human-resources organization and location definitions.

Its practical role is to expose the performing organization of a proposal — the institution, department, or unit that carries out the funded work — alongside its descriptive name and formatted address. Because the view resolves the organization identifier through HR organization units and HR locations, report writers and interface developers can obtain presentation-ready organization names and addresses without writing the multi-table HR joins themselves. The performing_organization_id column is the primary key through which downstream objects, concurrent programs, and custom reports link a proposal to its performing organization.

Underlying Base Objects

The documented dependency list identifies the following base objects:

  • APPS.IGW_PROP_LOCATIONS — the transactional table holding proposal location rows; supplies PROPOSAL_ID, PERFORMING_ORGANIZATION_ID, and the WHO columns.
  • APPS.HR_ORGANIZATION_UNITS — supplies the organization unit definition that PERFORMING_ORGANIZATION_ID references.
  • APPS.HR_LOCATIONS — supplies the location record used to build the formatted address.
  • APPS.HR_GENERAL — the HR general utility package used to derive the concatenated organization name and address.
  • APPS.HR_SECURITY — the HR security package, referenced for the organization security predicate so that only organizations visible to the querying responsibility are returned.

IGW_PROP_LOCATIONS_V is a read-only view and, per the metadata, is not referenced by any other database object. It therefore functions strictly as a reporting and integration surface over the IGW and HR base tables.

Key Columns

  • ROW_ID (ROWID) — pseudo-column identifying the underlying IGW_PROP_LOCATIONS row.
  • PROPOSAL_ID (NUMBER 15) — the proposal or award to which the performing location belongs.
  • PERFORMING_ORGANIZATION_ID (NUMBER 15) — the organization unit identifier of the performing organization; the column most often used in report parameters and joins.
  • PERFORMING_ORG_NAME (VARCHAR2 240) — the resolved, display-ready organization name.
  • PERFORMING_ORG_ADDRESS (VARCHAR2 905) — the formatted address assembled from HR locations.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns inherited from the base table.

Common Use Cases and Queries

The view supports proposal and award listings that must show where work will be performed, grants reporting by organization, and extracts that feed downstream systems with organization identifiers and addresses. Because HR security is applied, results are automatically filtered to the organizations accessible to the current responsibility.

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

A second common pattern retrieves all performing locations associated with a given organization, typically for roll-up reporting by department:

SELECT proposal_id
     , performing_org_name
  FROM apps.igw_prop_locations_v
 WHERE performing_organization_id = :p_org_id
 ORDER BY proposal_id;

Note that PERFORMING_ORG_NAME and PERFORMING_ORG_ADDRESS depend on HR organization and location data being correctly maintained; missing or end-dated HR records produce null descriptions. Queries should always qualify the view with APPS and rely on the view rather than the base table when display values are required.