Skip to content
[Home] [Help]
View: OKL_VENDOR_TYPES_UV
View Text
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'
Columns