ECC Inventory Management, Inventory Space Utilization

select
x.*
from
(
SELECT * FROM (SELECT
                                                       SLOT.ECC_SPEC_ID,
                                                       SLOT.SKU_ITEM_COMBINATION,
                                                       SLOT.ORGANIZATION_CODE,
                                                       SLOT.ORGANIZATION_ID,
                                                       SLOT.COMPILE_NAME,
                                                       SLOT.INVENTORY_ITEM_ID,
                                                       SLOT.ITEM_NAME,
                                                       SLOT.ITEM_DESCRIPTION,
                                                       SLOT.SUBINVENTORY_CODE,
                                                       SLOT.LOCATOR_CODE,
                                                       SLOT.ITEM_CLASS,
                                                       SLOT.CLASS_SEQ_NUMBER,
                                                       SLOT.ITEM_SEQ_NUMBER,
                                                       SLOT.ITEM_VELOCITY,
                                                       SLOT.COMPILE_VALUE,
                                                       SLOT.TOTAL_VELOCITY,
                                                       SLOT.CLASS_CUMULATIVE_QTY,
                                                       SLOT.LOCATION_AVAILABLE_UNITS,
                                                       SLOT.LOCATION_MAXIMUM_UNITS,
                                                       SLOT.LOCATOR_CLASS,
                                                       SLOT.AVAILABLE_CAPACITY,
                                                       SLOT.RESLOT,
                                                       INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.RESLOT,SLOT.LANGUAGE ) RESLOT_DESC,
                                                       SLOT.ONHAND_QTY,
                                                       SLOT.ONHAND_QTY_PRIMARY,
                                                       SLOT.PRODUCT_CATEGORY,
                                                       SLOT.ZONE_NAME,
                                                       SLOT.EMPTY_FLAG,
                                                       INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.EMPTY_FLAG,SLOT.LANGUAGE ) EMPTY_FLAG_DESC,
                                                       SLOT.LAST_UPDATE_DATE,
                                                       SLOT.LANGUAGE,
                                                       SLOT.LPN_NUMBER,
                                                       SLOT.COST_GROUP,
                                                       SLOT.OLDEST_RECEIPT_DATE,
                                                       SLOT.LOT_NUMBER,
                                                       SLOT.REVISION,
                                                       SLOT.LOCATOR_ID,
                                                       SLOT.ONHAND_STATUS,
                                                       SLOT.SUBINVENTORY_STATUS,
                                                       SLOT.LOCATOR_STATUS,
                                                       SLOT.LOT_STATUS,
                                                       SLOT.EXPIRATION_DATE,
                                                       SLOT.LOC_ROWID,
                                                       SLOT.LOT_ROWID, DECODE (SLOT.INVENTORY_ITEM_ID, NULL ,'N','Y' ) RELEASE_LEVEL ,mln_dfv.* FROM INV_ECC_SLOTTING_V slot ,(select "ROW_ID" "'INV_MLN_ROW_ID'","CONTEXT_VALUE" "'INV_MLN_CONTEXT_VALUE'","SOURCE" "'INV_MLN_SOURCE'","PACKAGING" "'INV_MLN_PACKAGING'","SHIPPING_MODE" "'INV_MLN_SHIPPING_MODE'","CONCATENATED_SEGMENTS" "'INV_MLN_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT_VALUE",ATTRIBUTE1 "SOURCE",(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE11,NULL)) "PACKAGING",(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE12,NULL)) "SHIPPING_MODE",ATTRIBUTE1||'.'||(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE_CATEGORY||'.'||ATTRIBUTE11||'.'||ATTRIBUTE12,NULL)) "CONCATENATED_SEGMENTS" from MTL_LOT_NUMBERS )) mln_dfv WHERE LANGUAGE IN ( 'US') and lot_rowid =mln_dfv."'INV_MLN_ROW_ID'"(+) )PIVOT (MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION for LANGUAGE in ( 'US' "US")) 
) x
where
2=2