VIEW: APPS.CCT_QDE_ROUTE_RESULT_VW

Source

View Text - Preformatted

SELECT item_ID, item_TYPE, classification, route_result, is_route_to_all from cct_qde_route_result where is_routed = 'Y' order by start_time asc

View Text - HTML Formatted

SELECT ITEM_ID
, ITEM_TYPE
, CLASSIFICATION
, ROUTE_RESULT
, IS_ROUTE_TO_ALL
FROM CCT_QDE_ROUTE_RESULT
WHERE IS_ROUTED = 'Y' ORDER BY START_TIME ASC