Search Results cs_ar_pager_phone_type




Overview
Explore in AI Chat

Overview

APPS.CS_IB_W_EMPLOYEES_V is a service-oriented view in Oracle E-Business Suite that exposes employee records in a "resource" shaped result set. It is intended for use by the Interaction Blending / CRM resource search and selection flows (the "IB" and "W" naming conventions reflect the Interaction Blending and Web/workspace contexts), where employees must be presented alongside other resource types such as parties, contacts, and resources. The view flattens an employee record into a standardized set of columns — resource_name, resource_number, resource_id, resource_type, resource_address, contact_category, and sort_order — and decorates it with communication channel values retrieved through the CS_PARTIES_PKG API.

Because the view returns the same column shape regardless of the underlying source, consumers can union it with equivalent party and contact views to present a unified resource picker. It is a reporting and integration convenience view rather than a transactional object, and it is owned by APPS.

Underlying Base Objects

The view is defined over two data sources joined in the FROM clause:

Key Columns

Common Use Cases and Queries

A frequent driver for searching this view is retrieving an employee's work phone type configuration, referenced by the profile option CS_AR_WORK_PHONE_TYPE (the term "cs_ar_work_phone_type" in the user's query). Administrators typically query this value directly, then join to this view to confirm the resolved number.

  • Look up an employee's resolved work phone: 
    SELECT resource_name, work_phone
FROM   apps.cs_ib_w_employees_v
WHERE  resource_number = :employee_num;
  • Inspect the profile option that governs the work phone slot: 
    SELECT profile_option_name, profile_option_value
FROM   fnd_profile_option_values
WHERE  profile_option_name = 'CS_AR_WORK_PHONE_TYPE';
  • Blend employees with other resource sources for a picker: 
    SELECT resource_id, resource_name, resource_type, work_phone
FROM   apps.cs_ib_w_employees_v
WHERE  UPPER(resource_name) LIKE UPPER('%'||:search||'%')
ORDER  BY resource_name;
  • Report contact channels for a department's employees: 
    SELECT resource_name, cell_phone, email, fax
FROM   apps.cs_ib_w_employees_v;

Because the view calls PL/SQL functions per row, query performance depends on the volume of employees scanned; predicates that restrict the employee set before the functions are evaluated produce the best response times.