VIEW: APPS.CN_SRP_ROLE_PLANS_V

Source

View Text - Preformatted

SELECT s.srp_role_id, s.salesrep_id, s.role_id, s.start_date, s.end_date, r.name, r.description, p.role_plan_id, p.comp_plan_id, p.start_date, p.end_date from cn_srp_roles s, cn_roles r, cn_role_plans p WHERE s.role_id = r.role_id and r.role_id = p.role_id

View Text - HTML Formatted

SELECT S.SRP_ROLE_ID
, S.SALESREP_ID
, S.ROLE_ID
, S.START_DATE
, S.END_DATE
, R.NAME
, R.DESCRIPTION
, P.ROLE_PLAN_ID
, P.COMP_PLAN_ID
, P.START_DATE
, P.END_DATE
FROM CN_SRP_ROLES S
, CN_ROLES R
, CN_ROLE_PLANS P
WHERE S.ROLE_ID = R.ROLE_ID
AND R.ROLE_ID = P.ROLE_ID