Search Results igw_organization_types_v

Overview

IGW_ORGANIZATION_TYPES_V is a reporting view within the IGW — Grants Proposal module of Oracle E-Business Suite. The module carries the designation "Obsolete" in the Oracle EBS 12.1.1 and 12.2.2 release documentation, and the ETRM metadata explicitly records that the view is "Not implemented in this database." This qualification is significant: the view is documented for historical and reference purposes, but it does not exist as a deployed database object in a standard 12.1.1 or 12.2.2 installation. Its presence in the ETRM repository preserves the definition of a Grants Proposal reporting construct that may survive in upgraded or customized environments derived from earlier Oracle Grants applications.

The stated purpose of the view is to display details of the applicant organization associated with a proposal. Rather than storing organizational attributes, it derives them at query time by calling a report processing function against the submitting organization identifier. This design places the view in the category of computed or function-driven reporting objects rather than simple relational projections.

Underlying Base Objects

The view text identifies a single driving table: IGW_PROPOSALS_ALL, aliased as P. The ETRM metadata records no additional referenced base objects beyond this table. All organizational classification values are produced by repeated invocations of IGW_REPORT_PROCESSING.GET_ORG_TYPE, a PL/SQL function that accepts the submitting organization identifier and one or more organization type codes, returning the corresponding classification value for the proposal's applicant organization.

Because the view performs no joins and delegates all lookup logic to the function, its accuracy and performance depend entirely on the integrity of the GET_ORG_TYPE function and the underlying organization classification data it accesses. In environments where the function is absent or where the Grants Proposal schema has been partially decommissioned, the view would fail at parse or execution time.

Key Columns

The view exposes four identifier columns and nine classification columns:

• PROPOSAL_ID — Primary identifier of the proposal record from IGW_PROPOSALS_ALL.
• PROPOSAL_NUMBER — Human-readable proposal number used in reporting and reconciliation.
• SUBMITTING_ORGANIZATION_ID — Identifier of the applicant organization submitting the proposal.
• ORGANIZATION_ID — Reported organization identifier column documented in the column list.
• GENERAL — Derived from organization type code 'B9', indicating general organizational classification.
• SMALL_BUSINESS — Derived from code '21', flagging small business status.
• MINORITY_BUSINESS — Derived from codes '22' and '23', covering minority business designations.
• WOMEN_BUSINESS — Derived from code 'A2', indicating women-owned business status.
• DISADVANTAGED — Derived from code '27', indicating disadvantaged business status.
• FEDERAL — Derived from code '2R', identifying federal organizations.
• STATE — Derived from code '2F', identifying state-level organizations.
• LOCAL — Derived from code 'C6', identifying local government organizations.
• NON_PROFIT — Derived from code 'A8', identifying non-profit organizations.

Common Use Cases and Queries

The view was designed to support proposal-level reporting that requires the applicant organization's demographic and jurisdictional classification, such as federal grant submission summaries and diversity-spend or set-aside analysis. A typical query retrieves one row per proposal with all classification flags:

SELECT PROPOSAL_ID, PROPOSAL_NUMBER, SUBMITTING_ORGANIZATION_ID, SMALL_BUSINESS, MINORITY_BUSINESS, WOMEN_BUSINESS, DISADVANTAGED FROM IGW_ORGANIZATION_TYPES_V;

Filtering by a specific proposal is equally straightforward:

SELECT * FROM IGW_ORGANIZATION_TYPES_V WHERE PROPOSAL_NUMBER = :proposal_number;

Because each classification column results from a separate function call, queries returning large proposal populations can incur significant execution cost. Administrators working in environments where the object is absent must reconstruct equivalent logic directly against IGW_PROPOSALS_ALL and the organization classification tables, since the view itself cannot be queried in a standard 12.1.1 or 12.2.2 instance.