SELECT lup.lookup_code, lup.meaning, scr.scs_code FROM FND_LOOKUPS LUP,OKC_SUBCLASS_ROLES SCR WHERE lup.lookup_type = 'OKC_ROLE' and scr.rle_code = lup.lookup_code and lup.lookup_code <> 'LESSEE'
View Text - HTML Formatted
SELECT LUP.LOOKUP_CODE , LUP.MEANING , SCR.SCS_CODE FROM FND_LOOKUPS LUP , OKC_SUBCLASS_ROLES SCR WHERE LUP.LOOKUP_TYPE = 'OKC_ROLE' AND SCR.RLE_CODE = LUP.LOOKUP_CODE AND LUP.LOOKUP_CODE <> 'LESSEE'