Search Results prop_oahp

Overview

IGW_PROPOSALS_V is a reporting and inquiry view in the Oracle E-Business Suite Grants (IGW) module, exposed under the APPS schema. It presents a denormalized, presentation-ready projection of proposal header data from the Grants Management functionality. Its primary role is to serve the Proposal search, list-of-values, and summary screens within the Oracle Grants/Proposal (IGW) application, and to provide a single flattened query surface for reporting and integration consumers that need proposal attributes together with descriptive lookups and party names.

The view resolves the raw status code stored on the proposal into a human-readable meaning via the FND_LOOKUPS lookup type IGW_PROPOSAL_STATUS, and joins multiple HZ_PARTIES instances to resolve sponsor, applicant, proposal manager, and program manager names. It also computes runtime flags and values such as currency code and the proposal OA home page menu, based on profile options.

Underlying Base Objects

The view is defined over the following base objects:

• IGW_PROPOSALS_ALL — the primary proposal entity table, aliased as ProposalEO, supplying proposal identity, status, dates, and management attributes.
• FND_LOOKUPS — aliased as l, providing the translated meaning for the IGW_PROPOSAL_STATUS lookup type.
• IGW_PROP_GRANTORS — aliased as g, supplying sponsor/grantor identifiers.
• HZ_PARTIES — joined four times as c, p1, p2, and p3 to resolve sponsor, applicant, proposal manager, and program manager names respectively.
• IGW_BUDGETS — aliased as b, supplying budget cost aggregates.

Because it is a view rather than a table, it inherits security and joins from its base objects; row visibility depends on the underlying Grants security model applied to IGW_PROPOSALS_ALL.

Key Columns

The view exposes identity and descriptive columns directly from IGW_PROPOSALS_ALL, including PROPOSAL_ID, PROPOSAL_NUMBER, PROPOSAL_SHORT_TITLE, PROPOSAL_TITLE, PROPOSAL_TYPE_CODE, ACTIVITY_TYPE_CODE, and SPONSOR_ACTION_CODE. The raw PROPOSAL_STATUS code is accompanied by PROPOSAL_STATUS_DESC, the decoded meaning from the IGW_PROPOSAL_STATUS lookup.

Party resolution produces SPONSOR_ID/SPONSOR_NAME, APPLICANT, PROPOSAL_MANAGER_NAME, and PROGRAM_MANAGER_NAME. Budget aggregates appear as TOTAL_DIRECT_COST, TOTAL_INDIRECT_COST, and TOTAL_COST.

Operational and UI-support columns include PROPOSAL_START_DATE, PROPOSAL_END_DATE, DEADLINE_DATE, AWARD_NUMBER, and SPONSOR_APPLICATION_NUMBER. Runtime-computed columns include CURRENCY_CODE (from profile ICX_PREFERRED_CURRENCY), PROP_OAHP (menu name based on IGW_PROPOSAL_INSTALLATION_MODE), PROFILE_IGW_MODE, ALLOW_QUERY (set to 'Y'), and switcher/flag values DETAIL_VIEW, SELECT_FLAG, SUBMIT_SWITCHER, and DELETE_SWITCHER. Uppercase helpers UPPER_PROPOSAL_NUMBER, UPPER_PROPOSAL_SHORT_TITLE, and UPPER_PROPOSAL_TITLE support case-insensitive searching.

Common Use Cases and Queries

Typical usage includes proposal status inquiries, searching by number or title, and integration extracts that require resolved status descriptions and party names.

• Filter by status description: SELECT proposal_number, proposal_status_desc FROM apps.igw_proposals_v WHERE proposal_status_desc = 'Submitted';
• Case-insensitive search: SELECT proposal_number FROM apps.igw_proposals_v WHERE upper_proposal_number LIKE :p || '%';
• Cost summaries: SELECT proposal_number, total_direct_cost, total_indirect_cost, total_cost FROM apps.igw_proposals_v WHERE proposal_id = :id;

Users searching on "igw_proposal_status" should note that this term corresponds both to the underlying lookup type IGW_PROPOSAL_STATUS and to the PROPOSAL_STATUS/PROPOSAL_STATUS_DESC columns exposed by this view.