View: OKL_K_LINES_ITEMS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for linked asset lines - used in service and fee line pages.
Implementation/DBA Data:	APPS.OKL_K_LINES_ITEMS_UV

View Text

SELECT CLE.ID LINE_ID
, CLE.CLE_ID LINE_CLE_ID
, CLE.STS_CODE LINE_STS_CODE
, CLE.CURRENCY_CODE LINE_CURRENCY_CODE
, CLE.LINE_NUMBER LINE_LINE_NUMBER
, CLE.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE
, CLE.LSE_ID LINE_LSE_ID
, CLE.START_DATE LINE_START_DATE
, CLE.END_DATE LINE_END_DATE
, CLE.PRICE_NEGOTIATED LINE_PRICE_NEGOTIATED
, CLE.DNZ_CHR_ID LINE_DNZ_CHR_ID
, CLE.CHR_ID LINE_CHR_ID
, KLE.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT
, ITEM.ID ITEM_ID
, ITEM.CLE_ID ITEM_CLE_ID
, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1
, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2
, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE
, ' ' ITEM_NAME
, ITEM.CHR_ID ITEM_CHR_ID
, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID
, ITEM.UOM_CODE ITEM_UOM_CODE
, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN
, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS
, LSE.LTY_CODE LS_LTY_CODE
, LSE.ID LS_ID
FROM OKC_K_LINES_B CLE
, OKC_LINE_STYLES_B LSE
, OKC_K_ITEMS ITEM
, OKL_K_LINES KLE
WHERE LSE.ID = CLE.LSE_ID
AND KLE.ID = CLE.ID
AND ITEM.CLE_ID = CLE.ID
AND ITEM.DNZ_CHR_ID = CLE.DNZ_CHR_ID

Columns