Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_NET_EXC_GROUP_V |
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_GROUP
, GROUP_MFG.MEANING
, DECODE(MED.EXCEPTION_GROUP
, 2
, 'MSCCHNGEXCPNOURL'
, 3
, 'MSCCHNGEXCPNOURL'
, 6
, 'MSCCHNGEXCPNOURL'
, 'MSCCHNGEXCPNOURL')
, 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 GROUP_MFG
WHERE GROUP_MFG.LOOKUP_TYPE='MSC_EXCEPTION_GROUP'
AND GROUP_MFG.LOOKUP_CODE=MED.EXCEPTION_GROUP
AND MED.STATUS IS NOT NULL GROUP BY MED.QUERY_ID
, MED.EXCEPTION_GROUP
, GROUP_MFG.MEANING
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN