VIEW: APPS.FTE_STOP_HAZARD_CLASS_V

Source

View Text - Preformatted

SELECT distinct pvl.hazard_class as "HAZARD_CLASS",pvl.description as "HAZARD_CLASS_DESCRIPTION", decode(wts.stop_id,wdl.pick_up_stop_id,'LOAD',wdl.drop_off_stop_id,'UNLOAD') as "ACTIVITY", DECODE(wts.physical_stop_id, NULL, wts.stop_id, wts.physical_stop_id ) as "STOP_ID", wts.trip_id as "TRIP_ID" from wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_delivery_assignments wda, wsh_delivery_details wdd, PO_HAZARD_CLASSES_VL pvl WHERE (wts.stop_id = wdl.pick_up_stop_id or wts.stop_id = wdl.drop_off_stop_id) and wdl.delivery_id = wda.delivery_id and wda.delivery_detail_id = wdd.delivery_detail_id and wdd.hazard_class_id = pvl.hazard_class_id

View Text - HTML Formatted

SELECT DISTINCT PVL.HAZARD_CLASS AS "HAZARD_CLASS"
, PVL.DESCRIPTION AS "HAZARD_CLASS_DESCRIPTION"
, DECODE(WTS.STOP_ID
, WDL.PICK_UP_STOP_ID
, 'LOAD'
, WDL.DROP_OFF_STOP_ID
, 'UNLOAD') AS "ACTIVITY"
, DECODE(WTS.PHYSICAL_STOP_ID
, NULL
, WTS.STOP_ID
, WTS.PHYSICAL_STOP_ID ) AS "STOP_ID"
, WTS.TRIP_ID AS "TRIP_ID"
FROM WSH_TRIP_STOPS WTS
, WSH_DELIVERY_LEGS WDL
, WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WDD
, PO_HAZARD_CLASSES_VL PVL
WHERE (WTS.STOP_ID = WDL.PICK_UP_STOP_ID OR WTS.STOP_ID = WDL.DROP_OFF_STOP_ID)
AND WDL.DELIVERY_ID = WDA.DELIVERY_ID
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WDD.HAZARD_CLASS_ID = PVL.HAZARD_CLASS_ID