VIEW: APPS.MST_PQ_UA_DEL_RESULTS_V

Source

View Text - Preformatted

SELECT MPQ.QUERY_ID, D.PLAN_ID, D.DELIVERY_ID, D.DELIVERY_NUMBER, LP1.FACILITY_ID ORIGIN_FACILITY_ID, LP1.FACILITY_CODE ORIGIN_FACILITY, WL1.CITY ORIGIN_CITY, WL1.STATE ORIGIN_STATE, LP2.FACILITY_ID DESTINATION_FACILITY_ID, LP2.FACILITY_CODE DESTINATION_FACILITY, WL2.CITY DESTINATION_CITY, WL2.STATE DESTINATION_STATE FROM MST_PLANS MP, MST_DELIVERIES D, MST_PERSONAL_QUERY_RESULTS MPQ, WSH_LOCATIONS WL1, WSH_LOCATIONS WL2, FTE_LOCATION_PARAMETERS LP1, FTE_LOCATION_PARAMETERS LP2 WHERE MP.PLAN_ID = D.PLAN_ID AND MPQ.PLAN_ID = D.PLAN_ID AND MPQ.DELIVERY_ID = D.DELIVERY_ID AND WL1.WSH_LOCATION_ID = D.pickup_LOCATION_ID AND WL2.WSH_LOCATION_ID = D.dropoff_LOCATION_ID AND WL1.WSH_LOCATION_ID = LP1.LOCATION_ID AND WL2.WSH_LOCATION_ID = LP2.LOCATION_ID

View Text - HTML Formatted

SELECT MPQ.QUERY_ID
, D.PLAN_ID
, D.DELIVERY_ID
, D.DELIVERY_NUMBER
, LP1.FACILITY_ID ORIGIN_FACILITY_ID
, LP1.FACILITY_CODE ORIGIN_FACILITY
, WL1.CITY ORIGIN_CITY
, WL1.STATE ORIGIN_STATE
, LP2.FACILITY_ID DESTINATION_FACILITY_ID
, LP2.FACILITY_CODE DESTINATION_FACILITY
, WL2.CITY DESTINATION_CITY
, WL2.STATE DESTINATION_STATE
FROM MST_PLANS MP
, MST_DELIVERIES D
, MST_PERSONAL_QUERY_RESULTS MPQ
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, FTE_LOCATION_PARAMETERS LP1
, FTE_LOCATION_PARAMETERS LP2
WHERE MP.PLAN_ID = D.PLAN_ID
AND MPQ.PLAN_ID = D.PLAN_ID
AND MPQ.DELIVERY_ID = D.DELIVERY_ID
AND WL1.WSH_LOCATION_ID = D.PICKUP_LOCATION_ID
AND WL2.WSH_LOCATION_ID = D.DROPOFF_LOCATION_ID
AND WL1.WSH_LOCATION_ID = LP1.LOCATION_ID
AND WL2.WSH_LOCATION_ID = LP2.LOCATION_ID