Results for “op_slsr_mst”

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

Overview

The table GML.OP_SLSR_MST is the sales representative master table within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite, documented as valid in the ETRM reference for releases 12.1.1 and 12.2.2. It functions as a foundational master data object used to define and maintain sales representatives who are assigned to orders, proposals, commissions, and customers across the process manufacturing sales cycle.

Based on the foreign key topology provided in the metadata, this table is classified as hub-leaning in a Data Vault modeling heuristic. This suggests it should be treated as a hub entity, with SLSREP_CODE serving as the business key that anchors related descriptive attributes and downstream transactional associations. The single unique index, OP_SLSR_MST_PK, confirms SLSREP_CODE as the definitive business key candidate.

Key Information Stored

The table contains 24 documented columns. The most significant are:

• SLSREP_CODE — Primary key and business identifier for the sales representative.
• SLSREP_NAME — Descriptive name of the representative.
• ADDR_ID — Foreign key to SY_ADDR_MST, storing the representative's address.
• SLSREP_TYPE and SLSREP_CLASS — Classify the representative; SLSREP_CLASS references OP_SLSR_CLS.
• MGRSLSREP_CODE — Identifies the managing sales representative for reporting hierarchies.
• SLSREP_TERRITORY — Territory assignment for the representative.
• COMMISSION_CODE — Links to the commission setup in OP_COMMISSION.
• PRICESLSREP_CODE — Associates the representative with pricing responsibility.
• SLSREP_PHONE1 and SLSREP_PHONE2 — Contact telephone numbers.
• CO_CODE — Operating company/organization, referencing SY_ORGN_MST and SY_ORGN_MST_B.
• TEXT_CODE — Foreign key to OP_TEXT_HDR for descriptive text attachments.
• Audit columns such as CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, DELETE_MARK, and concurrent program identifiers (PROGRAM_ID, REQUEST_ID).

Note that TRANS_CNT and the program-related columns are less central to functional use but support auditing and process tracking.

Common Use Cases and Queries

Typical reporting and integration scenarios include validating sales representative assignments on orders and proposals, reconciling commission setups, and building territory or hierarchy reports.

SELECT s.SLSREP_CODE, s.SLSREP_NAME, s.SLSREP_TERRITORY, s.COMMISSION_CODE
FROM   GML.OP_SLSR_MST s
WHERE  s.DELETE_MARK = 0
ORDER BY s.SLSREP_NAME;

SELECT h.ORDER_NO, d.LINE_NO, s.SLSREP_NAME
FROM   GML.OP_ORDR_HDR h,
       GML.OP_ORDR_DTL d,
       GML.OP_SLSR_MST s
WHERE  h.ORDER_ID = d.ORDER_ID
AND    d.SLSREP_CODE = s.SLSREP_CODE(+)
AND    s.SLSREP_TERRITORY = :territory;

Such queries support sales performance analysis, commission calculation verification, and exception reporting where representatives may lack commission or class assignments.

Related Objects

The following objects are the most significant referenced by or referencing this table through documented foreign keys:

• OP_COMMISSION — Referenced via COMMISSION_CODE; defines commission structures.
• OP_SLSR_CLS — Referenced via SLSREP_CLASS; defines representative classifications.
• SY_ADDR_MST — Referenced via ADDR_ID; provides address master data.
• SY_ORGN_MST and SY_ORGN_MST_B — Referenced via CO_CODE; operating company definitions.
• OP_TEXT_HDR — Referenced via TEXT_CODE; header text repository.
• OP_ORDR_HDR and OP_ORDR_DTL — Reference SLSREP_CODE, tying representatives to sales orders.
• OP_CUST_MST and OP_CUST_MST_OPM — Reference SLSREP_CODE, linking representatives to customers.
• OP_PRSL_HDR and OP_PRSL_DTL — Reference SLSREP_CODE, associating representatives with proposals.
• OP_COMM_CDS — References SLSREP_CODE, connecting commission codes to representatives.

These relationships establish OP_SLSR_MST as a central hub supporting order capture, proposal management, customer assignment, and commission processing within Process Manufacturing Logistics.