Search Results pa_pmc_resource_lists_v




Overview
Explore in AI Chat

Overview

The PA_PMC_RESOURCE_LISTS_V view is a Projects (PA) module database object residing in the APPS schema. It is a wrapper view whose stated purpose is to allow WebConnect to retrieve all resource lists defined within Oracle Projects. In Oracle EBS releases 12.1.1 and 12.2.2, the view exposes resource list header information — including name, identifier, grouping attribute, description, and effective date range — in a form suitable for consumption by external or web-based integration layers. Rather than re-implementing the selection logic against the underlying resource list tables, the view delegates to PA_QRY_RESOURCE_LISTS_V, providing a stable interface that shields callers from changes in the base query definition.

Underlying Base Objects

The view text defines PA_PMC_RESOURCE_LISTS_V as a straightforward projection over PA_QRY_RESOURCE_LISTS_V, aliased as RL, from which all eight exposed columns are selected without transformation. The documented referenced base objects for this view are PA_QRY_RESOURCE_LISTS_V (VIEW), PA_CROSS_BUSINESS_GRP (PACKAGE), and FND_PROFILE (PACKAGE). The two packages are referenced indirectly through the query view's own logic — FND_PROFILE typically supplies the current business group or operating unit context, while PA_CROSS_BUSINESS_GRP supports cross-business-group security filtering. Because PA_PMC_RESOURCE_LISTS_V itself contains no WHERE clause, filtering, security, and organizational scoping are inherited entirely from PA_QRY_RESOURCE_LISTS_V. Consequently, the rows returned depend on the profile and business group settings in effect for the session at query time.

Key Columns

  • RESOURCE_LIST_NAME — The user-defined name of the resource list.
  • RESOURCE_LIST_ID — The unique system identifier for the resource list; the primary join key for related detail objects.
  • GROUPED_BY_RESOURCE_TYPE — The resource type grouping indicator (for example, whether the list is grouped by expenditure type or by another resource classification).
  • GROUPED_BY_RESOURCE_TYPE_NAME — The descriptive name corresponding to the grouping indicator.
  • GROUPED_BY_RESOURCE_TYPE_ID — The identifier of the resource type used for grouping.
  • DESCRIPTION — Free-text description attached to the resource list.
  • START_DATE — The date from which the resource list becomes effective.
  • END_DATE — The date on which the resource list ceases to be effective.

Common Use Cases and Queries

The view is typically queried by WebConnect or similar integration components that need to enumerate resource lists without directly touching the query view. A common pattern is to retrieve all lists or a specific list by identifier:

  • Listing all available resource lists: SELECT resource_list_id, resource_list_name FROM pa_pmc_resource_lists_v ORDER BY resource_list_name;
  • Resolving a list by name: SELECT resource_list_id, description FROM pa_pmc_resource_lists_v WHERE resource_list_name = :p_name;
  • Determining active lists for a given date: SELECT resource_list_id, resource_list_name FROM pa_pmc_resource_lists_v WHERE :p_date BETWEEN start_date AND NVL(end_date, :p_date);
  • Filtering by grouping type: SELECT resource_list_name, grouped_by_resource_type_name FROM pa_pmc_resource_lists_v WHERE grouped_by_resource_type_id = :p_type_id;

Because results are scoped by profile and business group logic inside PA_QRY_RESOURCE_LISTS_V, callers should not assume an unfiltered global result set. For detail-level resource membership, the returned RESOURCE_LIST_ID is used to join to the corresponding resource list member views or tables. As with any APPS-schema view, access is granted through standard Oracle EBS responsibility and security configuration.