View: AST_RES_TEAM_MEMBERS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_RES_TEAM_MEMBERS_V

View Text

SELECT TM.TEAM_ID
, RES.RESOURCE_ID
, RES.SOURCE_ID
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_NAME
, RES.CATEGORY
, RES.SOURCE_JOB_TITLE
, RES.SOURCE_PHONE
, RES.SOURCE_EMAIL
, NULL
, NULL
FROM JTF_RS_TEAMS_TL TM
, JTF_RS_TEAM_USAGES UA
, JTF_RS_TEAM_MEMBERS MM
, JTF_RS_ROLE_RELATIONS REL
, JTF_RS_ROLES_B ROL
, JTF_RS_RESOURCE_EXTNS RES
, JTF_OBJECTS_TL OBJ
WHERE MM.RESOURCE_TYPE = 'INDIVIDUAL'
AND UA.TEAM_ID = TM.TEAM_ID
AND UA.USAGE = 'SALES'
AND TM.TEAM_ID = MM.TEAM_ID
AND TM.LANGUAGE = USERENV('LANG')
AND MM.DELETE_FLAG <> 'Y'
AND REL.ROLE_RESOURCE_ID = MM.TEAM_MEMBER_ID
AND REL.DELETE_FLAG <> 'Y'
AND REL.ROLE_RESOURCE_TYPE = 'RS_TEAM_MEMBER'
AND REL.ROLE_ID = ROL.ROLE_ID
AND MM.TEAM_RESOURCE_ID = RES.RESOURCE_ID
AND OBJ.OBJECT_CODE = RES.CATEGORY
AND OBJ.LANGUAGE = USERENV('LANG')
AND ROL.MEMBER_FLAG = 'Y'
AND SYSDATE BETWEEN REL.START_DATE_ACTIVE
AND NVL(REL.END_DATE_ACTIVE
, SYSDATE)
AND ROL.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM')
AND RES.CATEGORY IN ('EMPLOYEE'
, 'PARTNER')
AND RES.SOURCE_NAME IS NOT NULL

Columns