View: OKL_POOL_ASSETS_UV

Product:	OKL - Leasing and Finance Management
Description:	Securitization - Pool Assets UI view
Implementation/DBA Data:	APPS.OKL_POOL_ASSETS_UV

View Text

SELECT CLET.DNZ_CHR_ID DNZ_CHR_ID
, CLET.ID KLE_ID
, ASTV.ASSET_ID ASSET_ID
, ASTV.ASSET_NUMBER ASSET_NUMBER
, ASTV.MODEL_NUMBER MODEL_NUMBER
, ASTV.MANUFACTURER_NAME MANUFACTURER_NAME
, SITM.ID1 ITEM_ID1
, OKVV.ID1 VENDOR_ID1
, KLET.OEC OEC
, KLET.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
FROM OKC_K_ITEMS CIMA
, OKX_ASSETS_V ASTV
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS CITM
, OKX_SYSTEM_ITEMS_V SITM
, OKC_K_LINES_B CLEI
, OKC_LINE_STYLES_B LSEI
, OKC_K_PARTY_ROLES_B CPLB
, OKX_VENDORS_V OKVV
, OKC_K_LINES_B CLET
, OKL_K_LINES KLET
, OKC_LINE_STYLES_B LSET
WHERE CIMA.OBJECT1_ID1 = ASTV.ID1
AND CIMA.OBJECT1_ID2 = ASTV.ID2
AND CIMA.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIMA.CLE_ID = CLEB.ID
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'FIXED_ASSET'
AND CITM.OBJECT1_ID1 = SITM.ID1
AND CITM.OBJECT1_ID2 = TO_CHAR(SITM.ID2)
AND CITM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND CITM.CLE_ID = CLEI.ID
AND LSEI.ID = CLEI.LSE_ID
AND LSEI.LTY_CODE = 'ITEM'
AND CLEI.CLE_ID = CLEB.CLE_ID
AND CLEI.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND CPLB.DNZ_CHR_ID(+) = CLEI.DNZ_CHR_ID
AND CPLB.CLE_ID(+) = CLEI.ID
AND CPLB.OBJECT1_ID1 = OKVV.ID1(+)
AND CPLB.OBJECT1_ID2 = OKVV.ID2(+)
AND CPLB.RLE_CODE(+) = 'OKL_VENDOR'
AND CLET.ID = CLEB.CLE_ID
AND LSET.ID = CLET.LSE_ID
AND LSET.LTY_CODE = 'FREE_FORM1'
AND KLET.ID = CLET.ID

Columns