Search Results cs_jtf_resources_v




Overview
Explore in AI Chat

Overview

CS_JTF_RESOURCES_V is a Service (CS) module view owned by the APPS schema and documented in ETRM as "Resource Details." It consolidates the identity, contact, and address information of service resources into a single denormalized record per resource, joining the resource extension table to the underlying person or party records that describe the individual or organization. Because the view spans both employee resources stored in Oracle HRMS (PER_PEOPLE_F, PER_ADDRESSES, PER_PHONES) and non-employee resources stored in Oracle Trading Community Architecture (HZ_PARTIES, HZ_LOCATIONS), it provides a unified roster of resources without requiring the caller to know which repository holds a given resource type.

Within Oracle EBS 12.1.1 and 12.2.2, the view supports Service resource lookups, dispatch and scheduling screens, field service reporting, and integration extracts where resource contactability — including telephone, e-mail, and fax — is required. Notably, the query term "fax_number" maps directly to an exposed column of this view, making CS_JTF_RESOURCES_V the canonical source for resource fax numbers.

Underlying Base Objects

ETRM documents the following base objects for the 12.2.2 definition:

The definition is a UNION of two branches. The employee branch joins PER_PEOPLE_F to PER_ADDRESSES (primary address) and to three aliases of PER_PHONES — WPHONE (type 'WF', work phone), PPHONE (type 'P', pager), and MPHONE (type 'M', mobile) — with effective-date predicates bounded by DATE_FROM and DATE_TO. The second branch resolves non-employee resources through HZ_PARTIES and HZ_LOCATIONS, composing the party name from the person name attributes or PARTY_NAME for organizations.

Key Columns

Common Use Cases and Queries

Typical uses include resolving a resource's fax or phone contacts for notifications and document delivery, building Service resource directories, and validating contact data during integration loads.

Query a resource by ID:

  • SELECT resource_id, resource_number, full_name, fax_number, email_address FROM apps.cs_jtf_resources_v WHERE resource_id = :p_resource_id;

Locate resources by fax number:

  • SELECT resource_id, full_name, fax_number FROM apps.cs_jtf_resources_v WHERE fax_number IS NOT NULL;

Restrict by category and country for reporting:

  • SELECT resource_number, full_name, work_phone_number, cell_phone_number, fax_number FROM apps.cs_jtf_resources_v WHERE category = 'EMPLOYEE' AND country = 'US';

Because the view enforces HR security and effective-dated phone joins, results reflect only currently valid contact records visible to the querying responsibility.