View: POR_SUBINVENTORY_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Subinventories
Implementation/DBA Data:	APPS.POR_SUBINVENTORY_LOV_V

View Text

SELECT MSCI.SECONDARY_INVENTORY_NAME
, MSCI.DESCRIPTION
, MSCI.ORGANIZATION_ID
FROM MTL_SECONDARY_INVENTORIES MSCI
WHERE SYSDATE < NVL(MSCI.DISABLE_DATE
, SYSDATE + 1)

Columns