View: OKL_SO_ITEMS_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	Used to populate the Inventory Items LOV for OKL Sales
Implementation/DBA Data:	APPS.OKL_SO_ITEMS_LOV_UV

View Text

SELECT B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.ORGANIZATION_ID INVENTORY_ORG_ID
, B.SEGMENT1 ITEM
, T.DESCRIPTION DESCRIPTION
FROM MTL_SYSTEM_ITEMS_B B
, MTL_SYSTEM_ITEMS_TL T
, FA_CATEGORY_BOOK_DEFAULTS FA
, OKL_SYSTEM_PARAMS OSP
WHERE B.ORGANIZATION_ID = OSP.ITEM_INV_ORG_ID
AND B.ENABLED_FLAG = 'Y'
AND B.ASSET_CATEGORY_ID = FA.CATEGORY_ID
AND FA.BOOK_TYPE_CODE = OSP.ASST_ADD_BOOK_TYPE_CODE
AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns