VIEW: APPS.AST_RES_TEAM_MEMBERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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