Search Results training_flag

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

• WORK_TYPE_ID — primary key of the work type; the join key to both base tables and the foreign key referenced by project, assignment, and expenditure records.
• NAME / DESCRIPTION — language-specific identifying and descriptive text sourced from PA_WORK_TYPES_TL.
• BILLABLE_CAPITALIZABLE_FLAG — indicates whether work of this type may be billed and/or capitalized.
• REDUCE_CAPACITY_FLAG — controls whether assignments of this work type reduce resource capacity for utilization purposes.
• RES_UTILIZATION_PERCENTAGE / ORG_UTILIZATION_PERCENTAGE — weighting factors applied to resource and organizational utilization calculations.
• RES_UTIL_CATEGORY_ID / ORG_UTIL_CATEGORY_ID — utilization categories associated with the work type.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the date range during which the work type is enabled for use.
• TP_AMT_TYPE_CODE — amount type code relevant to transfer pricing treatment.
• TRAINING_FLAG / UNASSIGNED_FLAG — flags identifying training work types and the seeded unassigned work type respectively.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, available for client-specific extensions.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit 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.