VIEW: APPS.OKL_OR_ASSET_INFO_UV

Source

View Text - Preformatted

SELECT cleb_fin.id clev_fin_id, cleb_fin.dnz_chr_id, cleb_fin.exception_yn, clet_fin.name asset_number, clet_fin.item_description, kle_fin.residual_percentage, kle_fin.prescribed_asset_yn, kle_fin.residual_value, kle_fin.re_lease_yn, kle_fin.previous_contract, kle_fin.residual_grnty_amount, kle_fin.residual_code, kle_fin.rvi_premium, kle_fin.date_delivery_expected, kle_fin.date_funding_expected, kle_fin.expected_asset_cost, kle_fin.attribute_category, kle_fin.attribute1, kle_fin.attribute2, kle_fin.attribute3, kle_fin.attribute4, kle_fin.attribute5, kle_fin.attribute6, kle_fin.attribute7, kle_fin.attribute8, kle_fin.attribute9, kle_fin.attribute10, kle_fin.attribute11, kle_fin.attribute12, kle_fin.attribute13, kle_fin.attribute14, kle_fin.attribute15, TO_CHAR(NULL) clev_model_id, TO_CHAR(NULL) inventory_item_id, TO_CHAR(NULL) inventory_org_id, TO_CHAR(NULL) number_of_items, TO_CHAR(NULL) price_unit, TO_CHAR(NULL) inventory_item_name, TO_CHAR(NULL) clev_fa_id, TO_CHAR(NULL) model_number, TO_CHAR(NULL) year_built, TO_CHAR(NULL) fa_location_id, TO_CHAR(NULL) fa_location_name, TO_CHAR(NULL) manufacturer_name, TO_CHAR(NULL) asset_key_id, TO_CHAR(NULL) asset_key_name, TO_CHAR(NULL) clev_ib_id, TO_CHAR(NULL) party_site_use_id, TO_CHAR(NULL) party_site_name, TO_CHAR(NULL) asset_id FROM OKC_K_LINES_B CLEB_FIN,OKC_K_LINES_TL CLET_FIN,OKL_K_LINES KLE_FIN WHERE cleb_fin.id = clet_fin.id AND clet_fin.language = USERENV('LANG') AND kle_fin.id = cleb_fin.id

View Text - HTML Formatted

SELECT CLEB_FIN.ID CLEV_FIN_ID
, CLEB_FIN.DNZ_CHR_ID
, CLEB_FIN.EXCEPTION_YN
, CLET_FIN.NAME ASSET_NUMBER
, CLET_FIN.ITEM_DESCRIPTION
, KLE_FIN.RESIDUAL_PERCENTAGE
, KLE_FIN.PRESCRIBED_ASSET_YN
, KLE_FIN.RESIDUAL_VALUE
, KLE_FIN.RE_LEASE_YN
, KLE_FIN.PREVIOUS_CONTRACT
, KLE_FIN.RESIDUAL_GRNTY_AMOUNT
, KLE_FIN.RESIDUAL_CODE
, KLE_FIN.RVI_PREMIUM
, KLE_FIN.DATE_DELIVERY_EXPECTED
, KLE_FIN.DATE_FUNDING_EXPECTED
, KLE_FIN.EXPECTED_ASSET_COST
, KLE_FIN.ATTRIBUTE_CATEGORY
, KLE_FIN.ATTRIBUTE1
, KLE_FIN.ATTRIBUTE2
, KLE_FIN.ATTRIBUTE3
, KLE_FIN.ATTRIBUTE4
, KLE_FIN.ATTRIBUTE5
, KLE_FIN.ATTRIBUTE6
, KLE_FIN.ATTRIBUTE7
, KLE_FIN.ATTRIBUTE8
, KLE_FIN.ATTRIBUTE9
, KLE_FIN.ATTRIBUTE10
, KLE_FIN.ATTRIBUTE11
, KLE_FIN.ATTRIBUTE12
, KLE_FIN.ATTRIBUTE13
, KLE_FIN.ATTRIBUTE14
, KLE_FIN.ATTRIBUTE15
, TO_CHAR(NULL) CLEV_MODEL_ID
, TO_CHAR(NULL) INVENTORY_ITEM_ID
, TO_CHAR(NULL) INVENTORY_ORG_ID
, TO_CHAR(NULL) NUMBER_OF_ITEMS
, TO_CHAR(NULL) PRICE_UNIT
, TO_CHAR(NULL) INVENTORY_ITEM_NAME
, TO_CHAR(NULL) CLEV_FA_ID
, TO_CHAR(NULL) MODEL_NUMBER
, TO_CHAR(NULL) YEAR_BUILT
, TO_CHAR(NULL) FA_LOCATION_ID
, TO_CHAR(NULL) FA_LOCATION_NAME
, TO_CHAR(NULL) MANUFACTURER_NAME
, TO_CHAR(NULL) ASSET_KEY_ID
, TO_CHAR(NULL) ASSET_KEY_NAME
, TO_CHAR(NULL) CLEV_IB_ID
, TO_CHAR(NULL) PARTY_SITE_USE_ID
, TO_CHAR(NULL) PARTY_SITE_NAME
, TO_CHAR(NULL) ASSET_ID
FROM OKC_K_LINES_B CLEB_FIN
, OKC_K_LINES_TL CLET_FIN
, OKL_K_LINES KLE_FIN
WHERE CLEB_FIN.ID = CLET_FIN.ID
AND CLET_FIN.LANGUAGE = USERENV('LANG')
AND KLE_FIN.ID = CLEB_FIN.ID