VIEW: APPS.OKL_LA_INACTIVE_ASST_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')