VIEW: APPS.AS_FC_SALESFORCE_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')