VIEW: APPS.CN_SRP_PLAN_LOV_V

Source

View Text - Preformatted

SELECT spa.srp_plan_assign_id, spa.salesrep_id, spa.role_id, spa.comp_plan_id, spa.start_date, spa.end_date, s.employee_number, s.name rep_name, r.name role_name, c.name plan_name FROM cn_srp_plan_assigns spa, cn_salesreps s, cn_roles r, cn_comp_plans c WHERE spa.salesrep_id = s.salesrep_id AND spa.role_id = r.role_id AND spa.comp_plan_id = c.comp_plan_id ORDER BY s.name, r.name, c.name

View Text - HTML Formatted

SELECT SPA.SRP_PLAN_ASSIGN_ID
, SPA.SALESREP_ID
, SPA.ROLE_ID
, SPA.COMP_PLAN_ID
, SPA.START_DATE
, SPA.END_DATE
, S.EMPLOYEE_NUMBER
, S.NAME REP_NAME
, R.NAME ROLE_NAME
, C.NAME PLAN_NAME
FROM CN_SRP_PLAN_ASSIGNS SPA
, CN_SALESREPS S
, CN_ROLES R
, CN_COMP_PLANS C
WHERE SPA.SALESREP_ID = S.SALESREP_ID
AND SPA.ROLE_ID = R.ROLE_ID
AND SPA.COMP_PLAN_ID = C.COMP_PLAN_ID ORDER BY S.NAME
, R.NAME
, C.NAME