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: JTF.JTF_RS_SALESREPS_INT

Object Details

Object Name:	JTF_RS_SALESREPS_INT
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_SALESREPS_INT
Subobject Name:
Status:	VALID

This interface table is used for populating data in JTF_RS_SALESREPS table

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_SALESREPS_INT_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_ID
JTF_RS_SALESREPS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID OPERATION_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		Yes	Unique identifier for this table. Use JTF_RS_SALESREPS_INT_S sequence to populate this id.
SALESREP_GUID	VARCHAR2	(2000)		Identifier from External Systems. Consumer team will populate and use this data for managing mappings to external system. Resource Manager will not modify this id.
BATCH_ID	NUMBER		Yes	Batch Identifier. Use sequence JTF_RS_INT_BATCH_ID_S to generate a value.
OPERATION	VARCHAR2	(10)	Yes	Type of Operation to be performed on salesperson record. Valid values: CREATE, UPDATE
OPERATION_STATUS	VARCHAR2	(10)		Return Status from API after Resource Manager processes the record. Valid Values: S (success), E (Error), U (Unexpected Error)
OPERATION_MESSAGE	VARCHAR2	(4000)		Message text stacked by API after processing.
OPERATION_CREATION_DATE	DATE			Date-Time when record is created in interface table.
OPERATION_PROCESS_DATE	DATE			Date-Time when record is processed
SALESREP_ID	NUMBER			Salesrep Id. Mandatory for UPDATE operation. Populated back in interface table after Salesrep creation.
RESOURCE_ID	NUMBER			Resource Id. Mandatory for CREATE operation. UPDATE operation ignores it.
SALES_CREDIT_TYPE_ID	NUMBER		Yes	Sales Credit Type Identifier (FK to so_sales_credit_types). Mandatory for both CREATE and UPDATE.
STATUS	VARCHAR2	(30)		Status of salesrep
START_DATE_ACTIVE	DATE			Effective start date of salesrep
END_DATE_ACTIVE	DATE			Effective end date of salesrep
SALESREP_NUMBER	VARCHAR2	(30)		Unique alpha-numeric value given to salesrep
ORG_ID	NUMBER		Yes	Organization Id of salesrep
EMAIL_ADDRESS	VARCHAR2	(240)		Email address of salesreps
GL_ID_REV	NUMBER			GL Code Combination for Receivable account id
GL_ID_FREIGHT	NUMBER			GL Code Combination for Freight account id
GL_ID_REC	NUMBER			GL Code Combination for Revenue account id
SET_OF_BOOKS_ID	NUMBER			General Ledger Set of Books Identifier
SALES_TAX_GEOCODE	VARCHAR2	(30)		Sales Tax Geographical Code
SALES_TAX_INSIDE_CITY_LIMITS	VARCHAR2	(30)		Inside city limits tax indicator

Query Text

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


SELECT INTERFACE_ID
,      SALESREP_GUID
,      BATCH_ID
,      OPERATION
,      OPERATION_STATUS
,      OPERATION_MESSAGE
,      OPERATION_CREATION_DATE
,      OPERATION_PROCESS_DATE
,      SALESREP_ID
,      RESOURCE_ID
,      SALES_CREDIT_TYPE_ID
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SALESREP_NUMBER
,      ORG_ID
,      EMAIL_ADDRESS
,      GL_ID_REV
,      GL_ID_FREIGHT
,      GL_ID_REC
,      SET_OF_BOOKS_ID
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
FROM JTF.JTF_RS_SALESREPS_INT;

Dependencies

[top of page]

JTF.JTF_RS_SALESREPS_INT does not reference any database object

JTF.JTF_RS_SALESREPS_INT is referenced by following:

JTF: JTF_RS_SALESREPS_INT#