Search Results control_flag

Overview

PA_RESOURCE_LISTS_R is a Projects (PA) module view that presents resource list definitions for a business group as configured in implementation options. Resource lists in Oracle Projects are named collections of people, organizations, jobs, and other resource types used for assignment, planning, and reporting. This view consolidates header-level resource list data from the base storage table with the translatable name and description, resolving the correct language row based on the session language.

The view is a reporting and integration convenience layer. Its defining characteristic is business group enforcement: the WHERE clause restricts returned rows to the session business group unless the ISCROSSBGPROFILE profile option is set to 'Y', in which case rows across all business groups are returned. This makes the view suitable for exposing resource list metadata to reports, concurrent programs, and external interface extracts that must respect the operating business group.

The CONTROL_FLAG column, of particular interest to users searching on that term, participates in the resource list definition and is exposed at the view level for downstream consumers.

Underlying Base Objects

The view is defined over two base objects referenced in its text:

PA_RESOURCE_LISTS_ALL_BG — the primary storage table holding resource list header rows across business groups, including flags, dates, and audit columns.
PA_RESOURCE_LISTS_TL — the translatable table supplying NAME and DESCRIPTION for the session language.

The join is RTL.RESOURCE_LIST_ID = R.RESOURCE_LIST_ID combined with RTL.LANGUAGE = USERENV('LANG'), ensuring only the current language translation is returned. Business group filtering is applied through PA_UTILS.BUSINESS_GROUP_ID and PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE. The ETRM documentation notes that no base objects are formally registered for this view and that it is not implemented in the reference database, so DBAs should confirm availability in their instance prior to dependency creation.

Key Columns

RESOURCE_LIST_ID — primary identifier of the resource list.
NAME and DESCRIPTION — language-specific labels from the TL table.
PUBLIC_FLAG — indicates whether the list is available to all users or restricted.
GROUP_RESOURCE_TYPE_ID — resource type grouping associated with the list.
CONTROL_FLAG — control indicator used in resource list management logic.
START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the list.
UNCATEGORIZED_FLAG, USE_FOR_WP_FLAG, ADW_NOTIFY_FLAG — behavioral flags governing category handling, workplan usage, and notifications.
JOB_GROUP_ID, RESOURCE_LIST_TYPE — job group and list type classification.
BUSINESS_GROUP_ID — owning business group.
MIGRATION_CODE, RECORD_VERSION_NUMBER, MIGRATED_RBS_VERSION_ID — migration and versioning metadata.
Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include listing active resource lists for the current business group, filtering by control or public flags, and validating resource list availability before assignment in planning or staffing integrations.

List active resource lists: SELECT resource_list_id, name, control_flag FROM pa_resource_lists_r WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
Filter by control flag: append AND control_flag = 'Y' to isolate lists subject to control logic.
Cross-business-group reporting: relies on the ISCROSSBGPROFILE profile setting; set to 'Y' for enterprise-wide extracts.

The view should be used for read access to resource list definitions only; DML is not supported.

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.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.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.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 ,