View: MSC_EXCEPTION_SUMMARY_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_EXCEPTION_SUMMARY_V

View Text

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

Columns