Search Results org_ipf_code




Overview
Explore in AI Chat

Overview

IGW_APPLICANT_ORG_V is a public Oracle E-Business Suite view owned by the APPS schema and registered under the FND Design Data identifier IGW.IGW_APPLICANT_ORG_V. It belongs to the Grants Management (IGW) product family and presents organization-level attribute data for the institution submitting a proposal. Because the view is classified as a public view, Oracle supports its use for custom reporting, extracts, and integration scenarios, although it is not part of the documented, supported transactional API surface.

The view answers a recurring reporting need in sponsored-programs implementations: retrieving the assurance, compliance, and identifier data that a sponsor requires on a proposal cover page or in an agency submission extract. Columns such as HUMAN_ASSURANCE_NUMBER, the truncated ANIMAL_ASSURANCE_NUMBER (rendered as ANIMAL_ASSUR in the excerpted metadata), DUNS_NUMBER, CAGE_NUMBER, and EIN allow a single query to return the certification and registration values associated with the applicant organization. For users searching for the animal assurance number, this view is the documented point of access in the IGW data model.

Underlying Base Objects

The ETRM metadata registers this object as a VIEW in the APPS schema and documents no explicit referenced base objects. In the delivered Grants Management schema the view is defined over the IGW applicant organization tables, principally IGW_APPLICANT_ORGS_ALL and its associated organization profile and assurance attribute storage, joined to the proposal header to expose PROPOSAL_ID and PROPOSAL_NUMBER. Person identifier columns resolve to PER_ALL_PEOPLE_F, as noted in the column comments for the signing and administrative official government identifiers. Because the definition is not published in the metadata excerpt, the exact FROM clause should be confirmed by inspecting the source in the target instance via ALL_VIEWS, DBA_VIEWS, or the Grants Management data model documentation. This matters when the view is used for federation or ETL, since dependent base tables may carry different partitioning or indexing than the view suggests.

Key Columns

Common Use Cases and Queries

Typical uses include proposal cover-page reporting, agency submission extracts, and data quality audits confirming that assurance and DUNS values are populated before submission. The following query retrieves assurance and registration data for a proposal:

  • SELECT proposal_number, organization_id, animal_assurance_number, human_assurance_number, duns_number, cage_number FROM apps.igw_applicant_org_v WHERE proposal_number = :p_proposal_number;
  • SELECT organization_id, duns_number, duns4_number, ein, cage_number FROM apps.igw_applicant_org_v WHERE organization_id = :p_org_id;
  • SELECT COUNT(*) FROM apps.igw_applicant_org_v WHERE animal_assurance_number IS NULL;

Confirm the exact spelling of the animal assurance column, since the metadata excerpt truncates the name. Queries should be filtered by organization or proposal to limit the result set, and the view should be treated as read-only.