Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_OR_ASSET_INFO_UV |
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