VIEW: APPS.OKL_LA_ASSET_CAT_UV

Source

View Text - Preformatted

SELECT clt.id top_line, clt.name asset_number, clt.item_description description, kle.oec oec, kle.residual_value residual_value, mtl.asset_category_id asset_category_id, cle_fl.id fixed_asset_line, cle_ml.id model_line, txl.used_asset_yn used_asset_yn, cle.dnz_chr_id dnz_chr_id FROM OKL_TXL_ASSETS_B TXL,OKC_LINE_STYLES_B LSE_FL,OKC_K_LINES_B CLE_FL,OKC_LINE_STYLES_B LSE_ML,MTL_SYSTEM_ITEMS_B MTL,OKC_K_ITEMS CIM,OKC_K_LINES_B CLE_ML,OKC_LINE_STYLES_B LSE,OKL_K_LINES KLE,OKC_K_LINES_TL CLT,OKC_K_LINES_B CLE WHERE cle.cle_id is null and cle.chr_id = cle.dnz_chr_id and clt.id = kle.id and clt.language = USERENV('LANG') and kle.id = cle.id and lse.id = cle.lse_id and lse.lty_code = 'FREE_FORM1' and cle_ml.cle_id = cle.id and cle_ml.dnz_chr_id = cle.dnz_chr_id and cim.cle_id = cle_ml.id and cim.dnz_chr_id = cle_ml.dnz_chr_id and mtl.inventory_item_id = cim.object1_id1 and to_char(mtl.organization_id) = cim.object1_id2 and lse_ml.id = cle_ml.lse_id and lse_ml.lty_code = 'ITEM' and cle_fl.cle_id = cle.id and cle_fl.dnz_chr_id = cle.dnz_chr_id and cle_fl.lse_id = lse_fl.id and lse_fl.lty_code = 'FIXED_ASSET' and txl.kle_id = cle_fl.id

View Text - HTML Formatted

SELECT CLT.ID TOP_LINE
, CLT.NAME ASSET_NUMBER
, CLT.ITEM_DESCRIPTION DESCRIPTION
, KLE.OEC OEC
, KLE.RESIDUAL_VALUE RESIDUAL_VALUE
, MTL.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, CLE_FL.ID FIXED_ASSET_LINE
, CLE_ML.ID MODEL_LINE
, TXL.USED_ASSET_YN USED_ASSET_YN
, CLE.DNZ_CHR_ID DNZ_CHR_ID
FROM OKL_TXL_ASSETS_B TXL
, OKC_LINE_STYLES_B LSE_FL
, OKC_K_LINES_B CLE_FL
, OKC_LINE_STYLES_B LSE_ML
, MTL_SYSTEM_ITEMS_B MTL
, OKC_K_ITEMS CIM
, OKC_K_LINES_B CLE_ML
, OKC_LINE_STYLES_B LSE
, OKL_K_LINES KLE
, OKC_K_LINES_TL CLT
, OKC_K_LINES_B CLE
WHERE CLE.CLE_ID IS NULL
AND CLE.CHR_ID = CLE.DNZ_CHR_ID
AND CLT.ID = KLE.ID
AND CLT.LANGUAGE = USERENV('LANG')
AND KLE.ID = CLE.ID
AND LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND CLE_ML.CLE_ID = CLE.ID
AND CLE_ML.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.CLE_ID = CLE_ML.ID
AND CIM.DNZ_CHR_ID = CLE_ML.DNZ_CHR_ID
AND MTL.INVENTORY_ITEM_ID = CIM.OBJECT1_ID1
AND TO_CHAR(MTL.ORGANIZATION_ID) = CIM.OBJECT1_ID2
AND LSE_ML.ID = CLE_ML.LSE_ID
AND LSE_ML.LTY_CODE = 'ITEM'
AND CLE_FL.CLE_ID = CLE.ID
AND CLE_FL.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CLE_FL.LSE_ID = LSE_FL.ID
AND LSE_FL.LTY_CODE = 'FIXED_ASSET'
AND TXL.KLE_ID = CLE_FL.ID