VIEW: APPS.CN_SRP_PLAN_ASSIGNS_V

Source

View Text - Preformatted

SELECT s.name ,pa.salesrep_id ,s.employee_number , p.name ,pa.comp_plan_id ,pa.start_date,pa.end_date,lc.meaning , pa.srp_plan_assign_id , p.start_date ,p.end_date , p.description ,p.allow_rev_class_overlap , pa.srp_role_id, pa.role_plan_id, sr.name, pa.creation_date ,pa.last_update_date ,pa.last_updated_by , pa.last_update_login ,pa.created_by FROM CN_LOOKUPS LC,CN_COMP_PLANS P,CN_SALESREPS S,CN_SRP_PLAN_ASSIGNS PA,CN_SRP_ROLES_V SR WHERE pa.salesrep_id = s.salesrep_id AND p.status_code = lc.lookup_code AND lc.lookup_type = 'PLAN_OBJECT_STATUS' AND pa.comp_plan_id = p.comp_plan_id AND pa.srp_role_id = sr.srp_role_id

View Text - HTML Formatted

SELECT S.NAME
, PA.SALESREP_ID
, S.EMPLOYEE_NUMBER
, P.NAME
, PA.COMP_PLAN_ID
, PA.START_DATE
, PA.END_DATE
, LC.MEANING
, PA.SRP_PLAN_ASSIGN_ID
, P.START_DATE
, P.END_DATE
, P.DESCRIPTION
, P.ALLOW_REV_CLASS_OVERLAP
, PA.SRP_ROLE_ID
, PA.ROLE_PLAN_ID
, SR.NAME
, PA.CREATION_DATE
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.CREATED_BY
FROM CN_LOOKUPS LC
, CN_COMP_PLANS P
, CN_SALESREPS S
, CN_SRP_PLAN_ASSIGNS PA
, CN_SRP_ROLES_V SR
WHERE PA.SALESREP_ID = S.SALESREP_ID
AND P.STATUS_CODE = LC.LOOKUP_CODE
AND LC.LOOKUP_TYPE = 'PLAN_OBJECT_STATUS'
AND PA.COMP_PLAN_ID = P.COMP_PLAN_ID
AND PA.SRP_ROLE_ID = SR.SRP_ROLE_ID