Search Results jtf_rs_salesreps_mo_v




Overview
Explore in AI Chat

Overview

JTF_RS_SALESREPS_MO_V is a multi-organization (MO) security view in the CRM Foundation (JTF) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the sales representative records held in the JTF_RS_SALESREPS table, filtered by operating unit through the Oracle Applications multi-org security mechanism. The name suffix "MO_V" identifies the object as a multi-org view rather than a physical table; the ETRM metadata explicitly notes that it is "not implemented in this database" as a stored object, confirming that it exists only as a database view definition.

The view presents salesrep attributes relevant to revenue accounting, credit assignment, and organizational reporting. It is commonly referenced when applications must resolve which sales representative is associated with a given operating unit, and when integration or reporting programs require the general ledger account identifiers attached to a salesrep. The user search term "gl_id_freight" corresponds directly to the GL_ID_FREIGHT column surfaced by this view, which stores the freight account identifier associated with the salesrep for revenue and receivables accounting purposes.

Underlying Base Objects

The view is defined over a single base object, JTF_RS_SALESREPS. The documented view text performs a SELECT of all principal columns from that table, applying a WHERE clause that restricts rows to the current operating unit. The predicate compares NVL(ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) against the same expression, so that only rows whose ORG_ID matches the organization identifier captured in the client information environment are returned. Where ORG_ID is null, the decoded client information value is used; where both are absent, the sentinel value -99 is applied, effectively excluding the row from normal multi-org queries.

Because the view is a security wrapper, no additional joins or base tables are documented in the ETRM record aside from JTF_RS_SALESREPS. Applications that require related resource or person details join the view to JTF_RS_RESOURCE_EXTNS or PER_ALL_PEOPLE_F using RESOURCE_ID or PERSON_ID respectively.

Key Columns

  • SALESREP_ID — Primary identifier of the sales representative record.
  • RESOURCE_ID — Foreign key to the CRM resource definition; links the salesrep to resource-level attributes.
  • NAME — Display name of the sales representative.
  • STATUS and START_DATE_ACTIVE / END_DATE_ACTIVE — Control whether the salesrep is currently active and the effective window of the record.
  • SALES_CREDIT_TYPE_ID — Identifies the sales credit type associated with the representative.
  • GL_ID_REV — Revenue account identifier used for accounting of salesrep-attributed revenue.
  • GL_ID_FREIGHT — Freight account identifier; the column referenced by the "gl_id_freight" search and used when freight charges must be posted to the account associated with the salesrep.
  • GL_ID_REC — Receivables account identifier.
  • SET_OF_BOOKS_ID — Ledger context under which the GL account identifiers are valid.
  • ORG_ID — Operating unit that owns the salesrep record; drives the multi-org filter.
  • SALESREP_NUMBER, EMAIL_ADDRESS, PERSON_ID — Identification and contact attributes.
  • SALES_TAX_GEOCODE and SALES_TAX_INSIDE_CITY_LIMITS — Tax determination attributes for the representative.
  • OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent updates.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield segments.

Common Use Cases and Queries

Typical uses include resolving the freight, revenue, or receivables account for a salesrep within the current operating unit, validating salesrep activity windows, and supplying CRM-to-financials integration extracts. A representative query retrieving the freight account configuration is:

  • SELECT salesrep_id, name, gl_id_freight, gl_id_rev, gl_id_rec, set_of_books_id FROM jtf_rs_salesreps_mo_v WHERE status = 'A' AND NVL(end_date_active, SYSDATE+1) > SYSDATE;
  • SELECT s.salesrep_number, s.name, s.gl_id_freight FROM jtf_rs_salesreps_mo_v s WHERE s.org_id = :p_org_id; — retrieves freight account identifiers for a specific operating unit.
  • SELECT s.salesrep_id, s.resource_id, s.name, r.xxx FROM jtf_rs_salesreps_mo_v s, jtf_rs_resource_extns r WHERE s.resource_id = r.resource_id; — joins salesrep accounting attributes to resource details.

Because the view enforces multi-org security, queries executed without a valid client information organization context may return no rows; callers should set the operating unit through the standard FND client info mechanism before querying.