View: OKL_INDUSTRY_CODE_TYPES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for industry type codes (SIC code types)
Implementation/DBA Data:	APPS.OKL_INDUSTRY_CODE_TYPES_UV

View Text

SELECT IDTY.LOOKUP_CODE INDUSTRY_CODE_TYPE
, IDTY.MEANING INDUSTRY_CODE_TYPE_MEANING
, IDTY.DESCRIPTION INDUSTRY_CODE_TYPE_DESC
FROM AR_LOOKUPS IDTY
WHERE IDTY.LOOKUP_TYPE = 'SIC_CODE_TYPE'
AND EXISTS (SELECT 1
FROM AR_LOOKUPS IDTC
WHERE IDTC.LOOKUP_TYPE = IDTY.LOOKUP_CODE)

Columns