VIEW: APPS.CN_QUOTAS_SEARCH

Source

View Text - Preformatted

SELECT q.quota_id quota_id, q.name quota_name, c.name plan_name, q.start_date start_date, q.end_date end_date 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.QUOTA_ID QUOTA_ID
, Q.NAME QUOTA_NAME
, C.NAME PLAN_NAME
, Q.START_DATE START_DATE
, Q.END_DATE END_DATE
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(+)