VIEW: APPS.OKL_SO_RESI_VALUES_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')