VIEW: APPS.MST_REL_EXCP_V

Source

View Text - Preformatted

SELECT distinct med.plan_id , med.trip_id1 , med.exception_detail_id , substr(MST_WB_UTIL.GET_TRIP_TOKENIZED_EXCEPTION(med.plan_id, med.exception_detail_id, med.trip_id1, 1), 1, 200) , 1 from mst_exception_details med union all select distinct med.plan_id , med.trip_id1 , med.exception_detail_id , substr(MST_WB_UTIL.GET_TRIP_TOKENIZED_EXCEPTION(med.plan_id, med.exception_detail_id, med.trip_id1, 2), 1, 200) , 2 from mst_exception_details med where med.exception_type in (206) order by 1, 2, 3, 5

View Text - HTML Formatted

SELECT DISTINCT MED.PLAN_ID
, MED.TRIP_ID1
, MED.EXCEPTION_DETAIL_ID
, SUBSTR(MST_WB_UTIL.GET_TRIP_TOKENIZED_EXCEPTION(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID
, MED.TRIP_ID1
, 1)
, 1
, 200)
, 1
FROM MST_EXCEPTION_DETAILS MED UNION ALL SELECT DISTINCT MED.PLAN_ID
, MED.TRIP_ID1
, MED.EXCEPTION_DETAIL_ID
, SUBSTR(MST_WB_UTIL.GET_TRIP_TOKENIZED_EXCEPTION(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID
, MED.TRIP_ID1
, 2)
, 1
, 200)
, 2
FROM MST_EXCEPTION_DETAILS MED
WHERE MED.EXCEPTION_TYPE IN (206) ORDER BY 1
, 2
, 3
, 5