VIEW: APPS.CN_QUOTA_ASSIGNS_V

Source

View Text - Preformatted

SELECT q.name quota_name, q.quota_id quota_id, q.start_date start_date, q.end_date end_date , qa.quota_assign_id quota_assign_id, c.name plan_name, qa.comp_plan_id comp_plan_id, qa.creation_date, qa.created_by , qa.last_update_date , qa.last_updated_by , qa.last_update_login FROM CN_QUOTAS Q,CN_QUOTA_ASSIGNS QA, cn_comp_plans c WHERE q.quota_id = qa.quota_id and qa.comp_plan_id = c.comp_plan_id(+)

View Text - HTML Formatted

SELECT Q.NAME QUOTA_NAME
, Q.QUOTA_ID QUOTA_ID
, Q.START_DATE START_DATE
, Q.END_DATE END_DATE
, QA.QUOTA_ASSIGN_ID QUOTA_ASSIGN_ID
, C.NAME PLAN_NAME
, QA.COMP_PLAN_ID COMP_PLAN_ID
, QA.CREATION_DATE
, QA.CREATED_BY
, QA.LAST_UPDATE_DATE
, QA.LAST_UPDATED_BY
, QA.LAST_UPDATE_LOGIN
FROM CN_QUOTAS Q
, CN_QUOTA_ASSIGNS QA
, CN_COMP_PLANS C
WHERE Q.QUOTA_ID = QA.QUOTA_ID
AND QA.COMP_PLAN_ID = C.COMP_PLAN_ID(+)