VIEW: APPS.AS_SALESFORCE_SUB_V

Source

View Text - Preformatted

SELECT RES.RESOURCE_ID SALESFORCE_ID , MEM.GROUP_ID SALES_GROUP_ID , RREL.START_DATE_ACTIVE START_DATE_ACTIVE , RREL.END_DATE_ACTIVE END_DATE_ACTIVE , RES.SOURCE_NAME SOURCE_NAME , RES.SOURCE_FIRST_NAME SOURCE_FIRST_NAME , RES.SOURCE_LAST_NAME SOURCE_LAST_NAME FROM JTF_RS_GROUP_MEMBERS MEM , JTF_RS_RESOURCE_EXTNS RES , JTF_RS_ROLE_RELATIONS RREL , JTF_RS_ROLES_B ROLEB 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 MEM.DELETE_FLAG <> 'Y' AND RREL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER' AND RREL.ROLE_ID = ROLEB.ROLE_ID AND RREL.DELETE_FLAG <> 'Y' AND (ROLEB.MEMBER_FLAG='Y' OR (NVL(ROLEB.MEMBER_FLAG,'N') ='N' and ROLEB.MANAGER_FLAG='Y'))

View Text - HTML Formatted

SELECT RES.RESOURCE_ID SALESFORCE_ID
, MEM.GROUP_ID SALES_GROUP_ID
, RREL.START_DATE_ACTIVE START_DATE_ACTIVE
, RREL.END_DATE_ACTIVE END_DATE_ACTIVE
, RES.SOURCE_NAME SOURCE_NAME
, RES.SOURCE_FIRST_NAME SOURCE_FIRST_NAME
, RES.SOURCE_LAST_NAME SOURCE_LAST_NAME
FROM JTF_RS_GROUP_MEMBERS MEM
, JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLEB
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 MEM.DELETE_FLAG <> 'Y'
AND RREL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER'
AND RREL.ROLE_ID = ROLEB.ROLE_ID
AND RREL.DELETE_FLAG <> 'Y'
AND (ROLEB.MEMBER_FLAG='Y' OR (NVL(ROLEB.MEMBER_FLAG
, 'N') ='N'
AND ROLEB.MANAGER_FLAG='Y'))