View: MSC_NET_HZ_GRAPH_V

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

View Text

SELECT MED.QUERY_ID
, MED.EXCEPTION_DETAIL_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_GROUP
, MED.FROM_PLAN
, MED.PLAN_ID
, MED.STATUS
, MEDA.CHAR1 || DECODE (MED.EXCEPTION_TYPE
, 21
, '/' ||MEDA.CHAR2
, 22
, '/' || MEDA.CHAR2
, 23
, '/' || MEDA.CHAR2
, 28
, '/' ||MEDA.CHAR8
, 35
, '/' || MEDA.CHAR2
, 36
, '/' || MEDA.CHAR2
, 41
, '/' ||MEDA.CHAR8
, 42
, '/' || MEDA.CHAR8
, 37
, '/' || MEDA.CHAR8
, 17
, '/' ||MEDA.CHAR10|| '/' || MEDA.CHAR11
, 18
, '/' ||MEDA.CHAR10|| '/' || MEDA.CHAR11
, NULL) ||DECODE(MED.FROM_PLAN
, 1
, ' IN A'
, ' IN B')
, MEDA.DATE1
, MEDA.DATE2
, DECODE(MED.EXCEPTION_TYPE
, 2
, NVL(ABS(MEDA.QUANTITY)
, 0)
, 3
, NVL(ABS(MEDA.QUANTITY)
, 0)
, 17
, NVL(ABS(MEDA.QUANTITY)
, 0)
, 18
, NVL(ABS(MEDA.QUANTITY)
, 0)
, 20
, NVL(ABS(MEDA.QUANTITY)
, 0)
, NVL(MEDA.LOAD_RATIO
, 0))
, MP.PLAN_START_DATE
, NVL(MEDA.DATE1
, MP.PLAN_START_DATE)-MP.PLAN_START_DATE
, NVL(NVL(MEDA.DATE2
, MEDA.DATE1+1)
, MP.PLAN_START_DATE+1) -NVL(MEDA.DATE1
, MP.PLAN_START_DATE)
, 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
, MSC_EXC_DETAILS_ALL MEDA
, MSC_PLANS MP
WHERE MEDA.PLAN_ID = MP.PLAN_ID
AND MED.STATUS IS NOT NULL
AND MEDA.PLAN_ID = MED.PLAN_ID
AND MEDA.EXCEPTION_DETAIL_ID = MED.EXCEPTION_DETAIL_ID ORDER BY MED.EXCEPTION_TYPE
, MED.MATCH_ID
, MED.FROM_PLAN

Columns