Results for “salesrep_status”
14 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
- RESOURCE_ID / ROW_ID — Primary identifiers for the resource record.
- CATEGORY / CATG_MEANING — The stored category code and its translated meaning; CATG_MEANING is the column of interest for the user's search.
- RESOURCE_NAME, RESOURCE_NUMBER — Human-readable resource identity.
- SOURCE_* columns — Denormalized origin details including SOURCE_NAME, SOURCE_EMAIL, SOURCE_PHONE, SOURCE_ORG_NAME, address components, manager, and business group.
- SALESREP_NUMBER, SALESREP_ORG_ID, SALESREP_STATUS — Sales representative linkage, useful for CRM and order management reporting.
- COST_PER_HR, COST_CENTER, COMPENSATION_CURRENCY_CODE — Costing and charging attributes.
- START_DATE_ACTIVE, END_DATE_ACTIVE — Effective dating for the resource.
- ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — Descriptive flexfield (DFF) columns.
- OBJECT_VERSION_NUMBER — Optimistic locking/versioning column.
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.
-
Lookup Type: SALESREP_STATUS 12.2.2
Salesrep Status
-
Lookup Type: SALESREP_STATUS 12.1.1
Salesrep Status
-
View: JTF_RS_DEFRESOURCES_VL 12.2.2
APPS.JTF_RS_DEFRESOURCES_VL·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore JTF module →
-
View: JTF_RS_DEFRESOURCES_VL 12.1.1
APPS.JTF_RS_DEFRESOURCES_VL·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore JTF module →
-
Sales Representative View
Not implemented in this database·Explore ICX module →
-
Sales Representative View
Not implemented in this database·Explore ICX module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel