Search Results percent_dollar_flag




Overview
Explore in AI Chat

Overview

IGW_PRPO_CATEGORY_AMTS_V is a reporting view within the IGW – Grants Proposal module of Oracle E-Business Suite, a module that is now classified as obsolete in the Oracle ETRM repository and is documented as "Not implemented in this database." Its purpose is to present summarized budget-line information grouped according to the sponsor budget hierarchy used in grants proposal processing. The view consolidates data originating from proposal budgets, budget periods, and report-budget detail so that downstream reporting and integration processes can consume category-level and period-level totals in a single, denormalized result set.

Because IGW relates to sponsored-research proposal creation and budgeting, this view supports the presentation of both rolled-up category totals (calculated direct cost and employee-benefit totals) and individual budget-line detail. The presence of the PERCENT_DOLLAR_FLAG column — the term the user searched for — indicates the view distinguishes between aggregate percentage- or dollar-based category records and individual detailed cost lines, which is relevant when reconciling budget presentations in proposal reports.

Underlying Base Objects

The documented base objects referenced by the view are IGW_REPORT_BUDGET, IGW_BUDGET_PERIODS, IGW_BUDGETS, IGW_BUDGET_DETAILS, IGW_REPORT_BUDGET_SEED, and the shared lookup table FND_LOOKUPS. The ETRM metadata records no separate owner and lists no other base objects, though the definition clearly joins across these IGW tables.

The view is constructed as a UNION of two queries. The first query joins IGW_REPORT_BUDGET to IGW_BUDGET_PERIODS and IGW_BUDGETS, filtering budget categories through a subquery against IGW_REPORT_BUDGET_SEED that uses both BUDGET_CATEGORY_CODE and PROPOSAL_BUDGET_CATEGORY_CODE. The second query joins IGW_BUDGETS (restricted to the final version via FINAL_VERSION_FLAG = 'Y'), IGW_BUDGET_PERIODS, IGW_BUDGET_DETAILS, and FND_LOOKUPS, resolving BUDGET_CATEGORY_CODE to a meaning using the IGW_BUDGET_CATEGORY lookup type. Both branches align on PROPOSAL_ID, VERSION_ID, and BUDGET_PERIOD_ID, ensuring category and line-level records share a common period context.

Key Columns

  • PROPOSAL_ID — Identifier of the sponsored proposal to which the budget line belongs.
  • BUDGET_PERIOD_ID — Identifier of the budget period within the proposal version.
  • PERIOD_TYPE — Literal 'CC' emitted by both branches, denoting the period classification.
  • START_DATE — Start date of the budget period.
  • PROPOSAL_BUDGET_CATEGORY_CODE / PROPOSAL_BUDGET_CATEGORY — Budget category code and its descriptive meaning.
  • DESCRIPTION — Category description or line-item description.
  • PERIOD_TOTAL_DIRECT_COST — Direct cost total for the category period (first branch).
  • PERIOD_MONTHS — Literal 12 in both branches, indicating a twelve-month period assumption.
  • PERCENT_DOLLAR_FLAG — Set to NULL in the category branch and 'DO' in the detail branch, distinguishing aggregate category records from dollar-denominated line items.
  • EB_TOTAL — Employee-benefit total, populated in the category branch and NULL in the detail branch.

Common Use Cases and Queries

The view is used to report budget amounts by sponsor category and period, typically feeding proposal budget summaries or reconciliation reports. A representative query filtering category-level amounts is:

  • SELECT PROPOSAL_ID, BUDGET_PERIOD_ID, PROPOSAL_BUDGET_CATEGORY, PERIOD_TOTAL_DIRECT_COST, EB_TOTAL FROM IGW_PRPO_CATEGORY_AMTS_V WHERE PERCENT_DOLLAR_FLAG IS NULL;
  • SELECT PROPOSAL_ID, BUDGET_PERIOD_ID, DESCRIPTION, PERIOD_TOTAL_DIRECT_COST FROM IGW_PRPO_CATEGORY_AMTS_V WHERE PERCENT_DOLLAR_FLAG = 'DO';

The first query returns rolled-up category totals; the second returns detailed dollar line items. Because the module is obsolete and the view is documented as not implemented, these queries are relevant only for historical or legacy 12.1.1 / 12.2.2 environments where the IGW schema objects persist.