Search Results training_flag

Overview

The view PJI_DIS_WORK_TYPES_V is a denormalized reporting object belonging to the Project Intelligence (PJI) module, which is designated as obsolete in Oracle EBS Release 12.1.1 and 12.2.2. Its documented purpose is to expose work type data to Oracle Discoverer, the ad hoc query and reporting tool historically bundled with the E-Business Suite. The view flattens the multilingually partitioned work type model into a single language-resolved row per work type, joining descriptive translations and both organizational and resource utilization categories in one statement. In this role it functions as a semantic reporting layer rather than a transactional object: it holds no data of its own and performs no DML.

The object is documented in the ETRM repository but is flagged as "Not implemented in this database," and its owner is not recorded, which indicates that the definition is shipped as reference metadata and may not exist in every installation. Because PJI is obsolete, the view should be treated as a legacy compatibility artifact. The user search term pa_util_categories_b is directly relevant, since that table is the utilization category source for two of the view's joins.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the documented view text defines the underlying tables explicitly. The view is built over the following objects in the Projects (PA) schema:

• PA_WORK_TYPES_B — the base work type table, aliased WT, supplying flags, utilization percentages, and foreign keys.
• PA_WORK_TYPES_TL — the translation table for work type names, aliased WTTL.
• PA_UTIL_CATEGORIES_B — the utilization category base table, joined twice as UC1 (organization) and UC2 (resource).
• PA_UTIL_CATEGORIES_TL — the utilization category translation table, joined twice as UC1TL and UC2TL.

Language resolution is enforced through USERENV('LANG') predicates applied to all three translation tables, ensuring each row returns descriptions in the session language. The joins are equijoins on WORK_TYPE_ID between the work type tables and on UTIL_CATEGORY_ID between each category base and translation pair. Because inner joins are used throughout, work types with null or orphaned utilization category references are excluded from the result set.

Key Columns

• WORK_TYPE_ID — primary identifier of the work type; the join key back to PA_WORK_TYPES_B.
• WORKTYPE — language-resolved name from PA_WORK_TYPES_TL.
• BILLABLE_CAPITALIZABLE_FLAG — indicates whether the work type is billable, capitalizable, or both.
• ORG_UTILIZATION_CATEGORY and RES_UTILIZATION_CATEGORY — translated names of the organizational and resource utilization categories.
• ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID — the corresponding identifiers from PA_UTIL_CATEGORIES_B.
• ORG_UTILIZATION_PERCENTAGE and RES_UTILIZATION_PERCENTAGE — the percentage of capacity consumed in each utilization dimension.
• REDUCE_CAPACITY_FLAG — governs whether the work type reduces available capacity.
• TRAINING_FLAG — marks the work type as training-related.
• UNASSIGNED_FLAG — identifies work types used for unassigned time.

Common Use Cases and Queries

The principal scenario is Discoverer-based reporting on work type configuration, especially utilization category assignment and capacity reduction behavior. Related integration and validation scenarios include confirming that every active work type references valid utilization categories in the correct language, and feeding work type attributes into external project accounting extracts.

A representative query retrieves work types with their utilization categories:

• SELECT WORK_TYPE_ID, WORKTYPE, ORG_UTILIZATION_CATEGORY, RES_UTILIZATION_CATEGORY, BILLABLE_CAPITALIZABLE_FLAG FROM PJI_DIS_WORK_TYPES_V ORDER BY WORKTYPE;
• Filter unassigned or training behavior: SELECT WORKTYPE, UNASSIGNED_FLAG, TRAINING_FLAG FROM PJI_DIS_WORK_TYPES_V WHERE UNASSIGNED_FLAG = 'Y';
• Because PA_UTIL_CATEGORIES_B is joined twice, an equivalent direct query against the base tables is often preferable where the view is not implemented.