Results for “resi_cat_name”

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

Overview

OKL_FE_RESI_CAT_V is a Multi-Lingual Support (MLS) view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OKL product family — Oracle Lease and Finance Management. The view exposes residual category set definitions together with their translated (language-specific) descriptive attributes, providing a single, denormalized access point that joins the base residual category table to its translation table for the session's current language.

In the context of a search on resi_cat_name, this view is the primary reporting and integration surface for residual category naming. Applications, concurrent programs, and external integrations query it to retrieve the residual category name and description without having to manage the join between the base table and the TL (translation) table themselves. Because it is an MLS view, it automatically filters translations to the language of the querying session via USERENV('LANG'), which is the standard Oracle EBS mechanism for presenting localized data.

Underlying Base Objects

The view is defined over two documented base objects, exposed to APPS through synonyms:

• OKL_FE_RESI_CAT_B — the base (language-independent) residual category set table. It holds the structural and operational columns, including identifiers, organization, status, and the residual category name driven by the search term resi_cat_name.
• OKL_FE_RESI_CAT_ALL_TL — the translation table holding language-specific descriptive data, keyed by RESI_CATEGORY_SET_ID and LANGUAGE.

The join links them on RCS_B.RESI_CATEGORY_SET_ID = RCS_TL.RESI_CATEGORY_SET_ID and restricts rows to RCS_TL.LANGUAGE = USERENV('LANG'). This pattern is the standard MLS construct in EBS, where the _B table carries non-translatable columns and the _TL table carries translatable ones.

Key Columns

• RESI_CATEGORY_SET_ID — primary identifier for a residual category set; the join key between the base and translation objects.
• RESI_CAT_NAME — the residual category name, sourced from the base table. This is the column most commonly referenced in searches and reports.
• RESI_CAT_DESC — the translated description of the residual category, sourced from the TL table.
• SFWT_FLAG — a translated flag column (commonly "see for who translation" / soft flag), carried from the TL table.
• ORIG_RESI_CAT_SET_ID — the original residual category set identifier, useful for tracing seeded or copied records.
• ORG_ID — the operating unit / organization identifier; relevant for multi-org (MOAC) access.
• SOURCE_CODE and STS_CODE — the source and status codes describing the record's origin and lifecycle state.
• OBJECT_VERSION_NUMBER — optimistic concurrency control column used by the OAF/ADF framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical use cases include LOV population for residual category selection, MLS-aware reporting on lease and finance residual categories, and integration extracts feeding downstream systems. Because the view resolves language automatically, it is preferred over direct joins in most read-only scenarios.

Retrieve all residual category names and descriptions for the current session language:

• SELECT resi_category_set_id, resi_cat_name, resi_cat_desc
• FROM apps.okl_fe_resi_cat_v
• WHERE sts_code = 'ACTIVE'
• ORDER BY resi_cat_name;

Search for a specific category by name (the scenario behind the resi_cat_name lookup):

• SELECT resi_category_set_id, resi_cat_name, resi_cat_desc
• FROM apps.okl_fe_resi_cat_v
• WHERE UPPER(resi_cat_name) LIKE UPPER(:p_name || '%');

Filter by operating unit for multi-org reporting:

• SELECT resi_cat_name, org_id, source_code
• FROM apps.okl_fe_resi_cat_v
• WHERE org_id = :p_org_id;

In all cases, the view's MLS filtering guarantees that RESI_CAT_DESC and SFWT_FLAG return values in the session's language, while RESI_CAT_NAME is drawn from the base table.