View: OKL_LA_ADD_ITEMS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for asset add-ons page
Implementation/DBA Data:	APPS.OKL_LA_ADD_ITEMS_UV

View Text

SELECT CLE.ID ID
, CLE.CLE_ID PARENT_LINE_ID
, TO_CHAR(CLE.PRICE_UNIT) UNIT_COST
, CIM.OBJECT1_ID1 ID1
, CIM.OBJECT1_ID2 ID2
, CIM.JTOT_OBJECT1_CODE OBJECT_CODE
, CIM.NUMBER_OF_ITEMS QUANTITY
, MTLT.DESCRIPTION NAME
, MTLB.DESCRIPTION DESCRIPTION
FROM OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_ITEMS CIM
, OKC_LINE_STYLES_B LSE
, MTL_SYSTEM_ITEMS_B MTLB
, MTL_SYSTEM_ITEMS_TL MTLT
WHERE CLE.ID = KLE.ID
AND CLE.ID = CIM.CLE_ID
AND CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'ADD_ITEM'
AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.OBJECT1_ID1 = MTLB.INVENTORY_ITEM_ID
AND CIM.OBJECT1_ID2 = TO_CHAR(MTLB.ORGANIZATION_ID)
AND CIM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND MTLB.INVENTORY_ITEM_ID = MTLT.INVENTORY_ITEM_ID
AND MTLB.ORGANIZATION_ID = MTLT.ORGANIZATION_ID
AND MTLT.LANGUAGE = USERENV('LANG')

Columns