VIEW: APPS.MST_ACT_ANALYZE_CREATE_CM_V

Source

View Text - Preformatted

SELECT mor.plan_id, mor.in_request_id, mt1.trip_id, mt2.trip_id, mor.carrier_id, mor.service_level, mor.carrier_service_id, mor.vehicle_type_id, wc.freight_code, wlk.meaning, msikfv.concatenated_segments, mor.number1, mor.number2, (MST_WB_UTIL.get_cost_wihtout_cm_for_trips(mor.plan_id, mt1.trip_id, mt2.trip_id) - mor.number2) from mst_out_requests mor, wsh_lookups wlk, wsh_carriers wc, mtl_system_items_kfv msikfv, fte_vehicle_types fvt, mst_trips mt1, mst_trips mt2 WHERE mor.plan_id = mt1.plan_id and mor.plan_id = mt2.plan_id and mor.service_level = wlk.lookup_code and wlk.lookup_type = 'WSH_SERVICE_LEVELS' and mor.vehicle_type_id = fvt.vehicle_type_id and fvt.inventory_item_id = msikfv.inventory_item_id and msikfv.organization_id = fvt.organization_id and mor.carrier_id = wc.carrier_id

View Text - HTML Formatted

SELECT MOR.PLAN_ID
, MOR.IN_REQUEST_ID
, MT1.TRIP_ID
, MT2.TRIP_ID
, MOR.CARRIER_ID
, MOR.SERVICE_LEVEL
, MOR.CARRIER_SERVICE_ID
, MOR.VEHICLE_TYPE_ID
, WC.FREIGHT_CODE
, WLK.MEANING
, MSIKFV.CONCATENATED_SEGMENTS
, MOR.NUMBER1
, MOR.NUMBER2
, (MST_WB_UTIL.GET_COST_WIHTOUT_CM_FOR_TRIPS(MOR.PLAN_ID
, MT1.TRIP_ID
, MT2.TRIP_ID) - MOR.NUMBER2)
FROM MST_OUT_REQUESTS MOR
, WSH_LOOKUPS WLK
, WSH_CARRIERS WC
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, FTE_VEHICLE_TYPES FVT
, MST_TRIPS MT1
, MST_TRIPS MT2
WHERE MOR.PLAN_ID = MT1.PLAN_ID
AND MOR.PLAN_ID = MT2.PLAN_ID
AND MOR.SERVICE_LEVEL = WLK.LOOKUP_CODE
AND WLK.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'
AND MOR.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID
AND FVT.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND MSIKFV.ORGANIZATION_ID = FVT.ORGANIZATION_ID
AND MOR.CARRIER_ID = WC.CARRIER_ID