View: OKL_LA_ITEM_DTLS_UV

Product:	OKL - Lease and Finance Management
Description:	Item Details
Implementation/DBA Data:	APPS.OKL_LA_ITEM_DTLS_UV

View Text

SELECT CLE.ID ID
, CLE.CLE_ID PARENT_LINE_ID
, TO_CHAR(CLE.PRICE_UNIT) UNIT_COST
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, 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
, KLE.MANUFACTURER_NAME MANUFACTURER_NAME
, KLE.MODEL_NUMBER MODEL_NUMBER
, KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, TO_CHAR(NULL) VENDOR_NAME
, CPL.OBJECT1_ID1 VENDOR_ID
, CPL.ID CPL_ID
, CTLE.COMMENTS COMMENTS
FROM OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL CTLE
, OKC_K_ITEMS CIM
, OKC_LINE_STYLES_B LSE
, MTL_SYSTEM_ITEMS_B MTLB
, MTL_SYSTEM_ITEMS_TL MTLT
, OKC_K_PARTY_ROLES_B CPL
WHERE CLE.ID = KLE.ID
AND CLE.ID = CTLE.ID
AND CTLE.LANGUAGE = USERENV('LANG')
AND KLE.ID = CTLE.ID
AND CLE.DNZ_CHR_ID = CPL.DNZ_CHR_ID(+)
AND CPL.CLE_ID(+) = CLE.ID
AND CPL.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL.CHR_ID IS NULL
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