VIEW: APPS.CN_PLAN_QUOTA_LOV_V

Source

View Text - Preformatted

SELECT qa.quota_assign_id, qa.quota_id, qa.comp_plan_id, q.name quota_name, c.name plan_name FROM cn_quota_assigns qa, cn_quotas q, cn_comp_plans c WHERE qa.quota_id = q.quota_id AND qa.comp_plan_id = c.comp_plan_id

View Text - HTML Formatted

SELECT QA.QUOTA_ASSIGN_ID
, QA.QUOTA_ID
, QA.COMP_PLAN_ID
, Q.NAME QUOTA_NAME
, C.NAME PLAN_NAME
FROM CN_QUOTA_ASSIGNS QA
, CN_QUOTAS Q
, CN_COMP_PLANS C
WHERE QA.QUOTA_ID = Q.QUOTA_ID
AND QA.COMP_PLAN_ID = C.COMP_PLAN_ID