VIEW: APPS.FTE_STOP_ORDER_NUMBERS_V

Source

View Text - Preformatted

SELECT distinct wdd.source_header_number as "ORDER_NUMBER", wnd.name as "DELIVERY_NAME", 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, wsh_new_deliveries wnd 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 wda.delivery_id = wnd.delivery_id

View Text - HTML Formatted

SELECT DISTINCT WDD.SOURCE_HEADER_NUMBER AS "ORDER_NUMBER"
, WND.NAME AS "DELIVERY_NAME"
, 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
, WSH_NEW_DELIVERIES WND
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 WDA.DELIVERY_ID = WND.DELIVERY_ID