eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GML.OP_SLSR_MST_INT

Object Details

Object Name:	OP_SLSR_MST_INT
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_SLSR_MST_INT
Subobject Name:
Status:	VALID

This is the Sales Representative Interface table for data transferred from Oracle Receivables into the OPM sales representative table, OP_SLSR_MST. The data synchronization program in OPM populates this table with data from the Oracle Receivables sales rep tables and then the data is moved into OP_SLSR_MST.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CO_CODE	VARCHAR2	(4)	Yes	Company code for sales rep; a NULL value indicates "all " companies
SLSREP_CODE	VARCHAR2	(30)	Yes	Sales Representative Code
SLSREP_NAME	VARCHAR2	(40)	Yes	Sales Representative Name
ADDR_ID	NUMBER	(10)	Yes	Address ID of Sales Rep
PRICESLSREP_CODE	VARCHAR2	(8)	Yes	Pricing Sales Rep Code
SLSREP_TYPE	NUMBER	(5)	Yes	Same as op_slsr_mst
SLSREP_CLASS	VARCHAR2	(8)	Yes	Sales Rep Class
MGRSLSREP_CODE	VARCHAR2	(8)	Yes	Manager of Sales Rep
SLSREP_TERRITORY	VARCHAR2	(8)	Yes	Territory of Sales Rep
COMMISSION_CODE	VARCHAR2	(8)	Yes	Commission Code of Sales Rep
SLSREP_PHONE1	VARCHAR2	(20)	Yes	Sales Rep Phone #
SLSREP_PHONE2	VARCHAR2	(20)	Yes	2nd Sales Rep Phone #
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
INVALID_IND	NUMBER	(10)	Yes	0=Valid Data; 1=Invalid Data
DIRECTION_IND	NUMBER	(10)	Yes	0=Data coming into GEMMs; 1=Data going out to Oracle Financials.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CO_CODE
,      SLSREP_CODE
,      SLSREP_NAME
,      ADDR_ID
,      PRICESLSREP_CODE
,      SLSREP_TYPE
,      SLSREP_CLASS
,      MGRSLSREP_CODE
,      SLSREP_TERRITORY
,      COMMISSION_CODE
,      SLSREP_PHONE1
,      SLSREP_PHONE2
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      INVALID_IND
,      DIRECTION_IND
FROM GML.OP_SLSR_MST_INT;

Dependencies

[top of page]

GML.OP_SLSR_MST_INT does not reference any database object

GML.OP_SLSR_MST_INT is referenced by following:

APPS: OP_SLSR_MST_INT