View: OKL_OLD_ASSETS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for asset summary page
Implementation/DBA Data:	APPS.OKL_OLD_ASSETS_UV

View Text

SELECT CLT_FIN.NAME ASSET_NUMBER
, KLE_FA.YEAR_BUILT YEAR_MANUFACTURED
, FA.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 PO_VENDORS PV
, OKC_K_PARTY_ROLES_B CPL_ML
, OKC_K_ITEMS CIM_ML
, OKC_LINE_STYLES_B LSE_ML
, OKC_K_LINES_B CLE_ML
, FA_BOOK_CONTROLS FBC
, FA_BOOKS FB
, FA_ADDITIONS_B FA
, OKC_LINE_STYLES_B LSE_FA
, OKC_K_ITEMS CIM_FA
, OKL_K_LINES KLE_FA
, OKC_K_LINES_B CLE_FA
, OKC_LINE_STYLES_B LSE_FIN
, OKL_K_LINES KLE_FIN
, OKC_K_LINES_TL CLT_FIN
, OKC_K_LINES_B CLE_FIN
, OKC_STATUSES_V STS
WHERE CLT_FIN.ID = CLE_FIN.ID
AND CLT_FIN.LANGUAGE = USERENV('LANG')
AND CIM_FA.OBJECT1_ID1 = FA.ASSET_ID
AND CIM_FA.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIM_FA.CLE_ID = CLE_FA.ID
AND CIM_FA.DNZ_CHR_ID = CLE_FA.DNZ_CHR_ID
AND CLE_FA.LSE_ID = LSE_FA.ID
AND LSE_FA.LTY_CODE = 'FIXED_ASSET'
AND CLE_FA.CLE_ID = CLE_FIN.ID
AND CLE_FA.ID = KLE_FA.ID
AND CLE_FA.DNZ_CHR_ID = CLE_FIN.DNZ_CHR_ID
AND CLE_FIN.LSE_ID = LSE_FIN.ID
AND LSE_FIN.LTY_CODE = 'FREE_FORM1'
AND KLE_FIN.ID = CLE_FIN.ID
AND FA.ASSET_ID = FB.ASSET_ID
AND FB.BOOK_TYPE_CODE = FBC.BOOK_TYPE_CODE
AND FBC.BOOK_CLASS = 'CORPORATE'
AND NVL(FBC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND FB.TRANSACTION_HEADER_ID_OUT IS NULL
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 CIM_ML.CLE_ID = CLE_ML.ID
AND CIM_ML.DNZ_CHR_ID = CIM_ML.DNZ_CHR_ID
AND CPL_ML.CLE_ID(+) = CLE_ML.ID
AND CPL_ML.DNZ_CHR_ID(+) = CLE_ML.DNZ_CHR_ID
AND CPL_ML.CHR_ID IS NULL
AND CPL_ML.OBJECT1_ID1 = PV.VENDOR_ID(+)
AND CPL_ML.OBJECT1_ID2(+) = '#'
AND CPL_ML.JTOT_OBJECT1_CODE(+) = 'OKX_VENDOR'
AND CPL_ML.RLE_CODE(+) = 'OKL_VENDOR'
AND CLE_FA.STS_CODE = STS.CODE

Columns