VIEW: APPS.OKL_NEW_ASSETS_UV

Source

View Text - Preformatted

SELECT clt_fin.name asset_number, kle_fa.year_built year_manufactured, txb.manufacturer_name manufacturer_name, clt_fin.item_description description, cim_ml.number_of_items current_units, kle_fin.oec oec, pv.vendor_name vendor_name, kle_fin.residual_value residual_value, cle_fa.start_date start_date, cle_fa.end_date end_date, cle_fa.date_terminated date_terminated, sts.meaning sts_code, null location_id, cle_fin.id parent_line_id, cle_fin.dnz_chr_id dnz_chr_id, cle_fa.sts_code asset_status_code from okl_txl_assets_b txb, okl_k_lines kle_fa, okc_line_styles_b lse_fa, okc_k_lines_b cle_fa, okc_k_items cim_ml, okc_line_styles_b lse_ml, okc_k_lines_b cle_ml, okl_k_lines kle_fin, okc_line_styles_b lse_fin, okc_k_lines_tl clt_fin, okc_k_lines_b cle_fin, okc_statuses_v sts, po_vendors pv, okc_k_party_roles_b cpl_ml WHERE cle_fin.id = clt_fin.id and clt_fin.language = userenv('LANG') and cle_fin.lse_id = lse_fin.id and lse_fin.lty_code = 'FREE_FORM1' and lse_fin.lse_type = 'TLS' and kle_fin.id = cle_fin.id and cle_fa.cle_id = cle_fin.id and cle_fa.dnz_chr_id = cle_fin.dnz_chr_id and cle_fa.lse_id = lse_fa.id and lse_fa.lty_code = 'FIXED_ASSET' and lse_fa.lse_type = 'SLS' and cle_ml.cle_id = cle_fin.id and cle_ml.dnz_chr_id = cle_fin.dnz_chr_id and cle_ml.lse_id = lse_ml.id and lse_ml.lty_code = 'ITEM' and lse_ml.lse_type = 'SLS' and cim_ml.cle_id = cle_ml.id and cim_ml.dnz_chr_id = cle_ml.dnz_chr_id and cle_fa.id = kle_fa.id and cle_fa.id = txb.kle_id and cle_fa.sts_code = sts.code and cpl_ml.rle_code(+) = 'OKL_VENDOR' and cpl_ml.jtot_object1_code(+) = 'OKX_VENDOR' and cpl_ml.object1_id1 = pv.vendor_id(+) and cpl_ml.object1_id2(+) = '#' and cpl_ml.cle_id(+) = cle_ml.id and cpl_ml.dnz_chr_id(+) = cle_ml.dnz_chr_id

View Text - HTML Formatted

SELECT CLT_FIN.NAME ASSET_NUMBER
, KLE_FA.YEAR_BUILT YEAR_MANUFACTURED
, TXB.MANUFACTURER_NAME MANUFACTURER_NAME
, CLT_FIN.ITEM_DESCRIPTION DESCRIPTION
, CIM_ML.NUMBER_OF_ITEMS CURRENT_UNITS
, KLE_FIN.OEC OEC
, PV.VENDOR_NAME VENDOR_NAME
, KLE_FIN.RESIDUAL_VALUE RESIDUAL_VALUE
, CLE_FA.START_DATE START_DATE
, CLE_FA.END_DATE END_DATE
, CLE_FA.DATE_TERMINATED DATE_TERMINATED
, STS.MEANING STS_CODE
, NULL LOCATION_ID
, CLE_FIN.ID PARENT_LINE_ID
, CLE_FIN.DNZ_CHR_ID DNZ_CHR_ID
, CLE_FA.STS_CODE ASSET_STATUS_CODE
FROM OKL_TXL_ASSETS_B TXB
, OKL_K_LINES KLE_FA
, OKC_LINE_STYLES_B LSE_FA
, OKC_K_LINES_B CLE_FA
, OKC_K_ITEMS CIM_ML
, OKC_LINE_STYLES_B LSE_ML
, OKC_K_LINES_B CLE_ML
, OKL_K_LINES KLE_FIN
, OKC_LINE_STYLES_B LSE_FIN
, OKC_K_LINES_TL CLT_FIN
, OKC_K_LINES_B CLE_FIN
, OKC_STATUSES_V STS
, PO_VENDORS PV
, OKC_K_PARTY_ROLES_B CPL_ML
WHERE CLE_FIN.ID = CLT_FIN.ID
AND CLT_FIN.LANGUAGE = USERENV('LANG')
AND CLE_FIN.LSE_ID = LSE_FIN.ID
AND LSE_FIN.LTY_CODE = 'FREE_FORM1'
AND LSE_FIN.LSE_TYPE = 'TLS'
AND KLE_FIN.ID = CLE_FIN.ID
AND CLE_FA.CLE_ID = CLE_FIN.ID
AND CLE_FA.DNZ_CHR_ID = CLE_FIN.DNZ_CHR_ID
AND CLE_FA.LSE_ID = LSE_FA.ID
AND LSE_FA.LTY_CODE = 'FIXED_ASSET'
AND LSE_FA.LSE_TYPE = 'SLS'
AND CLE_ML.CLE_ID = CLE_FIN.ID
AND CLE_ML.DNZ_CHR_ID = CLE_FIN.DNZ_CHR_ID
AND CLE_ML.LSE_ID = LSE_ML.ID
AND LSE_ML.LTY_CODE = 'ITEM'
AND LSE_ML.LSE_TYPE = 'SLS'
AND CIM_ML.CLE_ID = CLE_ML.ID
AND CIM_ML.DNZ_CHR_ID = CLE_ML.DNZ_CHR_ID
AND CLE_FA.ID = KLE_FA.ID
AND CLE_FA.ID = TXB.KLE_ID
AND CLE_FA.STS_CODE = STS.CODE
AND CPL_ML.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL_ML.JTOT_OBJECT1_CODE(+) = 'OKX_VENDOR'
AND CPL_ML.OBJECT1_ID1 = PV.VENDOR_ID(+)
AND CPL_ML.OBJECT1_ID2(+) = '#'
AND CPL_ML.CLE_ID(+) = CLE_ML.ID
AND CPL_ML.DNZ_CHR_ID(+) = CLE_ML.DNZ_CHR_ID