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.

[Home] [Help]

View: ICX_SALESREP_PERS_INFO_V

Product:	ICX - Oracle iProcurement
Description:	Sales Representative View
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SP.SALESREP_ID
, SP.NAME
, SCT.NAME
, SP.SALES_CREDIT_TYPE_ID
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('CODE_STATUS'
, SP.STATUS)
, SP.ORG_ID
, SP.EMAIL_ADDRESS
, SP.ASSIGNED_TO_USER_ID
, SP.COST_CENTER
, SP.COMPENSATION_CURRENCY_CODE
FROM RA_SALESREPS SP
, SO_SALES_CREDIT_TYPES SCT
WHERE SCT.SALES_CREDIT_TYPE_ID = SP.SALES_CREDIT_TYPE_ID

Columns

Name
SALES_REP_ID
REP_NAME
SALES_CREDIT_TYPE
SALES_CREDIT_TYPE_ID
SALESREP_STATUS
ORG_ID
EMAIL_ADDRESS
ASSIGNED_TO_USER_ID
COST_CENTER
COMPENSATION_CURRENCY_CODE