Search Results uncategorized_flag

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

RESOURCE_LIST_ID / ROW_ID — unique identifiers for the resource list.
NAME / DESCRIPTION — the display name and descriptive text of the resource list.
RESOURCE_LIST_TYPE — classification of the resource list, indicating the type or purpose of the list within project resource management.
PUBLIC_FLAG — indicates whether the list is available to all users or restricted.
GROUP_RESOURCE_TYPE_ID — the resource type grouping associated with the list.
START_DATE_ACTIVE / END_DATE_ACTIVE — the active date range of the resource list.
UNCATEGORIZED_FLAG — indicates whether the list contains uncategorized resources.
MIGRATION_CODE — migration-related code for the list.
BUSINESS_GROUP_ID — the business group to which the list belongs.
ADW_NOTIFY_FLAG / JOB_GROUP_ID — notification and job group references.
Audit columns — LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

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.

View: PA_RESOURCE_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_V, object_name:PA_RESOURCE_LISTS_V, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_V ,
View: PA_RESOURCE_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_V, object_name:PA_RESOURCE_LISTS_V, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_V ,
View: PA_BUDGET_RESOURCE_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_RESOURCE_LISTS_V, object_name:PA_BUDGET_RESOURCE_LISTS_V, status:VALID, product: PA - Projects , description: 10Sc Only , implementation_dba_data: APPS.PA_BUDGET_RESOURCE_LISTS_V ,
View: PA_BUDGET_RESOURCE_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_RESOURCE_LISTS_V, object_name:PA_BUDGET_RESOURCE_LISTS_V, status:VALID, product: PA - Projects , description: 10Sc Only , implementation_dba_data: APPS.PA_BUDGET_RESOURCE_LISTS_V ,
View: PA_RESOURCE_LISTS_R 12.2.2
product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: Not implemented in this database ,
View: PA_RESOURCE_LISTS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_VL, object_name:PA_RESOURCE_LISTS_VL, status:VALID, product: PA - Projects , description: View that displays all resource lists Comprehensive Description : View that displays all resource lists irrespective of the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_VL ,
View: PA_RESOURCE_LISTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS, object_name:PA_RESOURCE_LISTS, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS ,
View: PA_RESOURCE_LISTS_R 12.1.1
product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: Not implemented in this database ,
View: PA_RESOURCE_LISTS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_VL, object_name:PA_RESOURCE_LISTS_VL, status:VALID, product: PA - Projects , description: View that displays all resource lists Comprehensive Description : View that displays all resource lists irrespective of the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_VL ,
View: PA_RESOURCE_LISTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS, object_name:PA_RESOURCE_LISTS, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS ,