Search Results source_phone




Overview
Explore in AI Chat

Overview

APPS.CAC_CAL_RESOURCES is a reporting and integration view in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2) that presents calendar-eligible resources drawn from the Oracle CRM resource foundation. It exposes a consolidated, denormalized projection of resource identity, classification, contact details, and managerial context, allowing downstream calendar, scheduling, and resource-assignment components to query a single object rather than navigating the underlying resource model directly. The view is owned by the APPS schema and is defined entirely over another view, JTF_RS_RESOURCE_EXTNS_VL, which supplies the extended resource attributes maintained by the Oracle resource foundation.

Because the view normalizes field names (for example, SOURCE_JOB_TITLE is surfaced as JOB_TITLE and SOURCE_BUSINESS_GRP_NAME as BUSINESS_GROUP), it presents a stable, application-friendly interface for reporting and integration. The CAC prefix associates the object with the CRM calendar and resource-access components, positioning it as a supporting object for calendar-driven scheduling, availability, and resource lookup. For the user search term "source_job_title," the relevant mapping is the view column SOURCE_JOB_TITLE, aliased to JOB_TITLE, which conveys the resource's job title as maintained by the source resource record.

Underlying Base Objects

The view has a single documented underlying object: JTF_RS_RESOURCE_EXTNS_VL, itself a view in the Oracle resource (JTF_RS) schema family. "EXTNS" denotes the extension attributes stored for resources, while the "_VL" suffix indicates a translated or language-sensitive view. CAC_CAL_RESOURCES performs a straightforward projection with column aliasing; it does not join additional tables and does not apply filters in its documented text. Consequently, all rows and columns available in JTF_RS_RESOURCE_EXTNS_VL flow through to CAC_CAL_RESOURCES, and the view carries no independent storage or materialization. This one-to-one dependency means that any change to the definition of JTF_RS_RESOURCE_EXTNS_VL is reflected immediately in CAC_CAL_RESOURCES, and it is the base view rather than CAC_CAL_RESOURCES that carries the core resource joins and logic.

Key Columns

Common Use Cases and Queries

Typical usages include resource rosters for scheduling, populating selection lists in calendar tools, and extraction into downstream reporting where job title, manager, or contact details are required. The SOURCE_JOB_TITLE-to-JOB_TITLE mapping is the object of the "source_job_title" search, so queries commonly filter or group by JOB_TITLE.

  • Listing active resources with title and contact details:
SELECT resource_id, resource_name, job_title, manager, email
FROM   apps.cac_cal_resources
WHERE  SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
  • Finding resources by job title:
SELECT resource_id, resource_name, business_group
FROM   apps.cac_cal_resources
WHERE  job_title = :p_job_title;
  • Counting resources by business group and type:
SELECT business_group, resource_type, COUNT(*)
FROM   apps.cac_cal_resources
GROUP  BY business_group, resource_type;

Because CAC_CAL_RESOURCES contains no filters, queries should apply their own date-activity and business-group predicates to restrict results appropriately.