[Home] [Help]
VIEW: APPS.POR_SUBINVENTORY_LOV_V
Source
View Text - Preformatted
SELECT msci.secondary_inventory_name, msci.description, msci.organization_id FROM mtl_secondary_inventories msci WHERE sysdate < nvl(msci.disable_date, sysdate + 1)
View Text - HTML Formatted
SELECT MSCI.SECONDARY_INVENTORY_NAME
, MSCI.DESCRIPTION
, MSCI.ORGANIZATION_ID
FROM MTL_SECONDARY_INVENTORIES MSCI
WHERE SYSDATE < NVL(MSCI.DISABLE_DATE
, SYSDATE + 1)