VIEW: APPS.CN_SRP_COMP_TEAMS_V

Source

View Text - Preformatted

SELECT tm.team_member_id srp_comp_team_id, tm.team_id comp_team_id, tm.team_resource_id, sr.salesrep_id, nvl(rr.start_date_active, t.start_date_active) start_date_active, nvl(rr.end_date_active, t.end_date_active) end_date_active, sr.org_id FROM jtf_rs_teams_b t, jtf_rs_team_members tm, jtf_rs_salesreps_mo_v sr, jtf_rs_team_usages tu, jtf_rs_role_relations rr, jtf_rs_roles_b rb WHERE tm.resource_type = 'INDIVIDUAL' and tm.delete_flag = 'N' and tu.team_id = tm.team_id and t.team_id = tm.team_id and tu.usage = 'SALES_COMP' and sr.resource_id = tm.team_resource_id and rr.role_resource_id(+) = tm.team_member_id and rr.delete_flag(+) = 'N' and rr.role_resource_type(+) = 'RS_TEAM_MEMBER' and rb.role_id(+) = rr.role_id and rb.role_type_code(+) = 'SALES_COMP'

View Text - HTML Formatted

SELECT TM.TEAM_MEMBER_ID SRP_COMP_TEAM_ID
, TM.TEAM_ID COMP_TEAM_ID
, TM.TEAM_RESOURCE_ID
, SR.SALESREP_ID
, NVL(RR.START_DATE_ACTIVE
, T.START_DATE_ACTIVE) START_DATE_ACTIVE
, NVL(RR.END_DATE_ACTIVE
, T.END_DATE_ACTIVE) END_DATE_ACTIVE
, SR.ORG_ID
FROM JTF_RS_TEAMS_B T
, JTF_RS_TEAM_MEMBERS TM
, JTF_RS_SALESREPS_MO_V SR
, JTF_RS_TEAM_USAGES TU
, JTF_RS_ROLE_RELATIONS RR
, JTF_RS_ROLES_B RB
WHERE TM.RESOURCE_TYPE = 'INDIVIDUAL'
AND TM.DELETE_FLAG = 'N'
AND TU.TEAM_ID = TM.TEAM_ID
AND T.TEAM_ID = TM.TEAM_ID
AND TU.USAGE = 'SALES_COMP'
AND SR.RESOURCE_ID = TM.TEAM_RESOURCE_ID
AND RR.ROLE_RESOURCE_ID(+) = TM.TEAM_MEMBER_ID
AND RR.DELETE_FLAG(+) = 'N'
AND RR.ROLE_RESOURCE_TYPE(+) = 'RS_TEAM_MEMBER'
AND RB.ROLE_ID(+) = RR.ROLE_ID
AND RB.ROLE_TYPE_CODE(+) = 'SALES_COMP'