View: OKL_SPLIT_ASSET_COMP_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view used in assets lov on split asset into components page
Implementation/DBA Data:	APPS.OKL_SPLIT_ASSET_COMP_UV

View Text

SELECT TDAS.ID ID
, CLE.CLE_ID TOP_CLE_ID
, TAL.KLE_ID FA_CLE_ID
, TDAS.TAL_ID TAL_ID
, TDAS.ASSET_NUMBER ASSET_NUMBER
, TDAS.DESCRIPTION DESCRIPTION
, TDAS.QUANTITY QUANTITY
, TDAS.COST COST
, TDAS.SPLIT_PERCENT SPLIT_PERCENT
, TDAS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, I.NAME INVENTORY_ITEM_NAME
, I.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, I.ID2 INVENTORY_ORG_ID
FROM OKL_TXD_ASSETS_V TDAS
, OKL_TXL_ASSETS_B TAL
, OKX_SYSTEM_ITEMS_V I
, OKC_K_LINES_B CLE
WHERE CLE.ID = TAL.KLE_ID
AND TDAS.INVENTORY_ITEM_ID = I.ID1
AND TAL.ID = TDAS.TAL_ID
AND TAL.TAL_TYPE = 'ALI'
AND EXISTS (SELECT '1'
FROM OKL_TRX_ASSETS TAS
WHERE TAS.ID = TAL.TAS_ID
AND TAS.TAS_TYPE = 'ALI'
AND TAS.TSU_CODE = 'ENTERED')

Columns