View: OKL_INDUSTRY_CODES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for industry codes(SIC Codes) LOV
Implementation/DBA Data:	APPS.OKL_INDUSTRY_CODES_UV

View Text

SELECT IDTC.LOOKUP_CODE INDUSTRY_CODE
, IDTC.MEANING INDUSTRY_CODE_MEANING
, IDTC.DESCRIPTION INDUSTRY_CODE_DESC
, IDTY.LOOKUP_CODE INDUSTRY_CODE_TYPE
FROM AR_LOOKUPS IDTY
, AR_LOOKUPS IDTC
WHERE IDTC.LOOKUP_TYPE = IDTY.LOOKUP_CODE
AND IDTY.LOOKUP_TYPE = 'SIC_CODE_TYPE'

Columns