View: MSC_ACTION_SUMMARY_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view show the exception group counts in the tree
Implementation/DBA Data:	APPS.MSC_ACTION_SUMMARY_V

View Text

SELECT MFQ.LAST_UPDATE_DATE
, MFQ.LAST_UPDATED_BY
, MFQ.CREATION_DATE
, MFQ.CREATED_BY
, MFQ.NUMBER2
, DECODE(MFQ.NUMBER16
, NULL
, MFQ.NUMBER2
, MFQ.NUMBER16)
, NULL
, DECODE(MFQ.NUMBER16
, NULL
, 1
, 2)
, MP.COMPILE_DESIGNATOR
, MFQ.NUMBER14
, MFQ.NUMBER4
, MFQ.NUMBER15
, MFQ.NUMBER6
, MFQ.NUMBER7
, NVL(TO_CHAR(NUMBER1)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_VERSION'
, 1))
, MFQ.NUMBER5
, MFQ.NUMBER3
, MFQ.CHAR2
, MFQ.CHAR2
, MFQ.NUMBER8
, MFQ.CHAR14
, MFQ.CHAR4
, MFQ.CHAR4
, MFQ.QUERY_ID
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MFQ.NUMBER2)
, NVL(MFQ.CHAR5
, MSC_GET_NAME.ITEM_NAME(MFQ.NUMBER3
, NULL
, NULL
, NULL))
, MFQ.NUMBER11
, MSC_GET_NAME.ITEM_NAME(MFQ.NUMBER11
, NULL
, NULL
, NULL)
, NVL(MFQ.CHAR6
, MSC_GET_NAME.ORG_CODE(MFQ.NUMBER4
, MFQ.NUMBER15))
, MSC_GET_NAME.PROJECT(MFQ.NUMBER6
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15)
, MSC_GET_NAME.TASK(MFQ.NUMBER7
, MFQ.NUMBER6
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15)
, MFQ.CHAR9
, MFQ.CHAR9
, MFQ.CHAR3
, MFQ.CHAR8
, MFQ.NUMBER9
, MFQ.NUMBER10
, NVL(MFQ.CHAR7
, MSC_GET_NAME.DEPARTMENT_CODE(2
, MFQ.NUMBER9
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15))
, NVL(MFQ.CHAR10
, MSC_GET_NAME.RESOURCE_CODE(MFQ.NUMBER10
, MFQ.NUMBER9
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15))
, MFQ.CHAR11
, MFQ.NUMBER12
, MSC_GET_NAME.SUPPLIER(MFQ.NUMBER12)
, MFQ.LAST_UPDATE_LOGIN
, 1
, MFQ.ROWID
, DECODE(NVL(NUMBER16
, NUMBER2)
, 5
, 1
, 6
, 2
, 7
, 3
, 3
, 4
, 4
, 5
, 2
, 6
, 8
, 7
, 1
, 8
, 11
, 9
, 10
, 10
, NULL)
, DECODE(NUMBER16
, NULL
, -1
, DECODE(NUMBER2
, 41
, 1
, 35
, 2
, 42
, 3
, 23
, 4
, 15
, 5
, 16
, 6
, 13
, 7
, 14
, 8
, 24
, 9
, 26
, 10
, 25
, 11
, 27
, 12
, 37
, 1
, 36
, 2
, 21
, 3
, 28
, 4
, 22
, 5
, 40
, 1
, 38
, 2
, 39
, 3
, 2
, 1
, 20
, 2
, 3
, 3
, 10
, 1
, 7
, 2
, 8
, 3
, 6
, 4
, 9
, 5
, 31
, 1
, 32
, 2
, 33
, 3
, 34
, 4
, 43
, 5
, 44
, 6
, 17
, 1
, 19
, 2
, 18
, 3
, 1
, 1
, 11
, 2
, 12
, 3
, 4
, 4
, 5
, 5
, 102
, 1
, 103
, 2
, 101
, 3
, 104
, 4
, NULL))
, MFQ.NUMBER13
FROM MSC_FORM_QUERY MFQ
, MSC_PLANS MP
WHERE MP.PLAN_ID = MFQ.NUMBER14

Columns