View: MSC_NET_EXC_TYPE_V

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

View Text

SELECT MED.QUERY_ID
, SUM(DECODE(MED.FROM_PLAN
, 1
, 1
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, 1
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 1
, 1
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 2
, 1
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 0
, 1
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, DECODE(MED.STATUS
, 0
, 1
, 0)
, 0))
, MED.EXCEPTION_TYPE
, MFG.MEANING
, MED.EXCEPTION_GROUP
, DECODE(MED.EXCEPTION_TYPE
, 21
, 'MSC_EXCP_HORPAGE'
, 22
, 'MSC_EXCP_HORPAGE'
, 36
, 'MSC_EXCP_HORPAGE'
, 38
, 'MSC_EXCP_HORPAGE'
, 39
, 'MSC_EXCP_HORPAGE'
, 50
, 'MSC_EXCP_HORPAGE'
, 51
, 'MSC_EXCP_HORPAGE'
, 29
, 'MSC_EXCP_HORPAGE'
, 30
, 'MSC_EXCP_HORPAGE'
, 45
, 'MSC_EXCP_HORPAGE'
, 46
, 'MSC_EXCP_HORPAGE'
, 40
, 'MSC_EXCP_HORPAGE'
, 28
, 'MSC_EXCP_HORPAGE'
, 37
, 'MSC_EXCP_HORPAGE'
, 2
, 'MSC_EXCP_HORPAGE'
, 3
, 'MSC_EXCP_HORPAGE'
, 17
, 'MSC_EXCP_HORPAGE'
, 18
, 'MSC_EXCP_HORPAGE'
, 19
, 'MSC_EXCP_HORPAGE'
, 20
, 'MSC_EXCP_HORPAGE'
, 'MSC_EXCPGRP_DETAILPAGE')
, DECODE(MED.EXCEPTION_GROUP
, 2
, 'MSCCHNGEXCPNOURL'
, 3
, 'MSCCHNGEXCPNOURL'
, 6
, 'MSCCHNGEXCPNOURL'
, 'MSCCHNGEXCPNOURL')
, DECODE(MED.EXCEPTION_TYPE
, 13
, 'MSCEXCPTYPEURL'
, 14
, 'MSCEXCPTYPEURL'
, 15
, 'MSCEXCPTYPEURL'
, 16
, 'MSCEXCPTYPEURL'
, 24
, 'MSCEXCPTYPEURL'
, 25
, 'MSCEXCPTYPEURL'
, 26
, 'MSCEXCPTYPEURL'
, 27
, 'MSCEXCPTYPEURL'
, 21
, 'MSCEXCPTYPEURL'
, 22
, 'MSCEXCPTYPEURL'
, 36
, 'MSCEXCPTYPEURL'
, 38
, 'MSCEXCPTYPEURL'
, 39
, 'MSCEXCPTYPEURL'
, 50
, 'MSCEXCPTYPEURL'
, 51
, 'MSCEXCPTYPEURL'
, 29
, 'MSCEXCPTYPEURL'
, 30
, 'MSCEXCPTYPEURL'
, 45
, 'MSCEXCPTYPEURL'
, 46
, 'MSCEXCPTYPEURL'
, 40
, 'MSCEXCPTYPEURL'
, 28
, 'MSCEXCPTYPEURL'
, 37
, 'MSCEXCPTYPEURL'
, 2
, 'MSCEXCPTYPEURL'
, 3
, 'MSCEXCPTYPEURL'
, 17
, 'MSCEXCPTYPEURL'
, 18
, 'MSCEXCPTYPEURL'
, 20
, 'MSCEXCPTYPEURL'
, 6
, 'MSCEXCPTYPEURL'
, 7
, 'MSCEXCPTYPEURL'
, 9
, 'MSCEXCPTYPEURL'
, 10
, 'MSCEXCPTYPEURL'
, 'MSCEXCPTYPENOURL')
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_NEC_EXC_DTL_TEMP MED
, MFG_LOOKUPS MFG
WHERE MFG.LOOKUP_TYPE='MRP_EXCEPTION_CODE_TYPE'
AND MFG.LOOKUP_CODE=MED.EXCEPTION_TYPE
AND MED.STATUS IS NOT NULL GROUP BY MED.QUERY_ID
, MED.EXCEPTION_GROUP
, MED.EXCEPTION_TYPE
, MFG.MEANING
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN

Columns