VIEW: APPS.CN_SVC_GRP_ASSIGNS

Source

View Text - Preformatted

SELECT TM.TEAM_ID SERVICE_GROUP_ID, E.USER_ID ANALYST_ID, RR.START_DATE_ACTIVE START_DATE, RR.END_DATE_ACTIVE END_DATE from jtf_rs_team_usages u, jtf_rs_team_members tm, jtf_rs_role_relations rr, jtf_rs_roles_vl r, jtf_rs_resource_extns e WHERE U.TEAM_ID = TM.TEAM_ID AND U.USAGE = 'SALES_COMP' AND TM.TEAM_MEMBER_ID = RR.ROLE_RESOURCE_ID AND RR.ROLE_RESOURCE_TYPE = 'RS_TEAM_MEMBER' AND RR.ROLE_ID = R.ROLE_ID AND R.ADMIN_FLAG = 'Y' AND E.RESOURCE_ID = TM.TEAM_RESOURCE_ID AND TM.RESOURCE_TYPE = 'RS_INDIVIDUAL'

View Text - HTML Formatted

SELECT TM.TEAM_ID SERVICE_GROUP_ID
, E.USER_ID ANALYST_ID
, RR.START_DATE_ACTIVE START_DATE
, RR.END_DATE_ACTIVE END_DATE
FROM JTF_RS_TEAM_USAGES U
, JTF_RS_TEAM_MEMBERS TM
, JTF_RS_ROLE_RELATIONS RR
, JTF_RS_ROLES_VL R
, JTF_RS_RESOURCE_EXTNS E
WHERE U.TEAM_ID = TM.TEAM_ID
AND U.USAGE = 'SALES_COMP'
AND TM.TEAM_MEMBER_ID = RR.ROLE_RESOURCE_ID
AND RR.ROLE_RESOURCE_TYPE = 'RS_TEAM_MEMBER'
AND RR.ROLE_ID = R.ROLE_ID
AND R.ADMIN_FLAG = 'Y'
AND E.RESOURCE_ID = TM.TEAM_RESOURCE_ID
AND TM.RESOURCE_TYPE = 'RS_INDIVIDUAL'