Search Results grouped_by_resource_type_id




Overview
Explore in AI Chat

Overview

APPS.PA_QRY_RESOURCE_LISTS_V is a query-only database view owned by the APPS schema and registered under the Oracle E-Business Suite FND Design Data as PA.PA_QRY_RESOURCE_LISTS_V. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. The view exposes resource list definitions used by Oracle Projects (PA) to control which resources — employees, jobs, organizations, or other resource types — are available within project planning, resource management, and budgeting contexts. Because its name is prefixed with the PA query convention (QRY), it is intended for reporting, inquiry, and integration purposes rather than for transactional processing.

The object carries an explicit Oracle warning: it is designated Oracle Internal Use Only, and Oracle Corporation does not support direct access to its data except from standard Oracle Applications programs. Any custom or third-party consumer of this view should treat it as an unsupported interface and guard against structural change across patches or upgrades. The GROUPED_BY_RESOURCE_TYPE_NAME column, which prompted the search that led to this object, provides the user-facing descriptive label for the resource grouping dimension and is the most human-readable attribute in the view.

Underlying Base Objects

The view resolves through four documented referenced objects:

  • PA_RESOURCE_LISTS (view) — the primary source of resource list header information, including name, description, effective dates, and control flags.
  • PA_RESOURCE_GROUPS_VALID_V (view) — supplies the resource group membership and the resource type classification used to derive the grouping columns.
  • PA_CROSS_BUSINESS_GRP (package) — resolves cross-business-group (multi-organization) security behavior so that only resource lists in the operating units accessible to the session are returned.
  • FND_PROFILE (package) — supports profile option lookups used for security and defaulting logic within the view definition.

The dependency on PA_CROSS_BUSINESS_GRP means results are filtered by the MO: Operating Unit and related security profiles, so identical queries can return different row sets depending on the responsibility and organization context of the connecting user.

Key Columns

  • RESOURCE_LIST_ID (NUMBER 15) — the unique surrogate key for a resource list; the join key to any dependent object.
  • RESOURCE_LIST_NAME (VARCHAR2 240) — the descriptive name of the resource list.
  • GROUPED_BY_RESOURCE_TYPE (VARCHAR2 30) — the internal lookup code for the resource type by which the list is grouped.
  • GROUPED_BY_RESOURCE_TYPE_NAME (VARCHAR2 80) — the translated display name corresponding to that code; this is the column referenced in the search term.
  • GROUPED_BY_RESOURCE_TYPE_ID (NUMBER) — the numeric identifier of the resource type grouping.
  • DESCRIPTION (VARCHAR2 2000) — free-text description of the resource list.
  • START_DATE / END_DATE (DATE) — the effective date range governing when the list is active.
  • RESOURCE_CONTROL_FLAG (VARCHAR2) — indicates whether the list enforces resource control, restricting additions to members of the list.

Common Use Cases and Queries

Typical uses include validating resource list configuration, auditing lists grouped by a particular resource type, and feeding downstream reporting or integration extracts. Because the view is unsupported for direct access, such usage should be read-only.

To retrieve all resource lists with their grouping labels:

  • SELECT RESOURCE_LIST_ID, RESOURCE_LIST_NAME, GROUPED_BY_RESOURCE_TYPE_NAME, START_DATE, END_DATE, RESOURCE_CONTROL_FLAG FROM APPS.PA_QRY_RESOURCE_LISTS_V ORDER BY RESOURCE_LIST_NAME;

To filter on the searched attribute and identify controlled lists:

  • SELECT RESOURCE_LIST_NAME, GROUPED_BY_RESOURCE_TYPE_NAME, DESCRIPTION FROM APPS.PA_QRY_RESOURCE_LISTS_V WHERE GROUPED_BY_RESOURCE_TYPE_NAME = 'Employee' AND RESOURCE_CONTROL_FLAG = 'Y';

To isolate currently effective lists for an as-of validation:

  • SELECT RESOURCE_LIST_ID, RESOURCE_LIST_NAME FROM APPS.PA_QRY_RESOURCE_LISTS_V WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE + 1);

The view is referenced by PA_PMC_RESOURCE_LISTS_V, confirming its role as a supporting layer beneath higher-level Projects resource list views.