View: OKL_SO_RESI_VALUES_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_SO_RESI_VALUES_UV

View Text

SELECT RLE.ID ID
, RGP.CLE_ID CLE_ID
, CLETL.NAME ASSET_NUMBER
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, RLE.OBJECT1_ID1 OBJECT1_ID1
, RLE.RULE_INFORMATION1 LRF
, RLE.RULE_INFORMATION2 RV_PERCENT
, RLE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKC_K_LINES_TL CLETL
, OKC_RULES_B RLE
, OKC_RULE_GROUPS_B RGP
WHERE RGP.RGD_CODE = 'SOPSAD'
AND RGP.ID = RLE.RGP_ID
AND RLE.JTOT_OBJECT1_CODE = 'OKL_SORULE'
AND RGP.CLE_ID = CLETL.ID
AND CLETL.LANGUAGE = USERENV('LANG')

Columns