VIEW: APPS.MST_PQ_CM_RESULTS_V

Source

View Text - Preformatted

SELECT MPQ.QUERY_ID, P.PLAN_ID, P.COMPILE_DESIGNATOR PLAN_NAME, CMT.CM_TRIP_NUMBER, CMT.CONTINUOUS_MOVE_ID, CMT.CARRIER_ID, WC.FREIGHT_CODE CARRIER_NAME, CMT.TOTAL_TRANSPORTATION_COST TOTAL_COST, P.CURRENCY_UOM, DECODE(NVL(MCM.DEPARTURE_TIME_UNIT,2), 1,round( (NVL(CMT.START_DATE,SYSDATE)-SYSDATE),2), 2, round(((NVL(CMT.START_DATE,SYSDATE)-SYSDATE) * 24),2)) TIME_TO_DEPARTURE, NVL(MCM.DEPARTURE_TIME_UNIT,2) TIME_UNIT, SUBSTR( MST_WB_UTIL.GET_MEANING ('MST_PQ_DEP_TIME_UNIT',NVL(MCM.DEPARTURE_TIME_UNIT,2),'MFG'),1,10) TIME_UNIT_DESC FROM MST_PLANS P, MST_CM_TRIPS CMT, MST_PERSONAL_QUERY_RESULTS MPQ, WSH_CARRIERS WC, MST_CM_SELECTION_CRITERIA MCM WHERE P.PLAN_ID = CMT.PLAN_ID AND WC.CARRIER_ID = CMT.CARRIER_ID AND CMT.PLAN_ID = MPQ.PLAN_ID AND CMT.CONTINUOUS_MOVE_ID = MPQ.CONTINUOUS_MOVE_ID AND MPQ.QUERY_ID = MCM.QUERY_ID (+)

View Text - HTML Formatted

SELECT MPQ.QUERY_ID
, P.PLAN_ID
, P.COMPILE_DESIGNATOR PLAN_NAME
, CMT.CM_TRIP_NUMBER
, CMT.CONTINUOUS_MOVE_ID
, CMT.CARRIER_ID
, WC.FREIGHT_CODE CARRIER_NAME
, CMT.TOTAL_TRANSPORTATION_COST TOTAL_COST
, P.CURRENCY_UOM
, DECODE(NVL(MCM.DEPARTURE_TIME_UNIT
, 2)
, 1
, ROUND( (NVL(CMT.START_DATE
, SYSDATE)-SYSDATE)
, 2)
, 2
, ROUND(((NVL(CMT.START_DATE
, SYSDATE)-SYSDATE) * 24)
, 2)) TIME_TO_DEPARTURE
, NVL(MCM.DEPARTURE_TIME_UNIT
, 2) TIME_UNIT
, SUBSTR( MST_WB_UTIL.GET_MEANING ('MST_PQ_DEP_TIME_UNIT'
, NVL(MCM.DEPARTURE_TIME_UNIT
, 2)
, 'MFG')
, 1
, 10) TIME_UNIT_DESC
FROM MST_PLANS P
, MST_CM_TRIPS CMT
, MST_PERSONAL_QUERY_RESULTS MPQ
, WSH_CARRIERS WC
, MST_CM_SELECTION_CRITERIA MCM
WHERE P.PLAN_ID = CMT.PLAN_ID
AND WC.CARRIER_ID = CMT.CARRIER_ID
AND CMT.PLAN_ID = MPQ.PLAN_ID
AND CMT.CONTINUOUS_MOVE_ID = MPQ.CONTINUOUS_MOVE_ID
AND MPQ.QUERY_ID = MCM.QUERY_ID (+)