VIEW: APPS.CN_SPQ_LOV_V

Source

View Text - Preformatted

SELECT sqa.srp_quota_assign_id, sqa.quota_id, q.name quota_name, sqa.srp_plan_assign_id, spa.salesrep_id, spa.role_id, spa.comp_plan_id, spa.start_date, spa.end_date, r.name role_name, c.name plan_name, s.name, s.employee_number FROM cn_srp_quota_assigns sqa, cn_srp_plan_assigns spa, cn_quotas q, cn_roles r, cn_salesreps s, cn_comp_plans c WHERE sqa.srp_plan_assign_id = spa.srp_plan_assign_id AND sqa.quota_id = q.quota_id AND spa.role_id = r.role_id AND spa.comp_plan_id = c.comp_plan_id AND spa.salesrep_id = s.salesrep_id ORDER BY s.name

View Text - HTML Formatted

SELECT SQA.SRP_QUOTA_ASSIGN_ID
, SQA.QUOTA_ID
, Q.NAME QUOTA_NAME
, SQA.SRP_PLAN_ASSIGN_ID
, SPA.SALESREP_ID
, SPA.ROLE_ID
, SPA.COMP_PLAN_ID
, SPA.START_DATE
, SPA.END_DATE
, R.NAME ROLE_NAME
, C.NAME PLAN_NAME
, S.NAME
, S.EMPLOYEE_NUMBER
FROM CN_SRP_QUOTA_ASSIGNS SQA
, CN_SRP_PLAN_ASSIGNS SPA
, CN_QUOTAS Q
, CN_ROLES R
, CN_SALESREPS S
, CN_COMP_PLANS C
WHERE SQA.SRP_PLAN_ASSIGN_ID = SPA.SRP_PLAN_ASSIGN_ID
AND SQA.QUOTA_ID = Q.QUOTA_ID
AND SPA.ROLE_ID = R.ROLE_ID
AND SPA.COMP_PLAN_ID = C.COMP_PLAN_ID
AND SPA.SALESREP_ID = S.SALESREP_ID ORDER BY S.NAME