eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_INDUSTRY_CODES_UV

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'