VIEW: APPS.CN_WKSHT_BONUS_QUOTA_V

Source

View Text - Preformatted

SELECT cq.name quota, ccp.comp_plan_id, ccp.name comp_plan, csr.salesrep_id, csr.role_id, csr.start_date, csr.end_date, cq.quota_id, cq.credit_type_id, cspa.srp_plan_assign_id, cspa.org_id FROM cn_srp_roles csr, cn_srp_plan_assigns cspa, cn_srp_quota_assigns csqa, cn_quotas cq, cn_comp_plans ccp WHERE csr.srp_role_id = cspa.srp_role_id AND csr.org_id = cspa.org_id AND cspa.srp_plan_assign_id = csqa.srp_plan_assign_id AND csqa.quota_id = cq.quota_id AND cspa.comp_plan_id = ccp.comp_plan_id AND cq.incentive_type_code = 'MANUAL'

View Text - HTML Formatted

SELECT CQ.NAME QUOTA
, CCP.COMP_PLAN_ID
, CCP.NAME COMP_PLAN
, CSR.SALESREP_ID
, CSR.ROLE_ID
, CSR.START_DATE
, CSR.END_DATE
, CQ.QUOTA_ID
, CQ.CREDIT_TYPE_ID
, CSPA.SRP_PLAN_ASSIGN_ID
, CSPA.ORG_ID
FROM CN_SRP_ROLES CSR
, CN_SRP_PLAN_ASSIGNS CSPA
, CN_SRP_QUOTA_ASSIGNS CSQA
, CN_QUOTAS CQ
, CN_COMP_PLANS CCP
WHERE CSR.SRP_ROLE_ID = CSPA.SRP_ROLE_ID
AND CSR.ORG_ID = CSPA.ORG_ID
AND CSPA.SRP_PLAN_ASSIGN_ID = CSQA.SRP_PLAN_ASSIGN_ID
AND CSQA.QUOTA_ID = CQ.QUOTA_ID
AND CSPA.COMP_PLAN_ID = CCP.COMP_PLAN_ID
AND CQ.INCENTIVE_TYPE_CODE = 'MANUAL'