Search Results dodaac_number




Overview
Explore in AI Chat

Overview

IGW_PRPO_PERF_SITES_V is a reporting view in the Oracle E-Business Suite IGW (Grants Proposal) product, identified in ETRM metadata as part of the obsolete Grants Proposal module. The view consolidates the performing sites at which proposal activity is conducted, exposing a single, report-friendly row set that joins proposal location data to organization, location, party, and organization detail records. It is a UNION-based view: the first branch resolves performing sites that carry a valid HR organization identifier, while the second branch resolves proposal locations that are recorded only against an HZ_PARTIES party record with no performing organization identifier. This design allows downstream reporting and integration to obtain a complete roster of performing sites regardless of which modeling path the proposal used. Columns such as DUNS_NUMBER, DUNS4_NUMBER, DODAAC_NUMBER, and CAGE_NUMBER make the view suitable for government-facing proposal and registration extracts, where DUNS and related federal identifiers must be published alongside the site address. ETRM lists the product context as "IGW - Grants Proposal (Obsolete)," and the implementation notes record that the view was not implemented in the source database from which the metadata was captured, so it should be treated as documentation of legacy structure rather than an assumption of availability in any given instance.

Underlying Base Objects

The documented view text derives its rows from four base tables. IGW_PROP_LOCATIONS (aliased PRFM) is the driving table and supplies PROPOSAL_ID, PERFORMING_ORGANIZATION_ID, and PARTY_ID. IGW_ORG_DETAILS (ORGDT) is outer-joined on PERFORMING_ORGANIZATION_ID = ORGDT.ORGANIZATION_ID and is the sole source of the federal identifiers DUNS_NUMBER, DUNS4_NUMBER, DODAAC_NUMBER, and CAGE_NUMBER. HR_ORGANIZATION_UNITS (HRORG) is joined on ORGANIZATION_ID to provide the performing organization name, and HR_LOCATIONS (HRLOC) is outer-joined via LOCATION_ID to supply structured address elements. The second UNION branch joins IGW_PROP_LOCATIONS to HZ_PARTIES (HP) on PARTY_ID, selecting party name, address, city, county, state, postal code, and country, while explicitly projecting NULL for DUNS4_NUMBER, DODAAC_NUMBER, and CAGE_NUMBER; note that DUNS_NUMBER is obtained here via TO_CHAR(HP.DUNS_NUMBER). ETRM documents no separate referenced base objects for this view beyond the columns and text shown above.

Key Columns

  • PROPOSAL_ID — identifier of the proposal to which the performing site belongs.
  • PERFORMING_ORGANIZATION_ID — HR organization identifier of the performing site; NULL in the HZ_PARTIES branch.
  • PARTY_ID — trading community party identifier associated with the location.
  • PERFORMING_ORGANIZATION_NAME — organization name, sourced from HR_ORGANIZATION_UNITS or HZ_PARTIES depending on the branch.
  • ADDRESS_LINE_1/2/3, TOWN_OR_CITY, COUNTY, STATE, POSTAL_CODE, COUNTRY — address elements; the HR branch maps REGION_1 to county and REGION_2 to state.
  • DUNS_NUMBER, DUNS4_NUMBER, DODAAC_NUMBER, CAGE_NUMBER — federal and commercial entity identifiers sourced from IGW_ORG_DETAILS; DUNS4_NUMBER is populated only in the HR organization branch.

Common Use Cases and Queries

Typical uses include proposal site listings for grant and contract submissions, organization registration extracts, and reconciliation of performing sites against organization detail records. A query for users searching on duns4_number would isolate sites where the four-digit DUNS suffix is recorded:

SELECT PROPOSAL_ID, PERFORMING_ORGANIZATION_NAME, TOWN_OR_CITY, POSTAL_CODE, DUNS_NUMBER, DUNS4_NUMBER FROM IGW_PRPO_PERF_SITES_V WHERE DUNS4_NUMBER IS NOT NULL;

Broader reporting on a single proposal may select all address and identifier columns filtered by PROPOSAL_ID, ordered by PERFORMING_ORGANIZATION_NAME. Because the second UNION branch returns NULL for DUNS4_NUMBER, DODAAC_NUMBER, and CAGE_NUMBER, queries that require these identifiers should include an appropriate IS NOT NULL predicate to avoid rows that originate from the HZ_PARTIES path.