View: OKL_LA_INACTIVE_ASST_UV

Product:	OKL - Leasing and Finance Management
Description:	User Interface view for inactive assets
Implementation/DBA Data:	APPS.OKL_LA_INACTIVE_ASST_UV

View Text

SELECT CLE.ID ID1
, '#' ID2
, LINE_TL.NAME NAME
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, TAL.ASSET_NUMBER ASSET_NUMBER
, TL.DESCRIPTION ITEM_DESCRIPTION
, TAL.CURRENT_UNITS CURRENT_UNITS
, TAL.DEPRECIATION_COST COST
, TAL.MANUFACTURER_NAME MANUFACTURER_NAME
, CLE.CLE_ID PARENT_LINE_ID
FROM OKL_TRX_TYPES_TL TRY
, OKL_TRX_ASSETS TAS
, OKL_TXL_ASSETS_B TAL
, OKL_TXL_ASSETS_TL TL
, OKC_STATUSES_B STS
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL LINE_TL
WHERE TAS.TRY_ID = TRY.ID
AND TRY.NAME = 'INTERNAL ASSET CREATION'
AND TRY.LANGUAGE = 'US'
AND TAS.ID = TAL.TAS_ID
AND TAS.TSU_CODE <> 'PROCESSED'
AND TL.ID = TAL.ID
AND TL.LANGUAGE= USERENV('LANG')
AND CLE.ID = TAL.KLE_ID
AND STS.CODE = CLE.STS_CODE
AND STS.STE_CODE NOT IN ('ACTIVE'
, 'HOLD'
, 'EXPIRED'
, 'TERMINATED'
, 'CANCELED')
AND LINE_TL.ID = CLE.CLE_ID
AND LINE_TL.LANGUAGE = USERENV('LANG')

Columns