Results for “adw_notify_flag”

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

Overview

PA_ADW_RES_LISTS_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema and delivered under the Projects (PA) product family. Its documented purpose is to expose the values for resource lists on the resource dimension, making it a reporting-oriented interface over the underlying resource list definition. The view is catalogued as VALID in both ETRM 12.1.1 and 12.2.2 reference repositories, indicating that its definition has remained stable across these release levels.

The view is intended primarily for read access by Oracle Business Intelligence, Oracle Data Warehouse (ADW) extraction routines, and customer-built reports. It surfaces one row per resource list, presenting the list identifier, its descriptive attributes, ten generic user-defined columns, and a notification flag (ADW_NOTIFY_FLAG) that governs whether the record participates in resource-list change notifications. Because it is a view rather than a table, no direct DML should be issued against it; maintenance of resource lists is performed through the standard Projects forms and concurrent programs, which write to the underlying base tables.

Underlying Base Objects

The documented view text selects RESOURCE_LIST_ID, NAME, DESCRIPTION, USER_COL1 through USER_COL10, and ADW_NOTIFY_FLAG from PA_ADW_RES_LISTS_B_V. That base view is the immediate source of all columns, and it in turn resolves to the resource list definition tables and their translations. The ETRM metadata further records three referenced objects: PA_ADW_RES_LISTS_B_V (VIEW), FND_PROFILE (PACKAGE), and PA_CROSS_BUSINESS_GRP (PACKAGE).

• PA_ADW_RES_LISTS_B_V — the direct parent view supplying every projected column.
• FND_PROFILE — the profile option access package, invoked to apply profile-driven security or business-group context, most commonly the MO: Operating Unit or MO: Security Profile settings.
• PA_CROSS_BUSINESS_GRP — the Projects cross-business-group package, used to control visibility of records that span multiple operating units.

This layering means that query results are implicitly filtered by the caller's profile and business-group authorization, so two users may see different row sets from the same SELECT statement.

Key Columns

• RESOURCE_LIST_ID — the unique numeric identifier of the resource list; join key to resource list members and assignments.
• NAME — the user-visible resource list name.
• DESCRIPTION — free-form description of the list's purpose or scope.
• USER_COL1 – USER_COL10 — ten generic, customer-configurable columns reserved for descriptive flexfield or extension use.
• ADW_NOTIFY_FLAG — the flag of interest to the searching user, indicating whether the list should trigger ADW notification processing on change.

Common Use Cases and Queries

Typical scenarios include listing all resource lists for a user, identifying lists flagged for notification, and feeding downstream extracts. A representative query follows:

SELECT resource_list_id, name, adw_notify_flag
FROM   apps.pa_adw_res_lists_v
WHERE  adw_notify_flag = 'Y'
ORDER  BY name;

To retrieve the full descriptive payload, include the user columns. Because the view respects profile and cross-business-group security, no additional WHERE clause for operating unit is normally required, but a report that aggregates across organizations must be run under a profile with the appropriate security scope.