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
View Text - HTML Formatted
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