View: OKL_SPLIT_ASSET_TRX_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for Split Asset Data Object
Implementation/DBA Data:	APPS.OKL_SPLIT_ASSET_TRX_UV

View Text

SELECT ASDB.ID ID
, ASDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASDTL.SFWT_FLAG SFWT_FLAG
, ASDB.TAL_ID TAL_ID
, ASDB.TARGET_KLE_ID TARGET_KLE_ID
, ASDB.LINE_DETAIL_NUMBER LINE_DETAIL_NUMBER
, ASDB.ASSET_NUMBER ASSET_NUMBER
, ASDTL.DESCRIPTION DESCRIPTION
, ASDB.QUANTITY QUANTITY
, KLEB_TOP.OEC * (ASDB.QUANTITY/TALB.CURRENT_UNITS) COST
, ASDB.TAX_BOOK TAX_BOOK
, ASDB.LIFE_IN_MONTHS_TAX LIFE_IN_MONTHS_TAX
, ASDB.DEPRN_METHOD_TAX DEPRN_METHOD_TAX
, ASDB.DEPRN_RATE_TAX DEPRN_RATE_TAX
, ASDB.SALVAGE_VALUE SALVAGE_VALUE
, ASDB.SPLIT_PERCENT SPLIT_PERCENT
, ASDB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ASDB.CURRENCY_CODE
, ASDB.CURRENCY_CONVERSION_TYPE
, ASDB.CURRENCY_CONVERSION_RATE
, ASDB.CURRENCY_CONVERSION_DATE
, MTL.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
FROM OKL_TXD_ASSETS_B ASDB
, OKL_TXD_ASSETS_TL ASDTL
, OKL_TXL_ASSETS_B TALB
, OKL_TRX_ASSETS TASB
, OKC_K_LINES_B CLEB
, OKC_K_LINES_B CLEB_TOP
, OKL_K_LINES KLEB_TOP
, MTL_SYSTEM_ITEMS_B MTL
, OKC_K_ITEMS MODEL_CIM
, OKC_K_LINES_B MODEL_CLE
WHERE ASDB.ID = ASDTL.ID
AND ASDTL.LANGUAGE = USERENV('LANG')
AND TALB.ID = ASDB.TAL_ID
AND TALB.TAL_TYPE = 'ALI'
AND TASB.ID = TALB.TAS_ID
AND TASB.TAS_TYPE = 'ALI'
AND TASB.TSU_CODE = 'ENTERED'
AND CLEB.ID = TALB.KLE_ID
AND CLEB_TOP.ID = CLEB.CLE_ID
AND KLEB_TOP.ID = CLEB_TOP.ID
AND TO_CHAR(MTL.ORGANIZATION_ID)=MODEL_CIM.OBJECT1_ID2
AND MODEL_CIM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND MODEL_CIM.CLE_ID = MODEL_CLE.ID
AND MODEL_CIM.DNZ_CHR_ID = MODEL_CLE.DNZ_CHR_ID
AND MODEL_CIM.OBJECT1_ID1=MTL.INVENTORY_ITEM_ID
AND CLEB_TOP.ID=MODEL_CLE.CLE_ID
AND MODEL_CLE.LSE_ID=34

Columns