Search Results pa_work_types_vl




Overview
Explore in AI Chat

Overview

PA_WORK_TYPES_VL is a bilingual (language-specific) view owned by the APPS schema in Oracle E-Business Suite, defined within the Projects (PA) product family. It presents implementation-defined work types, which classify the nature of work performed on projects and form the basis of resource assignment, utilization, billing, and capitalization decisions across the Projects application. The view exposes both descriptive attributes and control flags that govern how associated expenditure is treated.

The "_VL" suffix indicates that this is a multi-language view, joining translated and base data so that the NAME and DESCRIPTION columns are returned in the session's language. In practice, Oracle EBS applications and reports reference PA_WORK_TYPES_VL rather than the underlying base or translation tables directly, making it the primary read interface for work type data in custom reports, integrations, and OBIEE/BI Publisher extracts. Its status is documented as VALID in both 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

  • PA_WORK_TYPES_B — the base table holding language-independent columns, aliased as B in the view text.
  • PA_WORK_TYPES_TL — the translation table holding language-specific NAME and DESCRIPTION, aliased as T.

The join condition is B.WORK_TYPE_ID = T.WORK_TYPE_ID AND T.LANGUAGE = USERENV('LANG'), restricting the translation rows to the language of the current session. The view also surfaces B.ROWID as ROW_ID, enabling row identification for update processing in certain Oracle Forms-based flows.

Key Columns

Common Use Cases and Queries

Typical uses include validating active work types before assignment, driving utilization and capacity reporting, and extracting work type lists for downstream integrations. A representative query returns active, session-language work types:

SELECT work_type_id,
       name,
       description,
       billable_capitalizable_flag,
       reduce_capacity_flag,
       res_utilization_percentage,
       org_utilization_percentage
FROM   pa_work_types_vl
WHERE  start_date_active <= TRUNC(SYSDATE)
AND    (end_date_active IS NULL OR end_date_active >= TRUNC(SYSDATE))
ORDER BY name;

Because NAME and DESCRIPTION are resolved through the translation table, no explicit LANGUAGE condition is required in consuming queries; the view applies USERENV('LANG') automatically. When auditing configuration changes or querying flexfield data, joining WORK_TYPE_ID back to PA_WORK_TYPES_B or to project and assignment tables provides full context.