Results for “salesrep_org_id”

8 results




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

Overview

JTF_RS_DEFRESOURCES_VL is an APPS-owned database view within the JTF – CRM Foundation product module. It is a "VL" (translated/validated) view that consolidates resource definition data for CRM and Field Service operations. The view joins the resource extensions table with the JTF_OBJECTS_VL view to resolve the resource category code into a user-facing meaning, exposed through the CATG_MEANING column. This is the column a user searches for when attempting to interpret the numeric or coded CATEGORY value stored against a resource record.

In Oracle EBS 12.1.1 and 12.2.2, this view functions primarily as a reporting and integration layer. It presents a denormalized, read-friendly projection of resource attributes, including identity, contact details, assignment information, cost data, and sales representative linkage, without requiring downstream consumers to reconstruct the underlying joins themselves.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced objects:

  • JTF_RS_RESOURCE_EXTNS_VL (VIEW) — aliased RSC; supplies the core resource extension columns such as ROW_ID, RESOURCE_ID, CATEGORY, RESOURCE_NUMBER, contact/address IDs, cost fields, attributes, and source information.
  • JTF_OBJECTS_VL (VIEW) — aliased OBJ; supplies the NAME column that is aliased as CATG_MEANING, translating the resource category code into a descriptive label.
  • JTF_RS_SALESREPS_MO_V (SYNONYM) — aliased SRP; supplies sales representative attributes including SALESREP_NUMBER, ORG_ID (as SALESREP_ORG_ID), and STATUS (defaulted to 'A' via NVL when null).

The view therefore synthesizes resource foundation data, category lookup translation, and sales representative context in a single query surface.

Key Columns

Common Use Cases and Queries

Typical usage includes validating resource category assignments, reporting on active resources by organization, and reconciling CRM resources against sales representatives. The following sample lists active resources with translated category meaning:

SELECT resource_id, resource_number, resource_name, category, catg_meaning, salesrep_number, salesrep_status FROM apps.jtf_rs_defresources_vl WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

To locate resources matching a specific descriptive category, filter on CATG_MEANING directly rather than decoding CATEGORY:

SELECT resource_id, resource_name, catg_meaning FROM apps.jtf_rs_defresources_vl WHERE catg_meaning = 'Employee';

Because the view exposes SALESREP_NUMBER and SALESREP_ORG_ID, it is also a convenient source for multi-org sales representative extracts and CRM-to-Order Management reconciliation queries.