Results for “subobject_type_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_CONFIG_LISTS_V is a Projects (PA) module view that exposes configurable list definitions used throughout Oracle Projects. Configurable lists allow end users to define reusable sets of values that drive pick lists, defaults, and controlled selections on project-related forms and concurrent processes. The view is a thin projection over the PA_CONFIG_LISTS base table, exposing forty-one columns without joins, filters, or derived logic other than NVL defaults applied to the DEFAULT_FLAG and PUBLIC_FLAG columns.

Because it carries the PUBLIC_FLAG column, the view is frequently queried to distinguish lists that are private to a single user from lists that have been published for broader, organization-wide consumption. Public lists can be referenced by other users and by seeded functionality, while private lists are scoped to the USER_ID that created them. This distinction makes the view relevant to both functional reporting and integration extracts where list visibility must be reconciled.

The view is documented in ETRM at the 12.2.2 level. Under 12.1.1 the same underlying configuration model applies; the view text and column list presented here are consistent with the Projects configuration framework shared across both releases.

Underlying Base Objects

The view is defined over a single base table, PA_CONFIG_LISTS. No join, union, or subquery is present in the view text, and ETRM does not document any additional referenced base objects. Consequently, the view inherits the row population of PA_CONFIG_LISTS directly, subject only to the two NVL transformations on the flag columns.

ETRM notes that this object is "Not implemented in this database" in the documented environment. That status indicates the view may not exist in every instance, particularly in environments where the Projects configuration feature set has not been installed or where the object was superseded. Implementers should verify existence in ALL_VIEWS or DBA_VIEWS before referencing the view in custom code or extracts.

Key Columns

• LIST_ID — Primary identifier for the configurable list definition.
• USER_ID — Owner of the list. Combined with PUBLIC_FLAG, determines who may see and use the list.
• OBJECT_ID — Identifier of the business object to which the list is attached, scoping the list to a specific functional area.
• LIST_NAME / DESCRIPTION — User-facing name and description of the list.
• DEFAULT_FLAG — Indicates the default list for a given object/user context; exposed with an NVL to 'N'.
• PUBLIC_FLAG — Indicates whether the list is published for shared use; exposed with an NVL to 'N'. This is the column referenced by searches for list visibility.
• SUBOBJECT_TYPE_CODE — Further granularity identifying the sub-type of the object the list serves.
• RECORD_VERSION_NUMBER — Optimistic locking counter maintained by the configuration framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments available for client-specific extension.

Common Use Cases and Queries

Typical use cases include identifying all public lists for a given object, auditing who owns private versus public lists, and extracting list metadata for migration or reconciliation between environments.

SELECT list_id, list_name, user_id, public_flag, default_flag
FROM   pa_config_lists_v
WHERE  public_flag = 'Y'
ORDER BY list_name;

SELECT list_id, list_name, user_id
FROM   pa_config_lists_v
WHERE  public_flag = 'N'
AND    user_id = :p_user_id;

SELECT list_id, list_name, default_flag
FROM   pa_config_lists_v
WHERE  object_id = :p_object_id
AND    subobject_type_code = :p_subobject_type;

Because the view performs no joins, queries against it are inexpensive and safe for reporting. However, all filters on PUBLIC_FLAG should be aware that the NVL converts nulls to 'N', so null-valued records are reported as private, not unknown.