View: AS_SALESFORCE_SUB_V

Product:	AS - Sales Foundation
Description:	This view shows all the salesforce from JTF resource manager who are members or managers
Implementation/DBA Data:	APPS.AS_SALESFORCE_SUB_V

View Text

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

Columns