Product: | AS - Sales Foundation |
---|---|
Description: | View definition for RA_SALESREPS_ALL |
Implementation/DBA Data: | Not implemented in this database |
SELECT RAREPS.SALESREP_ID
, RAREPS.LAST_UPDATE_DATE
, RAREPS.LAST_UPDATED_BY
, RAREPS.CREATION_DATE
, RAREPS.CREATED_BY
, RAREPS.LAST_UPDATE_LOGIN
, RAREPS.SALES_CREDIT_TYPE_ID
, RAREPS.NAME
, RAREPS.STATUS
, RAREPS.START_DATE_ACTIVE
, RAREPS.END_DATE_ACTIVE
, RAREPS.GL_ID_REV
, RAREPS.GL_ID_FREIGHT
, RAREPS.GL_ID_REC
, RAREPS.SET_OF_BOOKS_ID
, RAREPS.ATTRIBUTE_CATEGORY
, RAREPS.ATTRIBUTE1
, RAREPS.ATTRIBUTE2
, RAREPS.ATTRIBUTE3
, RAREPS.ATTRIBUTE4
, RAREPS.ATTRIBUTE5
, RAREPS.ATTRIBUTE6
, RAREPS.ATTRIBUTE7
, RAREPS.ATTRIBUTE8
, RAREPS.ATTRIBUTE9
, RAREPS.ATTRIBUTE10
, RAREPS.SALESREP_NUMBER
, RAREPS.ATTRIBUTE11
, RAREPS.ATTRIBUTE12
, RAREPS.ATTRIBUTE13
, RAREPS.ATTRIBUTE14
, RAREPS.ATTRIBUTE15
, RAREPS.EMAIL_ADDRESS
, RAREPS.ASSIGNED_TO_USER_ID
, RAREPS.COST_CENTER
, RAREPS.CHARGE_TO_COST_CENTER
, RAREPS.START_PROCESSING_PERIOD_ID
, RAREPS.END_PROCESSING_PERIOD_ID
, RAREPS.COMPENSATION_CURRENCY_CODE
, RAREPS.WH_UPDATE_DATE
, RAREPS.PERSON_ID
, RAREPS.SALES_TAX_GEOCODE
, RAREPS.SALES_TAX_INSIDE_CITY_LIMITS
, RAREPS.SALESFORCE_ID
, RAREPS.COMMISSIONABLE_FLAG
FROM RA_SALESREPS_ALL RAREPS
WHERE NVL(RAREPS.ORG_ID
, NVL(TO_NUMBER( DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)