VIEW: APPS.FTE_PTRK_TOKENS_V

Source

View Text - Preformatted

SELECT legs.delivery_leg_id as "DELIVERY_LEG_ID", loc1.postal_code as "DESTINATION_POSTAL_CODE", loc1.city as "DESTINATION_CITY", loc1.state as "DESTINATION_STATE", loc1.country as "DESTINATION_COUNTRY_CODE", loc2.postal_code as "ORIGIN_POSTAL_CODE", loc2.city as "ORIGIN_CITY", loc2.state as "ORIGIN_STATE", loc2.country as "ORIGIN_COUNTRY_CODE", to_char(stops1.actual_departure_date, 'YYYY-MM-DD-HH24:MI:SS') as "SHIP_FROM_DATE", to_char(stops1.actual_departure_date, 'YYYY') as "SHIP_FROM_YEAR", to_char(stops1.actual_departure_date, 'MM') as "SHIP_FROM_MONTH", to_char(stops1.actual_departure_date, 'DD') as "SHIP_FROM_DAY", to_char(stops2.actual_arrival_date, 'YYYY-MM-DD-HH24:MI:SS') as "SHIP_TO_DATE", to_char(stops2.actual_arrival_date, 'YYYY') as "SHIP_TO_YEAR", to_char(stops2.actual_arrival_date, 'MM') as "SHIP_TO_MONTH", to_char(stops2.actual_arrival_date, 'DD') as "SHIP_TO_DAY" from wsh_locations loc1 , wsh_locations loc2,wsh_trip_stops stops1, wsh_trip_stops stops2, wsh_delivery_legs legs WHERE loc1.wsh_location_id = stops1.stop_location_id and loc2.wsh_location_id = stops2.stop_location_id and legs.pick_up_stop_id = stops1.stop_id and legs.drop_off_stop_id = stops2.stop_id

View Text - HTML Formatted

SELECT LEGS.DELIVERY_LEG_ID AS "DELIVERY_LEG_ID"
, LOC1.POSTAL_CODE AS "DESTINATION_POSTAL_CODE"
, LOC1.CITY AS "DESTINATION_CITY"
, LOC1.STATE AS "DESTINATION_STATE"
, LOC1.COUNTRY AS "DESTINATION_COUNTRY_CODE"
, LOC2.POSTAL_CODE AS "ORIGIN_POSTAL_CODE"
, LOC2.CITY AS "ORIGIN_CITY"
, LOC2.STATE AS "ORIGIN_STATE"
, LOC2.COUNTRY AS "ORIGIN_COUNTRY_CODE"
, TO_CHAR(STOPS1.ACTUAL_DEPARTURE_DATE
, 'YYYY-MM-DD-HH24:MI:SS') AS "SHIP_FROM_DATE"
, TO_CHAR(STOPS1.ACTUAL_DEPARTURE_DATE
, 'YYYY') AS "SHIP_FROM_YEAR"
, TO_CHAR(STOPS1.ACTUAL_DEPARTURE_DATE
, 'MM') AS "SHIP_FROM_MONTH"
, TO_CHAR(STOPS1.ACTUAL_DEPARTURE_DATE
, 'DD') AS "SHIP_FROM_DAY"
, TO_CHAR(STOPS2.ACTUAL_ARRIVAL_DATE
, 'YYYY-MM-DD-HH24:MI:SS') AS "SHIP_TO_DATE"
, TO_CHAR(STOPS2.ACTUAL_ARRIVAL_DATE
, 'YYYY') AS "SHIP_TO_YEAR"
, TO_CHAR(STOPS2.ACTUAL_ARRIVAL_DATE
, 'MM') AS "SHIP_TO_MONTH"
, TO_CHAR(STOPS2.ACTUAL_ARRIVAL_DATE
, 'DD') AS "SHIP_TO_DAY"
FROM WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_TRIP_STOPS STOPS1
, WSH_TRIP_STOPS STOPS2
, WSH_DELIVERY_LEGS LEGS
WHERE LOC1.WSH_LOCATION_ID = STOPS1.STOP_LOCATION_ID
AND LOC2.WSH_LOCATION_ID = STOPS2.STOP_LOCATION_ID
AND LEGS.PICK_UP_STOP_ID = STOPS1.STOP_ID
AND LEGS.DROP_OFF_STOP_ID = STOPS2.STOP_ID