View: OKL_AM_SALVAGE_VALUE_WD_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_SALVAGE_VALUE_WD_UV

View Text

SELECT CLE.ID KLE_ID
, TL.NAME NAME
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLE.STS_CODE LINE_STS_CODE
, CLE.CHR_ID CHR_ID
, CLE.START_DATE START_DATE
, CLE.END_DATE END_DATE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CLE.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CLE.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, FA.ASSET_ID ASSET_ID
, FA.CURRENT_UNITS QUANTITY
, FA.ASSET_NUMBER FIXED_ASSET_NUMBER
, FA.CORPORATE_BOOK CORPORATE_BOOK
, FABKC.BOOK_TYPE_NAME CORPORATE_BOOK_NAME
, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FA.ORIGINAL_COST ORIGINAL_COST
, FA.COST COST
, FA.ADJUSTED_COST ADJUSTED_COST
, FA.CURRENT_UNITS CURRENT_UNITS
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FA.NEW_USED NEW_USED
, FA.IN_SERVICE_DATE IN_SERVICE_DATE
, FA.SALVAGE_VALUE SALVAGE_VALUE
, FA.DEPRECIATION_CATEGORY CATEGORY_ID
, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION
, FA.DEPRN_START_DATE DEPRN_START_DATE
, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, KHR.ID KHR_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.STS_CODE CONTRACT_STS_CODE
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
, KHR.AUTHORING_ORG_ID ORG_ID
FROM OKX_ASSETS_V FA
, OKC_K_LINES_B CLE
, OKC_K_LINES_B ASSET_CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
, FA_CATEGORIES_VL FACAT
, FA_BOOK_CONTROLS FABKC
, OKL_K_HEADERS_FULL_V KHR
, OKL_PRODUCTS_V PDT
WHERE CLE.ID = ASSET_CLE.CLE_ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = ASSET_CLE.LSE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND CIM.CLE_ID = ASSET_CLE.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND FA.ID1 = CIM.OBJECT1_ID1
AND FA.ID2 = CIM.OBJECT1_ID2
AND FA.CORPORATE_BOOK = FABKC.BOOK_TYPE_CODE (+)
AND FA.DEPRECIATION_CATEGORY = FACAT.CATEGORY_ID (+)
AND CLE.CHR_ID = KHR.ID
AND KHR.PDT_ID = PDT.ID (+)
AND FA.SALVAGE_VALUE > 0

Columns