Search Results pa_resource_lists_v




Overview
Explore in AI Chat

Overview

PA_RESOURCE_LISTS_V is an Oracle Applications (APPS) view owned by the Projects (PA) module. It presents resource list definitions for a business group in Oracle E-Business Suite release 12.1.1 and 12.2.2, and is primarily consumed when configuring implementation options and validating the resource lists available to a given operating unit. A resource list groups people, organizations, and roles (job/position assignments) so that they can be assigned as project resources and required for project and task staffing, budgeting, and cost rate derivation.

The view is a secured, business-group-filtered read layer over the resource list tables. Its defining text selects from PA_RESOURCE_LISTS_VL and applies a WHERE clause that either restricts rows to the current business group — using PA_UTILS.BUSINESS_GROUP_ID when the cross-business-group profile option is not enabled — or returns all business groups when PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y'. This makes the view a reliable, MOAC-aware source for reporting and integration interfaces that must respect the user's business group context.

Analysts searching for resource_list_type encounter this view because it exposes the RESOURCE_LIST_TYPE column, which classifies the nature of each resource list and drives how the list behaves in project staffing and planning.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PA_RESOURCE_LISTS_VL (view) — the multi-language base view that stores the translatable and non-translatable resource list attributes, including resource list ID, name, description, dates, flags, business group, and resource list type.
  • PA_CROSS_BUSINESS_GRP (package) — supplies the ISCROSSBGPROFILE value used to determine whether the query is limited to the current business group or spans all business groups.
  • PA_UTILS (package) — supplies BUSINESS_GROUP_ID, the current user's business group identifier used for row filtering.

Because the view is defined on top of a VL (translated) view, it exposes the linguistic row appropriate to the session language while preserving the underlying resource list identifiers.

Key Columns

Common Use Cases and Queries

Typical uses include reporting the resource lists available to a business group, verifying resource list type classifications, and integrating resource list data into external planning or staffing systems. A sample query filtering by resource list type:

SELECT resource_list_id,
       name,
       description,
       resource_list_type,
       public_flag,
       business_group_id,
       start_date_active,
       end_date_active
FROM   apps.pa_resource_lists_v
WHERE  resource_list_type = :p_resource_list_type
AND    NVL(end_date_active, SYSDATE + 1) > SYSDATE
ORDER BY name;

Because the view already enforces the business group and cross-business-group security logic, consumers should query it rather than the underlying VL view directly when access control is required.