View: MSC_NET_VERTICAL_GRAPH_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_NET_VERTICAL_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.ORGANIZATION_CODE|| '/' ||MEDA.CHAR1 || '/' || MEDA.CHAR6
, ABS(NVL(MEDA.NUMBER4
, 0))
, 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
WHERE 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