VIEW: APPS.OKL_POOL_ASSETS_LOV_UV

Source

View Text - Preformatted

SELECT FAAB.ASSET_ID ASSET_ID, FAAB.ASSET_NUMBER ASSET_NUMBER, FAAT.DESCRIPTION DESCRIPTION FROM OKC_K_HEADERS_B CHRB,OKC_K_LINES_B CLEB,OKC_K_ITEMS CITB,FA_ADDITIONS_B FAAB,FA_ADDITIONS_TL FAAT,OKC_LINE_STYLES_B LSEB WHERE CLEB.DNZ_CHR_ID = CHRB.ID AND CHRB.STS_CODE = 'BOOKED' AND CHRB.SCS_CODE = 'LEASE' AND CITB.OBJECT1_ID1 = TO_CHAR(FAAB.ASSET_ID) AND CITB.OBJECT1_ID2 = '#' AND CITB.JTOT_OBJECT1_CODE = 'OKX_ASSET' AND CITB.CLE_ID = CLEB.ID AND CITB.DNZ_CHR_ID = CLEB.DNZ_CHR_ID AND LSEB.ID = CLEB.LSE_ID AND LSEB.LTY_CODE = 'FIXED_ASSET' AND FAAT.ASSET_ID = FAAB.ASSET_ID AND FAAT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT FAAB.ASSET_ID ASSET_ID
, FAAB.ASSET_NUMBER ASSET_NUMBER
, FAAT.DESCRIPTION DESCRIPTION
FROM OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_K_ITEMS CITB
, FA_ADDITIONS_B FAAB
, FA_ADDITIONS_TL FAAT
, OKC_LINE_STYLES_B LSEB
WHERE CLEB.DNZ_CHR_ID = CHRB.ID
AND CHRB.STS_CODE = 'BOOKED'
AND CHRB.SCS_CODE = 'LEASE'
AND CITB.OBJECT1_ID1 = TO_CHAR(FAAB.ASSET_ID)
AND CITB.OBJECT1_ID2 = '#'
AND CITB.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CITB.CLE_ID = CLEB.ID
AND CITB.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'FIXED_ASSET'
AND FAAT.ASSET_ID = FAAB.ASSET_ID
AND FAAT.LANGUAGE = USERENV('LANG')