VIEW: APPS.FII_AR_SIC_CODE_BASE_V

Source

View Text - Preformatted

SELECT distinct(sic_code) sic_code, max(last_update_date) last_update_date from HZ_PARTIES WHERE sic_code is not null group by sic_code union all select distinct(sic_code) sic_code, max(last_update_date) last_update_date from HZ_CUST_SITE_USES_ALL where sic_code is not null group by sic_code union all select distinct(standard_industry_class) sic_code, max(last_update_date) last_update_date from po_vendors where standard_industry_class is not null group by standard_industry_class

View Text - HTML Formatted

SELECT DISTINCT(SIC_CODE) SIC_CODE
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM HZ_PARTIES
WHERE SIC_CODE IS NOT NULL GROUP BY SIC_CODE UNION ALL SELECT DISTINCT(SIC_CODE) SIC_CODE
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM HZ_CUST_SITE_USES_ALL
WHERE SIC_CODE IS NOT NULL GROUP BY SIC_CODE UNION ALL SELECT DISTINCT(STANDARD_INDUSTRY_CLASS) SIC_CODE
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM PO_VENDORS
WHERE STANDARD_INDUSTRY_CLASS IS NOT NULL GROUP BY STANDARD_INDUSTRY_CLASS