View: OKL_AM_SUBINVENTORY_UV

Product:	OKL - Lease and Finance Management
Description:	This view is used by remarketing setup screen to display item subinventories.
Implementation/DBA Data:	APPS.OKL_AM_SUBINVENTORY_UV

View Text

SELECT DISTINCT SECONDARY_INVENTORY_NAME
, DESCRIPTION
FROM MTL_SECONDARY_INVENTORIES
WHERE NVL(DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND LOCATOR_TYPE=1
AND ASSET_INVENTORY = 1
AND RESERVABLE_TYPE=1

Columns