View: OKL_CS_LINE_VERSION_UV

Product:	OKL - Lease and Finance Management
Description:	List of Line Versions
Implementation/DBA Data:	APPS.OKL_CS_LINE_VERSION_UV

View Text

SELECT DISTINCT HDR.ID
, HDR.CONTRACT_NUMBER
, TOP_LINE.NAME ASSET_NUMBER
, TOP_LINE.ID PARENT_LINE_ID
, TOP_LINE.ITEM_DESCRIPTION DESCRIPTION
, CIM.NUMBER_OF_ITEMS CURRENT_UNITS
, TOP_LINE.STS_CODE LINE_STATUS
, STS.MEANING ASSET_STATUS
, TOP_LINE.MAJOR_VERSION MAJOR_VERSION
, NVL(KLE.RESIDUAL_VALUE
, 0)
, NVL(KLE.RESIDUAL_PERCENTAGE
, 0)
, NVL(KLE.RESIDUAL_GRNTY_AMOUNT
, 0)
, NVL(KLE.OEC
, 0)
, NVL(KLE.CAPITAL_AMOUNT
, 0)
, HDR.CURRENCY_CODE
FROM OKC_K_LINES_HV TOP_LINE
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_HV MODEL_CLE
, OKC_LINE_STYLES_B MODEL_LSE
, OKC_K_ITEMS_H CIM
, OKL_K_LINES_H KLE
, OKC_K_HEADERS_B HDR
, OKC_STATUSES_V STS
WHERE TOP_LINE.DNZ_CHR_ID= HDR.ID
AND LSE.ID = TOP_LINE.LSE_ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND MODEL_CLE.CLE_ID = TOP_LINE.ID
AND MODEL_LSE.ID = MODEL_CLE.LSE_ID
AND MODEL_LSE.LTY_CODE = 'ITEM'
AND CIM.CLE_ID = MODEL_CLE.ID
AND KLE.ID = TOP_LINE.ID
AND KLE.MAJOR_VERSION = TOP_LINE.MAJOR_VERSION
AND MODEL_CLE.MAJOR_VERSION = TOP_LINE.MAJOR_VERSION
AND CIM.MAJOR_VERSION = TOP_LINE.MAJOR_VERSION
AND TOP_LINE.STS_CODE = STS.CODE UNION SELECT DISTINCT HDR.ID CONTRACT_ID
, HDR.CONTRACT_NUMBER
, TXLA.ASSET_NUMBER
, TXLA.KLE_ID PARENT_LINE_ID
, TOP_LINE_TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, TXLA.CURRENT_UNITS
, CLE.STS_CODE LINE_STATUS
, STS.MEANING ASSET_STATUS
, KLE.MAJOR_VERSION MAJOR_VERSION
, NVL(KLE.RESIDUAL_VALUE
, 0)
, NVL(KLE.RESIDUAL_PERCENTAGE
, 0)
, NVL(KLE.RESIDUAL_GRNTY_AMOUNT
, 0)
, NVL(KLE.OEC
, 0)
, NVL(KLE.CAPITAL_AMOUNT
, 0)
, HDR.CURRENCY_CODE
FROM OKC_K_HEADERS_BH HDR
, OKL_TXL_ASSETS_B TXLA
, OKC_K_LINES_BH CLE
, OKC_K_LINES_TLH TL
, OKC_K_LINES_TLH TOP_LINE_TL
, OKL_K_LINES TOP_LINE
, OKC_LINE_STYLES_B LS
, OKL_K_HEADERS KHR
, OKL_K_LINES_H TOP_KLE
, OKL_K_LINES_H KLE
, OKC_STATUSES_V STS
WHERE CLE.DNZ_CHR_ID = HDR.ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE(+) = USERENV('LANG')
AND LS.ID = CLE.LSE_ID
AND TOP_LINE_TL.ID = TOP_LINE.ID
AND TOP_LINE_TL.LANGUAGE(+) = USERENV('LANG')
AND TOP_LINE.ID = CLE.CLE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND TXLA.KLE_ID = CLE.ID
AND TXLA.TAL_TYPE= 'CFA'
AND NOT EXISTS ( SELECT '1'
FROM OKC_K_ITEMS FA_CIM
WHERE FA_CIM.CLE_ID = CLE.ID
AND FA_CIM.OBJECT1_ID1 IS NOT NULL)
AND KHR.ID = CLE.ID
AND TOP_KLE.ID = CLE.CLE_ID
AND KLE.ID = TOP_LINE.ID
AND LS.LTY_CODE ='FIXED_ASSET'
AND KHR.DEAL_TYPE = 'LOAN'
AND CLE.STS_CODE = STS.CODE ORDER BY MAJOR_VERSION
, ASSET_NUMBER

Columns