VIEW: APPS.MST_PQ_LOAD_RESULTS_V

Source

View Text - Preformatted

SELECT MPQ.QUERY_ID, P.PLAN_ID, P.COMPILE_DESIGNATOR PLAN_NAME, T.TRIP_ID, T.TRIP_NUMBER, T.MODE_OF_TRANSPORT, substr(MST_WB_UTIL.GET_MEANING ('WSH_MODE_OF_TRANSPORT', T.MODE_OF_TRANSPORT,'WSH'),1,30) MODE_DESC, T.CARRIER_ID, WC.FREIGHT_CODE CARRIER_NAME, 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 P, MST_TRIPS T, MST_PERSONAL_QUERY_RESULTS MPQ, WSH_CARRIERS WC, WSH_LOCATIONS WL1, WSH_LOCATIONS WL2, FTE_LOCATION_PARAMETERS LP1, FTE_LOCATION_PARAMETERS LP2 WHERE P.PLAN_ID = T.PLAN_ID AND t.plan_id = mpq.plan_id AND t.trip_id = mpq.trip_id AND WC.CARRIER_ID = T.CARRIER_ID AND T.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID AND T.DESTINATION_LOCATION_ID = WL2.WSH_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
, P.PLAN_ID
, P.COMPILE_DESIGNATOR PLAN_NAME
, T.TRIP_ID
, T.TRIP_NUMBER
, T.MODE_OF_TRANSPORT
, SUBSTR(MST_WB_UTIL.GET_MEANING ('WSH_MODE_OF_TRANSPORT'
, T.MODE_OF_TRANSPORT
, 'WSH')
, 1
, 30) MODE_DESC
, T.CARRIER_ID
, WC.FREIGHT_CODE CARRIER_NAME
, 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 P
, MST_TRIPS T
, MST_PERSONAL_QUERY_RESULTS MPQ
, WSH_CARRIERS WC
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, FTE_LOCATION_PARAMETERS LP1
, FTE_LOCATION_PARAMETERS LP2
WHERE P.PLAN_ID = T.PLAN_ID
AND T.PLAN_ID = MPQ.PLAN_ID
AND T.TRIP_ID = MPQ.TRIP_ID
AND WC.CARRIER_ID = T.CARRIER_ID
AND T.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID
AND T.DESTINATION_LOCATION_ID = WL2.WSH_LOCATION_ID
AND WL1.WSH_LOCATION_ID = LP1.LOCATION_ID
AND WL2.WSH_LOCATION_ID = LP2.LOCATION_ID