Product: | AS - Sales Foundation |
---|---|
Description: | Sales representative jobs view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SALJOB.ROWID
, SALJOB.JOB_ID
, SALJOB.LAST_UPDATE_DATE
, SALJOB.LAST_UPDATED_BY
, SALJOB.CREATION_DATE
, SALJOB.CREATED_BY
, SALJOB.LAST_UPDATE_LOGIN
, SALJOB.ATTRIBUTE_CATEGORY
, SALJOB.ATTRIBUTE1
, SALJOB.ATTRIBUTE2
, SALJOB.ATTRIBUTE3
, SALJOB.ATTRIBUTE4
, SALJOB.ATTRIBUTE5
, SALJOB.ATTRIBUTE6
, SALJOB.ATTRIBUTE7
, SALJOB.ATTRIBUTE8
, SALJOB.ATTRIBUTE9
, SALJOB.ATTRIBUTE10
, SALJOB.ATTRIBUTE11
, SALJOB.ATTRIBUTE12
, SALJOB.ATTRIBUTE13
, SALJOB.ATTRIBUTE14
, SALJOB.ATTRIBUTE15
, PERJOB.NAME
FROM AS_SALESREP_JOBS SALJOB
, PER_JOBS PERJOB
WHERE SALJOB.JOB_ID = PERJOB.JOB_ID