[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 |