SELECT MIE.COMPANY_ID , FLV.MEANING EXCEPTION_TYPE , FLV.LOOKUP_CODE EXCEPTION_TYPE_ID , FLV_GROUP.MEANING EXCEPTION_GROUP , SUM(MIE.EXCEPTION_COUNT) FROM MSC_ITEM_EXCEPTIONS MIE , FND_LOOKUP_VALUES FLV , FND_LOOKUP_VALUES FLV_GROUP WHERE NVL(VERSION , -1) = 0 AND MIE.EXCEPTION_GROUP IS NOT NULL AND MIE.EXCEPTION_TYPE = FLV.LOOKUP_CODE AND FLV.LOOKUP_TYPE = 'MSC_X_EXCEPTION_TYPE' AND FLV.LANGUAGE = 'US' AND MIE.VERSION = 0 AND MIE.EXCEPTION_GROUP = FLV_GROUP.LOOKUP_CODE AND FLV_GROUP.LOOKUP_TYPE = 'MSC_X_EXCEPTION_GROUP' AND FLV_GROUP.LANGUAGE = 'US' GROUP BY MIE.COMPANY_ID , FLV.MEANING , FLV.LOOKUP_CODE , FLV_GROUP.MEANING HAVING SUM(MIE.EXCEPTION_COUNT) > 0 UNION ALL SELECT MIE.COMPANY_ID , UDE.NAME EXCEPTION_TYPE , TO_CHAR(UDE.EXCEPTION_ID) EXCEPTION_TYPE_ID , FLV_GROUP.MEANING EXCEPTION_GROUP , SUM(MIE.EXCEPTION_COUNT) FROM MSC_ITEM_EXCEPTIONS MIE , MSC_USER_EXCEPTIONS UDE , FND_LOOKUP_VALUES FLV_GROUP WHERE MIE.EXCEPTION_GROUP IS NOT NULL AND MIE.EXCEPTION_GROUP = -99 AND MIE.EXCEPTION_TYPE = UDE.EXCEPTION_ID AND MIE.EXCEPTION_GROUP = FLV_GROUP.LOOKUP_CODE AND FLV_GROUP.LOOKUP_TYPE = 'MSC_X_EXCEPTION_GROUP' AND FLV_GROUP.LANGUAGE = 'US' GROUP BY MIE.COMPANY_ID , UDE.NAME , UDE.EXCEPTION_ID , FLV_GROUP.MEANING HAVING SUM(MIE.EXCEPTION_COUNT) > 0