View: MSC_EXCEPTION_LOOKUP_V

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

View Text

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

Columns