VIEW: APPS.MSC_EXCEPTION_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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