VIEW: APPS.OKL_ASSETS_LOV_UV

Source

View Text - Preformatted

SELECT cle.id cle_id, cle.dnz_chr_id chr_id, tl.name asset_number, tl.item_description description FROM OKC_K_HEADERS_B CHR,OKC_LINE_STYLES_B LSE,OKC_K_LINES_B CLE,OKC_STATUSES_B STS,OKC_K_LINES_TL TL WHERE chr.id = cle.dnz_chr_id and chr.scs_code in ( 'LEASE','QUOTE') and cle.id = tl.id and STS.CODE = cle.sts_code and STS.STE_CODE not in ('HOLD','EXPIRED','TERMINATED','CANCELLED') and tl.language=userenv('LANG') and lse.id = cle.lse_id and lse.lty_code = 'FREE_FORM1'

View Text - HTML Formatted

SELECT CLE.ID CLE_ID
, CLE.DNZ_CHR_ID CHR_ID
, TL.NAME ASSET_NUMBER
, TL.ITEM_DESCRIPTION DESCRIPTION
FROM OKC_K_HEADERS_B CHR
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_B CLE
, OKC_STATUSES_B STS
, OKC_K_LINES_TL TL
WHERE CHR.ID = CLE.DNZ_CHR_ID
AND CHR.SCS_CODE IN ( 'LEASE'
, 'QUOTE')
AND CLE.ID = TL.ID
AND STS.CODE = CLE.STS_CODE
AND STS.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'TERMINATED'
, 'CANCELLED')
AND TL.LANGUAGE=USERENV('LANG')
AND LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'FREE_FORM1'