Search Results pa_qry_resource_lists_v




Overview
Explore in AI Chat

Overview

PA_QRY_RESOURCE_LISTS_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema within the Projects (PA) product family. In Oracle EBS 12.1.1 and 12.2.2, resource lists are reusable groupings of resource types and resource group members that drive role-based assignment, resource searching, and resource control within Project Management and related project resource workflows. This view presents all currently valid resource lists that have been defined, deliberately filtering out the special internal "uncategorized" resource list so that end users and downstream components only see functional, business-facing lists.

The object is read-only by design. It is a query-only construct intended for Oracle Forms LOVs, concurrent reporting, and external integrations rather than for transactional inserts. Because it joins the valid resource group definitions to each resource list, the view resolves the grouping identifier into a human-readable name, which is precisely the kind of denormalized presentation that reporting layers require. Records are governed by the standard date-effectivity fields, so a resource list that has expired or has not yet started is still visible unless an explicit date filter is applied. The view is validated in the APPS schema, and its documented metadata is registered in ETRM for both 12.1.1 and 12.2.2.

Underlying Base Objects

The view text is a two-object join:

  • PA_RESOURCE_LISTS RL — the primary source of resource list header records, including name, description, effectivity dates, control flag, and the grouping resource type identifier.
  • PA_RESOURCE_GROUPS_VALID_V RG — a companion view supplying the valid resource group code and its display name. The join predicate is the GROUP_RESOURCE_TYPE_ID column, guaranteeing that only resource lists whose grouping type is itself valid are returned.

In addition, the ETRM metadata for 12.2.2 records the following referenced base objects: PA_CROSS_BUSINESS_GRP (PACKAGE), FND_PROFILE (PACKAGE), PA_RESOURCE_GROUPS_VALID_V (VIEW), and PA_RESOURCE_LISTS (VIEW). The package references reflect the standard Oracle EBS cross-business-group security model: queries against the view can be filtered so that users only see resource lists belonging to the business groups for which their MO: Operating Unit and security profiles grant access. PA_RESOURCE_LISTS is exposed through the view and effectively serves as the header table, while PA_RESOURCE_GROUPS_VALID_V supplies the group-level attributes.

Key Columns

Common Use Cases and Queries

Typical usage includes populating resource list LOVs on project resource assignment forms, validating list identifiers in integrations, and generating reports of active and expired resource lists. A developer or report author can also confirm visibility rules imposed by the uncategorized-flag predicate.

  • List all valid resource lists:
    SELECT resource_list_name, grouped_by_resource_type_name, start_date, end_date FROM apps.pa_qry_resource_lists_v ORDER BY resource_list_name;
  • Retrieve a single list by identifier:
    SELECT * FROM apps.pa_qry_resource_lists_v WHERE resource_list_id = :p_list_id;
  • Identify lists active as of a given date:
    SELECT resource_list_name, resource_control_flag FROM apps.pa_qry_resource_lists_v WHERE TRUNC(:p_effective_date) BETWEEN start_date AND NVL(end_date, TRUNC(:p_effective_date)) ORDER BY resource_list_name;
  • Group counts by grouping resource type:
    SELECT grouped_by_resource_type_name, COUNT(*) FROM apps.pa_qry_resource_lists_v GROUP BY grouped_by_resource_type_name;

Because the view already excludes uncategorized lists and enforces group validity through its join, these queries return a clean, business-meaningful result set with no additional filtering required beyond standard operating unit security applied at the application layer.