Results for “pa_resource_classes_vl”

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

Overview

PA_RESOURCE_CLASSES_VL is a seeded, VALID view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) product family and exposes information about predefined resource classes in Oracle Projects. Resource classes are the high-level categories — such as People, Equipment, and Financial Elements — into which project resources are grouped and against which resource-level cost rates, billing rates, and utilization rules are defined. The view presents a translated, language-aware perspective on resource class definitions, so reports, concurrent programs, and PL/SQL validation logic can retrieve the resource class name and description in the session's language rather than the base-table language.

As a "_VL" (View with Language) object, it follows the standard Oracle EBS MLS (Multi-Language Support) pattern, exposing a single logical row per resource class with translated NAME and DESCRIPTION columns. It is a query-only object intended for reporting and integration; inserts and updates must be directed to the underlying _B and _TL tables through the supported Oracle Projects APIs and forms.

Underlying Base Objects

The view is defined over two documented base objects, referenced in the ETRM metadata as synonyms:

• PA_RESOURCE_CLASSES_B — the base table holding language-independent attributes, including the primary key RESOURCE_CLASS_ID, the RESOURCE_CLASS_CODE, ordering sequence, and the standard WHO audit columns.
• PA_RESOURCE_CLASSES_TL — the translation table holding NAME and DESCRIPTION for each installed language, keyed by RESOURCE_CLASS_ID and LANGUAGE.

The view text joins these two tables on RESOURCE_CLASS_ID and restricts the translation with the predicate T.LANGUAGE = USERENV('LANG'), which resolves to the language of the current session. The SELECT list also carries the base table ROWID as ROW_ID. Because the join is on the primary key of the _B table and the language-restricted row of the _TL table, the view returns exactly one row per resource class for the active session language.

Key Columns

• ROW_ID — the ROWID of the underlying PA_RESOURCE_CLASSES_B row; useful for row-level identification and for locking patterns in custom code.
• RESOURCE_CLASS_ID — the internal primary key and the foreign key referenced by many other Projects entities (for example, resource definitions and rate schedules).
• RESOURCE_CLASS_CODE — the user-visible short code for the resource class, commonly used in lookups and interfaces.
• RESOURCE_CLASS_SEQ — the display sequence controlling ordering of resource classes in list-of-values windows.
• NAME — the translated resource class name from PA_RESOURCE_CLASSES_TL.
• DESCRIPTION — the translated description of the resource class.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns inherited from the base table.

Common Use Cases and Queries

Typical usage centers on resolving a RESOURCE_CLASS_ID to a display name, populating report parameters or LOVs, and joining resource class codes to transactional project data. A basic query retrieving all classes in the session language is:

SELECT resource_class_id,
       resource_class_code,
       name,
       description
FROM   apps.pa_resource_classes_vl
ORDER BY resource_class_seq;

A frequent pattern is a lookup by code or by ID during interface validation:

SELECT name
FROM   apps.pa_resource_classes_vl
WHERE  resource_class_code = 'PEOPLE';

Because NAME and DESCRIPTION are translated, the same SQL returns language-appropriate text without requiring an explicit join to the _TL table, which simplifies custom reports and integrations. Analysts should note that the view is read-only and that translations depend on the session language; environments with multiple installed languages will return different NAME values for the same RESOURCE_CLASS_ID depending on USERENV('LANG').