Search Results pa_resource_types_active_v




Overview
Explore in AI Chat

Overview

PA_RESOURCE_TYPES_ACTIVE_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes resource type definitions from the PA_RESOURCE_TYPES table, filtered so that only currently active resource types are returned. The view is documented in the ETRM metadata as "10Sc only," indicating that its scope is limited to the 10Sc (Oracle Projects) offering rather than the broader Enterprise Project portfolio.

Functionally, the view answers a recurring question in Projects reporting and integration: which resource types may legitimately be used today? Because it applies a TRUNC(SYSDATE) predicate against the activation date range, consumers do not need to replicate date logic themselves. The presence of the GROUP_FLAG column — the term the user searched for — makes this view particularly relevant when distinguishing grouped resource types from individually maintained ones.

Underlying Base Objects

The view is defined over a single referenced base object, PA_RESOURCE_TYPES (accessed through a synonym). The view text is:

SELECT RESOURCE_TYPE_ID, NAME, RESOURCE_CLASS_CODE, RESOURCE_TYPE_CODE, GROUP_FLAG,
       DESCRIPTION, TABLE_NAME, ACCESS_KEY, SQL_TEXT
  FROM PA_RESOURCE_TYPES
 WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, TRUNC(SYSDATE))

The view is therefore a thin projection plus a row filter: no joins, unions, or aggregations are involved. The active-date window is evaluated at query time, so a resource type that expires is immediately excluded on the next execution. Note the metadata's slight naming discrepancy — the view selects the column NAME, while the documented column list refers to it as RESOURCE_TYPE_NAME. In practice the projection is the underlying column name, and callers should reference the actual column exposed by the view when writing SQL.

Key Columns

  • RESOURCE_TYPE_ID — Primary identifier for the resource type; the standard foreign key used across PA tables.
  • NAME (documented as RESOURCE_TYPE_NAME) — Descriptive name of the resource type.
  • RESOURCE_CLASS_CODE — Class the resource type belongs to, such as people, expenditure categories, or organizations.
  • RESOURCE_TYPE_CODE — Short code identifying the resource type.
  • GROUP_FLAG — Indicates whether the resource type represents a grouping construct. Consumers use this flag to separate aggregate or group-level resource types from base, individually assigned ones.
  • DESCRIPTION — Free-text description of the resource type.
  • TABLE_NAME — Backing table associated with the resource type for its implementation.
  • ACCESS_KEY — Access key used in the resource type's definition.
  • SQL_TEXT — SQL fragment associated with the resource type definition.

Common Use Cases and Queries

Typical uses include validating resource type selections on project or assignment interfaces, populating list-of-values queries in extensions, and reporting on the currently available resource type inventory. Filtering by GROUP_FLAG is common where a report must exclude grouped resource types.

List all active resource types:

SELECT resource_type_id, name, resource_class_code, group_flag
  FROM apps.pa_resource_types_active_v;

Identify active group-level resource types only:

SELECT resource_type_id, name, resource_class_code
  FROM apps.pa_resource_types_active_v
 WHERE group_flag = 'Y';

Confirm a specific resource type is currently active before use in an integration:

SELECT COUNT(*)
  FROM apps.pa_resource_types_active_v
 WHERE resource_type_id = :p_resource_type_id;

Because the view already enforces the active-date window, no additional date predicate is required in these queries.