Search Results view_labor_costs_allowed




Overview
Explore in AI Chat

Overview

GMS_STATUS_PROJ_GENERIC_V is an APPS-owned database view in the Oracle E-Business Suite Grants Accounting (GMS) module, validated against releases 12.1.1 and 12.2.2. It exposes a generic, project-status-oriented projection that supplements the standard Oracle Projects status view with grants-specific semantics, most notably a revenue budget type code and a labor cost allowance flag. The view is intended to support reporting and integration scenarios in which grant and award projects must be presented alongside their budget configuration and costing controls without exposing the full PA_PROJECTS record set.

The view functions as a filtered layer over PA_STATUS_PROJ_GENERIC_V. Because the filter excludes award projects, it is primarily useful for reporting on sponsored (non-award) grant structures, internal projects, and dependent project hierarchies where a generic status presentation is required.

Underlying Base Objects

The documented base objects referenced by this view are PA_PROJECTS (resolved through a synonym), the PA_SECURITY and PA_STATUS packages, and PA_STATUS_PROJ_GENERIC_V (VIEW). The definition selects from PA_STATUS_PROJ_GENERIC_V and applies an anti-join against PA_PROJECTS:

  • PA_STATUS_PROJ_GENERIC_V — supplies PROJECT_ID and the generic status column set, including VIEW_LABOR_COSTS_ALLOWED, COST_BUDGET_TYPE_CODE, REV_BUDGET_TYPE_CODE, and COLUMN1 through COLUMN33.
  • PA_PROJECTS — used in a NOT EXISTS subquery to exclude rows whose PROJECT_TYPE equals 'AWARD_PROJECT'.
  • PA_SECURITY — package providing project-level security enforcement applied through the underlying status view.
  • PA_STATUS — package encapsulating project status derivation logic surfaced by the generic view.

The anti-join is the defining filter: only project records that are not classified as award projects survive into GMS_STATUS_PROJ_GENERIC_V.

Key Columns

  • PROJECT_ID — Surrogate project identifier; the primary join key back to PA_PROJECTS and other project-centric tables.
  • REV_BUDGET_TYPE_CODE — The revenue budget type code associated with the project, directly relevant to the search term "rev_budget_type_code". This column indicates which budget type is used for revenue budgeting purposes, for example the code identifying the revenue plan configuration on the grant.
  • COST_BUDGET_TYPE_CODE — The corresponding budget type code applied to cost budgeting, paired with the revenue code to give a complete budget-type picture.
  • VIEW_LABOR_COSTS_ALLOWED — A flag indicating whether labor costs may be viewed for the project, governing visibility of labor-related cost information.
  • COLUMN1–COLUMN33 — Generic, positionally-numbered columns inherited from PA_STATUS_PROJ_GENERIC_V. These represent the flexible, configurable status attribute slots populated by the underlying status framework.

Common Use Cases and Queries

The most frequent use is locating projects by their revenue budget type configuration and auditing cost/revenue budget pairing across grant portfolios:

  • Reporting the revenue and cost budget type codes for all non-award project records.
  • Verifying labor cost viewing allowances for grant status reporting.
  • Feeding integration extracts where an award-project-free dataset is required.

Sample SQL:

SELECT project_id, rev_budget_type_code, cost_budget_type_code, view_labor_costs_allowed
FROM apps.gms_status_proj_generic_v
WHERE rev_budget_type_code IS NOT NULL;

Because the view applies PA_SECURITY through its underlying definition, results are inherently restricted to projects the querying responsibility is authorized to access.