Product: | AS - Sales Foundation |
---|---|
Description: | Sales group administrators view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SALES.ROWID
, SALES.SALES_GROUP_ID
, SALES.PERSON_ID
, SALES.SALESFORCE_ID
, SALES.LAST_UPDATE_DATE
, SALES.LAST_UPDATED_BY
, SALES.CREATION_DATE
, SALES.CREATED_BY
, SALES.LAST_UPDATE_LOGIN
, SALES.ATTRIBUTE_CATEGORY
, SALES.ATTRIBUTE1
, SALES.ATTRIBUTE2
, SALES.ATTRIBUTE3
, SALES.ATTRIBUTE4
, SALES.ATTRIBUTE5
, SALES.ATTRIBUTE6
, SALES.ATTRIBUTE7
, SALES.ATTRIBUTE8
, SALES.ATTRIBUTE9
, SALES.ATTRIBUTE10
, SALES.ATTRIBUTE11
, SALES.ATTRIBUTE12
, SALES.ATTRIBUTE13
, SALES.ATTRIBUTE14
, SALES.ATTRIBUTE15
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, PEOPLE.FULL_NAME
, PEOPLE.EMAIL_ADDRESS
, PEOPLE.WORK_TELEPHONE
, FORCE.STATUS_CODE
FROM AS_SALES_GRP_ADMIN SALES
, PER_PEOPLE_X PEOPLE
, AS_SALESFORCE FORCE
WHERE SALES.PERSON_ID = PEOPLE.PERSON_ID
AND SALES.SALESFORCE_ID = FORCE.SALESFORCE_ID