VIEW: APPS.IMC_INDUSTRY_CHART_V

Source

View Text - Preformatted

SELECT meaning Category, a.category_code, a.customers from (select category_code, count(*) customers from hz_parties where party_type = 'ORGANIZATION' group by category_code) a, ar_lookups WHERE ar_lookups.lookup_type (+) = 'CUSTOMER_CATEGORY' and ar_lookups.lookup_code (+) = a.category_code order by a.customers desc

View Text - HTML Formatted

SELECT MEANING CATEGORY
, A.CATEGORY_CODE
, A.CUSTOMERS
FROM (SELECT CATEGORY_CODE
, COUNT(*) CUSTOMERS
FROM HZ_PARTIES
WHERE PARTY_TYPE = 'ORGANIZATION' GROUP BY CATEGORY_CODE) A
, AR_LOOKUPS
WHERE AR_LOOKUPS.LOOKUP_TYPE (+) = 'CUSTOMER_CATEGORY'
AND AR_LOOKUPS.LOOKUP_CODE (+) = A.CATEGORY_CODE ORDER BY A.CUSTOMERS DESC