Search Results pa_projects_u2

Overview

APPS.GMS_PROJECTS_V is a Grants Accounting (GMS) reporting view that presents a filtered, consolidated projection of project master data. It is defined in the APPS schema with VALID status and is documented in ETRM for Oracle EBS 12.1.1 and 12.2.2. Functionally, the view exposes the set of projects that are used in the grants lifecycle while excluding records designated as award-level containers. This distinction is important because GMS maintains award headers and their associated funded projects within the same underlying project tables; consumers of GMS_PROJECTS_V receive only the project records that carry actual budgeting, costing, and expenditure activity.

The view therefore acts as a stable, read-only interface for reports, concurrent programs, and external integrations that need a compact project listing without the full width or unrestricted row set of the underlying project views. Because it selects only ten attributes grouped by project identity, it is inexpensive to join to fact-style objects such as expenditure, budget, and commitment tables, and it hides the award-versus-project filtering rule from downstream code.

Underlying Base Objects

The view text is defined over a single base object with a hint that forces access through the PA_PROJECTS_U2 index:

• PA_PROJECTS_EXPEND_V (VIEW) — The immediate source of all projected columns. GMS_PROJECTS_V is a filtered and grouped selection from this Projects view, restricted by the predicate PROJECT_TYPE <> 'AWARD_PROJECT'.
• PA_PROJECT_UTILS (PACKAGE) — A documented referenced object, used within the Projects logic for project-level derivations and validations.
• PA_CROSS_BUSINESS_GRP (PACKAGE) — Supplies cross-business-group security and organizational context for project access.
• FND_PROFILE (PACKAGE) — Provides profile option values, notably operating unit and security context, referenced during resolution of the underlying project view.

All objects reside in the APPS schema. The dependency chain runs from GMS_PROJECTS_V to PA_PROJECTS_EXPEND_V and from there to the Projects base tables and the supporting PL/SQL packages.

Key Columns

• PROJECT_ID — Primary surrogate key of the project; the standard join key to PA_PROJECTS and all project-owned transactions.
• PROJECT_NUMBER — User-facing project number used for entry, lookup, and reconciliation.
• PROJECT_NAME — Descriptive project name shown on reports and LOVs.
• START_DATE / COMPLETION_DATE — Project lifecycle boundaries used for date-range filtering and period validation.
• PROJECT_CURRENCY_CODE — Currency in which the project is denominated.
• PROJECT_OU — Owning operating unit, providing multi-org context and security partitioning.
• PROJECT_TYPE_CLASS_CODE — Classification of the project type, supporting grouping of sponsored versus internal projects.
• PROJECT_DESCRIPTION — Free-text narrative attribute.
• PROJFUNC_CURRENCY_CODE — Project functional currency, used for reporting and rate conversion.

The GROUP BY clause includes every projected column, which guarantees row uniqueness per project and suppresses duplication introduced by joins inside the underlying Projects view.

Common Use Cases and Queries

Typical uses include grants project LOVs, custom project listings for sponsored-program reporting, data extracts for downstream warehouses, and validation queries that confirm which projects are visible to a grants responsibility. A representative query joining the view to expenditure data follows:

• SELECT p.project_number, p.project_name, p.start_date, p.completion_date FROM apps.gms_projects_v p WHERE p.project_ou = :p_org_id ORDER BY p.project_number;
• SELECT p.project_id, p.project_number, SUM(e.burdened_cost) FROM apps.gms_projects_v p, apps.pa_expenditures_all e WHERE e.project_id = p.project_id GROUP BY p.project_id, p.project_number;
• SELECT project_type_class_code, COUNT(*) FROM apps.gms_projects_v GROUP BY project_type_class_code;

Because the view excludes award-level records, users searching for PA_PROJECTS_EXPEND_V should understand that GMS_PROJECTS_V is the grants-oriented subset of that Projects view and will not return award containers.