VIEW: APPS.MSC_EXCEPTION_LOOKUP_V

Source

View Text - Preformatted

SELECT flv.meaning EXCEPTION_TYPE, flv.lookup_code EXCEPTION_TYPE_ID, flv_group.meaning EXCEPTION_GROUP, flv_group.lookup_code EXCEPTION_GROUP_ID, -99 as COMPANY_ID, 'Y' as SECURITY_FLAG, -99 as USER_ID from fnd_lookup_values flv, fnd_lookup_values flv_group WHERE flv.lookup_type = 'MSC_X_EXCEPTION_TYPE' and flv.language = 'US' and flv_group.lookup_type = 'MSC_X_EXCEPTION_GROUP' and flv_group.language = 'US' and flv_group.lookup_code = decode(flv.lookup_code, 1, 1, 2, 1, 3, 1, 4, 1, 5, 2, 6, 2, 7, 2, 8, 2, 9, 2, 10,2, 11,2, 12,2, 13,3, 14,4, 15,4, 16,4, 17,4, 18,5, 19,5, 20,5, 21,5, 22,6, 23,6, 24,7, 25,7, 26,7, 27,7, 28,7, 29,7, 30,7, 31,7, 32,8, 33,9, 34,9, 35,9, 36,9, 37,9, 38,9, 39,9, 40,9, 41,9, 42,9, 43,9, 44,9, 45,9, 46,9) union all SELECT ude.name EXCEPTION_TYPE, to_char(ude.exception_id) EXCEPTION_TYPE_ID, flv_group.meaning EXCEPTION_GROUP, flv_group.lookup_code EXCEPTION_GROUP_ID, ude.company_id COMPANY_ID, ude.security_flag SECURITY_FLAG, ude.created_by USER_ID from msc_user_exceptions ude, fnd_lookup_values flv_group where flv_group.lookup_type = 'MSC_X_EXCEPTION_GROUP' and flv_group.language = 'US' and flv_group.lookup_code = -99

View Text - HTML Formatted

SELECT FLV.MEANING EXCEPTION_TYPE
, FLV.LOOKUP_CODE EXCEPTION_TYPE_ID
, FLV_GROUP.MEANING EXCEPTION_GROUP
, FLV_GROUP.LOOKUP_CODE EXCEPTION_GROUP_ID
, -99 AS COMPANY_ID
, 'Y' AS SECURITY_FLAG
, -99 AS USER_ID
FROM FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV_GROUP
WHERE FLV.LOOKUP_TYPE = 'MSC_X_EXCEPTION_TYPE'
AND FLV.LANGUAGE = 'US'
AND FLV_GROUP.LOOKUP_TYPE = 'MSC_X_EXCEPTION_GROUP'
AND FLV_GROUP.LANGUAGE = 'US'
AND FLV_GROUP.LOOKUP_CODE = DECODE(FLV.LOOKUP_CODE
, 1
, 1
, 2
, 1
, 3
, 1
, 4
, 1
, 5
, 2
, 6
, 2
, 7
, 2
, 8
, 2
, 9
, 2
, 10
, 2
, 11
, 2
, 12
, 2
, 13
, 3
, 14
, 4
, 15
, 4
, 16
, 4
, 17
, 4
, 18
, 5
, 19
, 5
, 20
, 5
, 21
, 5
, 22
, 6
, 23
, 6
, 24
, 7
, 25
, 7
, 26
, 7
, 27
, 7
, 28
, 7
, 29
, 7
, 30
, 7
, 31
, 7
, 32
, 8
, 33
, 9
, 34
, 9
, 35
, 9
, 36
, 9
, 37
, 9
, 38
, 9
, 39
, 9
, 40
, 9
, 41
, 9
, 42
, 9
, 43
, 9
, 44
, 9
, 45
, 9
, 46
, 9) UNION ALL SELECT UDE.NAME EXCEPTION_TYPE
, TO_CHAR(UDE.EXCEPTION_ID) EXCEPTION_TYPE_ID
, FLV_GROUP.MEANING EXCEPTION_GROUP
, FLV_GROUP.LOOKUP_CODE EXCEPTION_GROUP_ID
, UDE.COMPANY_ID COMPANY_ID
, UDE.SECURITY_FLAG SECURITY_FLAG
, UDE.CREATED_BY USER_ID
FROM MSC_USER_EXCEPTIONS UDE
, FND_LOOKUP_VALUES FLV_GROUP
WHERE FLV_GROUP.LOOKUP_TYPE = 'MSC_X_EXCEPTION_GROUP'
AND FLV_GROUP.LANGUAGE = 'US'
AND FLV_GROUP.LOOKUP_CODE = -99