View: OKL_NEW_ASSETS_UV

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

View Text

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

Columns