[Home] [Help]
View: OKL_POOL_ASSETS_LOV_UV
Product: | OKL - Lease and Finance Management |
Description: | Securitization - Pool asset lists of values UI view |
Implementation/DBA Data: |
APPS.OKL_POOL_ASSETS_LOV_UV
|
View Text
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')
Columns
Name |
ASSET_ID |
ASSET_NUMBER |
DESCRIPTION |