Product: | AS - Sales Foundation |
---|---|
Description: | This view shows all the salesforce from JTF resource manager |
Implementation/DBA Data: | APPS.AS_FC_SALESFORCE_V |
SELECT RES.RESOURCE_ID
, RES.RESOURCE_NUMBER
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
, RES.LAST_UPDATE_LOGIN
, RES.CATEGORY
, ROLEB.ROLE_ID
, ROLETL.ROLE_NAME
, ROLEB.ROLE_TYPE_CODE
, ROLEB.MEMBER_FLAG
, ROLEB.ADMIN_FLAG
, ROLEB.MANAGER_FLAG
, RREL.START_DATE_ACTIVE
, RREL.END_DATE_ACTIVE
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, RES.SOURCE_ID
, 'PARTNER'
, RES.MANAGING_EMPLOYEE_ID
, NULL)
, MEM.GROUP_ID
, DECODE(RES.CATEGORY
, 'PARTNER'
, RES.SOURCE_ID
, NULL)
, RES.ADDRESS_ID
, MEM.DELETE_FLAG
, RREL.DELETE_FLAG
, RES.ATTRIBUTE_CATEGORY
, RES.ATTRIBUTE1
, RES.ATTRIBUTE2
, RES.ATTRIBUTE3
, RES.ATTRIBUTE4
, RES.ATTRIBUTE5
, RES.ATTRIBUTE6
, RES.ATTRIBUTE7
, RES.ATTRIBUTE8
, RES.ATTRIBUTE9
, RES.ATTRIBUTE10
, RES.ATTRIBUTE11
, RES.ATTRIBUTE12
, RES.ATTRIBUTE13
, RES.ATTRIBUTE14
, RES.ATTRIBUTE15
, RES.SOURCE_NAME
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_NUMBER
, RES.SOURCE_EMAIL
, RES.USER_NAME
FROM JTF_RS_GROUP_MEMBERS MEM
, JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLEB
, JTF_RS_ROLES_TL ROLETL
WHERE ROLEB.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM')
AND RES.RESOURCE_ID = MEM.RESOURCE_ID
AND MEM.GROUP_MEMBER_ID = RREL.ROLE_RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER'
AND RREL.ROLE_ID = ROLEB.ROLE_ID
AND ROLEB.ROLE_ID = ROLETL.ROLE_ID
AND ROLETL.LANGUAGE = USERENV('LANG')