Product: | AS - Sales Foundation |
---|---|
Description: | Employees from salesforce view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SALE.RESOURCE_ID
, SALE.LAST_UPDATE_DATE
, SALE.LAST_UPDATED_BY
, SALE.CREATION_DATE
, SALE.CREATED_BY
, SALE.LAST_UPDATE_LOGIN
, SALE.START_DATE_ACTIVE
, SALE.END_DATE_ACTIVE
, SALE.SOURCE_ID
, MEM.GROUP_ID
, SALE.ATTRIBUTE_CATEGORY
, SALE.ATTRIBUTE1
, SALE.ATTRIBUTE2
, SALE.ATTRIBUTE3
, SALE.ATTRIBUTE4
, SALE.ATTRIBUTE5
, SALE.ATTRIBUTE6
, SALE.ATTRIBUTE7
, SALE.ATTRIBUTE8
, SALE.ATTRIBUTE9
, SALE.ATTRIBUTE10
, SALE.ATTRIBUTE11
, SALE.ATTRIBUTE12
, SALE.ATTRIBUTE13
, SALE.ATTRIBUTE14
, SALE.ATTRIBUTE15
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, PEOPLE.FIRST_NAME || ' ' || PEOPLE.LAST_NAME
, GRP.GROUP_NAME
, PEOPLE.WORK_TELEPHONE
, PEOPLE.EMAIL_ADDRESS
FROM JTF_RS_GROUP_MEMBERS MEM
, JTF_RS_GROUPS_TL GRP
, PER_PEOPLE_X PEOPLE
, JTF_RS_ROLES_B ROLE
, JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_RESOURCE_EXTNS SALE
WHERE SALE.CATEGORY = 'EMPLOYEE'
AND RREL.ROLE_RESOURCE_ID = SALE.RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND RREL.ROLE_ID = ROLE.ROLE_ID
AND ROLE.MEMBER_FLAG = 'Y'
AND (ROLE.ROLE_TYPE_CODE = 'SALES' OR ROLE.ROLE_TYPE_CODE = 'TELESALES' OR ROLE.ROLE_TYPE_CODE = 'FIELDSALES')
AND SALE.RESOURCE_ID = MEM.RESOURCE_ID(+)
AND SALE.SOURCE_ID = PEOPLE.PERSON_ID
AND MEM.GROUP_ID = GRP.GROUP_ID(+)
AND GRP.LANGUAGE(+) = USERENV('LANG')