VIEW: APPS.MST_ACT_ANALYZE_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT mir.plan_id, mor.in_request_id, mor.out_request_id, mord.out_request_detail_id, mord.exception_type, substr(MST_WB_UTIL.GET_ACT_TOKENIZED_EXCEPTION(mir.plan_id, mord.out_request_detail_id, mord.exception_type, 1), 1, 200), 1 from mst_in_requests mir, mst_out_requests mor, mst_out_request_details mord where mor.out_request_id = mord.out_request_id and mor.in_request_id = mir.in_request_id and mord.exception_type is not null union all select mir.plan_id, mor.in_request_id, mor.out_request_id, mord.out_request_detail_id, mord.exception_type, substr(MST_WB_UTIL.GET_ACT_TOKENIZED_EXCEPTION(mir.plan_id, mord.out_request_detail_id, mord.exception_type, 2), 1, 200), 2 from mst_in_requests mir, mst_out_requests mor, mst_out_request_details mord where mor.out_request_id = mord.out_request_id and mor.in_request_id = mir.in_request_id and mord.exception_type is not null and mord.exception_type in (206) order by 3, 4, 5, 7

View Text - HTML Formatted

SELECT MIR.PLAN_ID
, MOR.IN_REQUEST_ID
, MOR.OUT_REQUEST_ID
, MORD.OUT_REQUEST_DETAIL_ID
, MORD.EXCEPTION_TYPE
, SUBSTR(MST_WB_UTIL.GET_ACT_TOKENIZED_EXCEPTION(MIR.PLAN_ID
, MORD.OUT_REQUEST_DETAIL_ID
, MORD.EXCEPTION_TYPE
, 1)
, 1
, 200)
, 1
FROM MST_IN_REQUESTS MIR
, MST_OUT_REQUESTS MOR
, MST_OUT_REQUEST_DETAILS MORD
WHERE MOR.OUT_REQUEST_ID = MORD.OUT_REQUEST_ID
AND MOR.IN_REQUEST_ID = MIR.IN_REQUEST_ID
AND MORD.EXCEPTION_TYPE IS NOT NULL UNION ALL SELECT MIR.PLAN_ID
, MOR.IN_REQUEST_ID
, MOR.OUT_REQUEST_ID
, MORD.OUT_REQUEST_DETAIL_ID
, MORD.EXCEPTION_TYPE
, SUBSTR(MST_WB_UTIL.GET_ACT_TOKENIZED_EXCEPTION(MIR.PLAN_ID
, MORD.OUT_REQUEST_DETAIL_ID
, MORD.EXCEPTION_TYPE
, 2)
, 1
, 200)
, 2
FROM MST_IN_REQUESTS MIR
, MST_OUT_REQUESTS MOR
, MST_OUT_REQUEST_DETAILS MORD
WHERE MOR.OUT_REQUEST_ID = MORD.OUT_REQUEST_ID
AND MOR.IN_REQUEST_ID = MIR.IN_REQUEST_ID
AND MORD.EXCEPTION_TYPE IS NOT NULL
AND MORD.EXCEPTION_TYPE IN (206) ORDER BY 3
, 4
, 5
, 7