Results for “ci_type_class”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_CI_TYPES_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the definition of Control Item Types — the configurable categories of project control items used by Oracle Projects to govern, track, and approve control items such as change requests, issues, and action items. The view consolidates the base Control Item Types entity with its translated name and description, its class lookup meaning, its associated classification, reason, and resolution categories, and its linked status list. This consolidation makes the view a single, denormalized reporting source for Control Item Type setup data.
Because it exposes user-facing meaning rather than raw codes, the view is well suited for both reporting and integration. Report developers use it to build value sets and LOVs, while integration developers read it to validate an item type before inserting or updating control records. All access is through the APPS schema, and the view is documented as VALID.
Underlying Base Objects
The view is defined over four documented base objects and three supporting joins. The primary entity is the base table PA_CI_TYPES_B, which stores Control Item Type attributes including the auto-number, approval, resolution, source-attribute, and usage flags. The multilingual table PA_CI_TYPES_TL supplies the language-specific NAME, SHORT_NAME, and DESCRIPTION, restricted to the session language via USERENV('LANG'). The class code is resolved through PA_LOOKUPS using the lookup type 'PA_CI_TYPE_CLASSES'.
Three classification lookups — CLASSIFICATION_CATEGORY, REASON_CATEGORY, and RESOLUTION_CATEGORY — are each outer-joined to PA_CLASS_CATEGORIES so that types without a category assignment still appear. Finally, the status list is obtained by joining PA_OBJ_STATUS_LISTS (filtered to OBJECT_TYPE = 'PA_CI_TYPES' and STATUS_TYPE = 'CONTROL_ITEM') to PA_STATUS_LISTS_V. The joins produce a row per Control Item Type per session language, with a ROWID and ROW_ID exposed from the base table.
Key Columns
- CI_TYPE_ID — the unique identifier of the Control Item Type; the join key across all source objects.
- CI_TYPE_CLASS_CODE and CI_TYPE_CLASS — the stored code and its decoded lookup meaning.
- NAME, SHORT_NAME, DESCRIPTION — language-specific labels from PA_CI_TYPES_TL for the session language.
- AUTO_NUMBER_FLAG — indicates whether control items of this type are automatically numbered.
- APPROVAL_REQUIRED_FLAG and RESOLUTION_REQUIRED_FLAG — govern whether approval and resolution workflows apply.
- SOURCE_ATTRS_ENABLED_FLAG and ALLOW_ALL_USAGE_FLAG — control source attribute usage and breadth of applicability.
- CLASSIFICATION_CATEGORY, REASON_CATEGORY, RESOLUTION_CATEGORY and their *_DESC columns — category codes and descriptions used to classify control items.
- START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range for the type.
- STATUS_LIST_ID and NAME (status list name) — the associated status list and its display name.
Common Use Cases and Queries
Typical scenarios include building a Control Item Type LOV, generating a setup report, validating configuration before an interface load, and confirming which types are currently effective. The following sample returns active Control Item Types with their class and status list:
SELECT ci_type_id, name, ci_type_class, start_date_active, end_date_active FROM pa_ci_types_v WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE) ORDER BY name;SELECT ci_type_id, name, approval_required_flag, resolution_required_flag FROM pa_ci_types_v WHERE approval_required_flag = 'Y';
Because the view is a reporting layer, it is read-only; changes must be applied to PA_CI_TYPES_B and PA_CI_TYPES_TL. Joins to PA_CI_TYPES_B via CI_TYPE_ID remain valid for reconciling view output against the underlying configuration.
-
View: PA_CI_TYPES_V 12.1.1
APPS.PA_CI_TYPES_V·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·↳ PA_CLASS_CATEGORIES·Explore PA module →
-
View: PA_CI_TYPES_V 12.2.2
This view is used to display the details of the control item type, in the Update Control Item Type page.
APPS.PA_CI_TYPES_V·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·↳ PA_CLASS_CATEGORIES·Explore PA module →
-
VIEW: APPS.PA_CI_TYPES_V 12.2.2
-
VIEW: APPS.PA_CI_TYPES_V 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - PA Tables and Views 12.1.1