Search Results non_profit

Overview

APPS.IGW_ORGANIZATION_TYPES_V is a public Oracle EBS view owned by the APPS schema, registered under FND Design Data as IGW.IGW_ORGANIZATION_TYPES_V and holding a status of VALID. It belongs to the IGW product family, which governs Oracle Grants Management and the applicant/proposal data model used by research institutions, universities, and public-sector grantees. The view is classified as a public view, meaning Oracle documents it as potentially useful for custom reporting or other data requirements beyond the standard application screens.

The view presents the applicant organization's type classification for a given proposal. Rather than storing organization type as a single lookup value, the view exposes eight distinct columns, one for each type of organization recognized by the application: General, Small Business, Minority-owned business, Women-owned business, Federal, State, Local, and Nonprofit. The documentation notes an additional Small Disadvantaged column in the physical column list. The flagging convention is explicit: a value of "X" in a column means the condition is True, and NULL means False. This is directly relevant to the user's search term, "non_profit," which maps to the NON_PROFIT column. Consumers filtering on nonprofit applicants should test NON_PROFIT = 'X' rather than relying on a truthy numeric flag.

Underlying Base Objects

Per the documented dependency information, APPS.IGW_ORGANIZATION_TYPES_V references APPS.IGW_PROPOSALS_ALL and APPS.IGW_REPORT_PROCESSING. The view is not referenced by any other database object, so it functions as a terminal, read-only reporting surface rather than a building block within the IGW dependency chain. The line "show dependent code" in the ETRM excerpt indicates that the view source itself is available in the environment for inspection, which is useful when reconciling the display semantics against the base proposal records.

IGW_PROPOSALS_ALL is the principal base table supplying proposal-level context such as PROPOSAL_ID and PROPOSAL_NUMBER, and it is the table most likely to hold the organization type attributes projected into the eight columns. The inclusion of IGW_REPORT_PROCESSING suggests the view may have been constructed to serve reporting and report-processing scenarios, consistent with its designation as a public reporting view. The ETRM metadata for 12.2.2 does not enumerate additional referenced base objects; the documented dependencies above are authoritative for this release. No material differences between 12.1.1 and 12.2.2 are documented for this object, so the column semantics described here apply to both releases.

Key Columns

• PROPOSAL_ID (NUMBER, length 15) — Proposal identifier; the primary join key to IGW_PROPOSALS_ALL and related proposal tables.
• PROPOSAL_NUMBER (VARCHAR2, length 30) — Human-readable proposal number used in reporting and reconciliation.
• ORGANIZATION_ID (NUMBER, length 15) — Organization identifier for the applicant organization, joining to standard organization tables.
• GENERAL (VARCHAR2, 4000) — "X" indicates a general business organization.
• SMALL_BUSINESS (VARCHAR2, 4000) — "X" indicates a small business organization.
• MINORITY_BUSINESS (VARCHAR2, 4000) — "X" indicates a minority-owned business.
• WOMEN_BUSINESS (VARCHAR2, 4000) — "X" indicates a women-owned business.
• DISADVANTAGED (VARCHAR2, 4000) — "X" indicates a small disadvantaged organization.
• FEDERAL, STATE, LOCAL (VARCHAR2, 4000) — "X" indicates a federal, state, or local organization respectively.
• NON_PROFIT (VARCHAR2, 4000) — "X" indicates a nonprofit organization. This is the column most relevant to searches for "non_profit."

Every flag column is nullable and follows the identical X/NULL convention, which permits direct comparison and concatenation in SQL without numeric conversion.

Common Use Cases and Queries

Typical uses include proposal portfolio reporting, applicant demographic analysis, sponsor-mandated diversity and set-aside reporting, and integration extracts feeding downstream grants or BI systems. Because the view carries both identifiers and flags, it supports filtering, counting, and grouping in a single pass.

Full projection of the documented columns:

• SELECT PROPOSAL_ID, PROPOSAL_NUMBER, ORGANIZATION_ID, GENERAL, SMALL_BUSINESS, MINORITY_BUSINESS, WOMEN_BUSINESS, DISADVANTAGED, FEDERAL, STATE, LOCAL, NON_PROFIT FROM APPS.IGW_ORGANIZATION_TYPES_V;

Isolating nonprofit applicants, the primary use case implied by the "non_profit" search:

• SELECT PROPOSAL_NUMBER, ORGANIZATION_ID FROM APPS.IGW_ORGANIZATION_TYPES_V WHERE NON_PROFIT = 'X';

Counting proposals by organization type, noting that a proposal may satisfy more than one flag, so category counts need not sum to the total proposal count:

• SELECT COUNT(CASE WHEN NON_PROFIT = 'X' THEN 1 END) NONPROFIT_CNT, COUNT(CASE WHEN FEDERAL = 'X' THEN 1 END) FEDERAL_CNT, COUNT(CASE WHEN SMALL_BUSINESS = 'X' THEN 1 END) SMALL_BIZ_CNT FROM APPS.IGW_ORGANIZATION_TYPES_V;

Joining to IGW_PROPOSALS_ALL for additional proposal attributes should be performed on PROPOSAL_ID, and organization attributes may be joined on ORGANIZATION_ID. Because the view is documented as a public reporting view with no dependent objects, it is safe to query directly without affecting application processing logic.