VIEW: APPS.CN_COMP_PLANS_SEARCH

Source

View Text - Preformatted

SELECT p.comp_plan_id, p.name plan_name, s.name salesrep_name, r.name role_name, s.salesrep_number employee_number, p.start_date, p.end_date FROM CN_COMP_PLANS P, CN_SRP_PLAN_ASSIGNS PA, CN_RS_SALESREPS S, CN_ROLES R WHERE p.comp_plan_id = pa.comp_plan_id (+) AND pa.salesrep_id = s.salesrep_id (+) AND pa.role_id = r.role_id (+)

View Text - HTML Formatted

SELECT P.COMP_PLAN_ID
, P.NAME PLAN_NAME
, S.NAME SALESREP_NAME
, R.NAME ROLE_NAME
, S.SALESREP_NUMBER EMPLOYEE_NUMBER
, P.START_DATE
, P.END_DATE
FROM CN_COMP_PLANS P
, CN_SRP_PLAN_ASSIGNS PA
, CN_RS_SALESREPS S
, CN_ROLES R
WHERE P.COMP_PLAN_ID = PA.COMP_PLAN_ID (+)
AND PA.SALESREP_ID = S.SALESREP_ID (+)
AND PA.ROLE_ID = R.ROLE_ID (+)