View: FTE_PTRK_TOKENS_V

Product:	FTE - Transportation Execution
Description:
Implementation/DBA Data:	APPS.FTE_PTRK_TOKENS_V

View Text

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

Columns