Results for “igw_proposal_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.IGWFV_GRANT_PROPOSAL is a Business Intelligence System (BIS) view within the Oracle E-Business Suite Grants Management (Oracle Grants / IGW) module, owned by the APPS schema and registered under FND Design Data IGW.IGWFV_GRANT_PROPOSAL. Its status is VALID. The view presents a consolidated, reporting-oriented projection of grant proposal information: proposal identification, the lead and submitting organizations, sponsor details, award cross-references, key dates, and workflow-driven status indicators. Because it is a BIS view, it is intended for ad hoc query, discoverer-style reporting, and integration extracts rather than transactional maintenance. In the context of EBS 12.1.1 and 12.2.2 the object remains schema-qualified as APPS and is queried read-only; the Online Patching (adop) architecture in 12.2.2 does not change the consumer-facing behavior of BIS views, though the underlying editioning views on the base tables are managed automatically.

Underlying Base Objects

The documented metadata records no explicitly referenced base objects. In practice, IGW views of this class are defined over the Grants proposal and related tables in the IGW schema (for example the proposal headers, proposal organizations, sponsor, award, and workflow/status tables), then joined and exposed through the APPS synonym layer. Column derivation reflects these joins: organizational names are resolved from HR/legal-entity sources, sponsor and award figures are resolved from their respective Grants tables, and the internal IDs (PROPOSAL_ID, LEAD_ORGANIZATION_ID, SUBMITTING_ORGANIZATION_ID, SPONSOR_ID, ORIGINAL_SPONSOR_ID, ORG_ID) are carried through to preserve joins to other views. Multi-Org filtering is preserved via ORG_ID, and audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY) are inherited from the base records. Two synthetic status columns, _LA:PROPOSAL_STATUS and _DF, are computed by the view rather than stored.

Key Columns

• PROPOSAL_NUMBER / PROPOSAL_TITLE / PROPOSAL_TYPE — primary business identifier and descriptive attributes of the proposal.
• _LA:PROPOSAL_STATUS — the translated (language-attribute) proposal status, exposed as CHAR(61); central to status reporting.
• LEAD_ORGANIZATION_NAME, SUBMITTING_ORGANIZATION_NAME and their IDs — the organizations responsible for and submitting the proposal.
• PROPOSAL_START_DATE / PROPOSAL_END_DATE — the planned performance period.
• LETTER_OF_INTENT_DUE_DATE — the due date for the sponsor-required letter of intent; this is the column directly matching the user's search term.
• DEADLINE_DATE / DEADLINE_TYPE — general submission deadline and its classification.
• AWARD_NUMBER / AWARD_AMOUNT, ORIGINAL_PROPOSAL_NUMBER / ORIGINAL_AWARD_NUMBER — funding outcome and cross-reference to prior/original records.
• SPONSOR_NAME, SPONSOR_PROPOSAL_NUMBER, SPONSOR_ACTION, SPONSOR_ACTION_DATE, SPONSOR_ID — sponsor identity and latest sponsor action on the proposal.
• PROGRAM_NUMBER, PROGRAM_TITLE, PROGRAM_URL, NOTICE_OF_OPPORTUNITY — funding-program context.
• NARRATIVE_STATUS, NARRATIVE_TYPE_CODE, NARRATIVE_SUBMISSION — narrative/attachment tracking.
• ORG_ID and audit columns — Multi-Org and row-audit context.

Common Use Cases and Queries

The view is typically used to report proposal pipelines, monitor deadlines (including letter-of-intent dates), and extract data for downstream grants analytics. A representative query targeting the searched column is:

• SELECT proposal_number, proposal_title, sponsor_name, letter_of_intent_due_date, deadline_date FROM apps.igwfv_grant_proposal WHERE letter_of_intent_due_date IS NOT NULL ORDER BY letter_of_intent_due_date;
• Filtering by status: ... WHERE "_LA:PROPOSAL_STATUS" = 'Submitted';
• Multi-Org-scoped extracts: ... WHERE org_id = :p_org_id;
• Joining by ID: ... FROM apps.igwfv_grant_proposal g WHERE g.proposal_id = :proposal_id;

Because the view is read-only and BIS-classified, it should be used for retrieval only; updates belong to the underlying Grants application pages.