[Home] [Help]
View: OKL_LA_INACTIVE_ASST_UV
Product: | OKL - Lease 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
Name |
ID1 |
ID2 |
NAME |
DNZ_CHR_ID |
ASSET_NUMBER |
ITEM_DESCRIPTION |
CURRENT_UNITS |
COST |
MANUFACTURER_NAME |
PARENT_LINE_ID |