[Home] [Help]
View: OKL_VENDOR_TYPES_UV
Product: | OKL - Leasing and Finance Management |
Description: | User interface view to select role type for vendor billing setup page |
Implementation/DBA Data: |
APPS.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