Search Results okl_cs_activities_uv




Overview
Explore in AI Chat

Overview

OKL_CS_ACTIVITIES_UV is a PL/SQL view owned by the APPS schema within the OKL (Leasing and Finance Management) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It consolidates leasing-related customer service activities into a single denormalized reporting structure by joining the JTF Interaction History (IH) activity tables with customer, party, and task reference data. The "_UV" suffix conventionally denotes a user view exposed for inquiry, reporting, and integration purposes rather than for direct DML. In practice, the view serves as the runtime source for the OKL customer service Activities page and as the underlying query target for leases-related action tracking.

The user search term action_desc maps directly to the ACTION_DESC column exposed by this view. This column corresponds to the SHORT_DESCRIPTION from JTF_IH_ACTIONS_TL, joined through ACT.ACTION_ID and returned as ACTN.SHORT_DESCRIPTION. It provides the translatable, user-facing name of the action performed during an activity, distinguishing it from ACTION_ITEM_DESC (the short description of the related action item).

Underlying Base Objects

The view is defined over twelve synonym-referenced base objects, all resolved through the APPS schema:

Because the view references synonym objects, it is portable across environments where the JTF and HZ schemas are installed, as is standard for EBS.

Key Columns

Common Use Cases and Queries

Typical usage covers activity history reporting, action outcome analysis, and integration extracts keyed to leasing contracts or parties. A representative query filtering on the searched attribute is shown below:

  • Action description lookup: SELECT activity_id, action, action_desc, party_name, start_date_time FROM okl_cs_activities_uv WHERE action_desc IS NOT NULL AND start_date_time >= :p_from_date;
  • Activity volume by action: SELECT action_desc, COUNT(*) FROM okl_cs_activities_uv GROUP BY action_desc ORDER BY 2 DESC;
  • Outcome analysis by party: SELECT party_name, action_desc, outcome_code, result_code FROM okl_cs_activities_uv WHERE party_id = :p_party_id;
  • Object-linked activity detail: SELECT object_function, object_id, activity_id, mediadirtype, duration FROM okl_cs_activities_uv WHERE object_type = :p_object_type;

These queries reflect the view's intended read-only reporting role and its dependence on the JTF and HZ base objects described above.