VIEW: APPS.OKL_SIF_ASSETS_UV

Source

View Text - Preformatted

SELECT CHRB.ID KHR_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CLEB.ID KLE_ID, CLET.NAME ASSET_NUMBER FROM OKC_K_LINES_TL CLET,OKC_K_HEADERS_B CHRB,OKC_K_LINES_B CLEB,OKC_LINE_STYLES_B LSEB WHERE CLEB.DNZ_CHR_ID = CHRB.ID AND CLEB.CHR_ID = CHRB.ID AND CLEB.LSE_ID = LSEB.ID AND LSEB.LTY_CODE = 'FREE_FORM1' AND CLET.ID = CLEB.ID AND CLET.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CHRB.ID KHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLEB.ID KLE_ID
, CLET.NAME ASSET_NUMBER
FROM OKC_K_LINES_TL CLET
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
WHERE CLEB.DNZ_CHR_ID = CHRB.ID
AND CLEB.CHR_ID = CHRB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'FREE_FORM1'
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')