VIEW: APPS.MST_ACT_CARRIER_SERVICE_V

Source

View Text - Preformatted

SELECT mor.plan_id, mor.in_request_id, mor.carrier_id, mor.carrier_service_id, wc.freight_code, mor.service_level, wlk.meaning, wlk1.meaning, msikfv.concatenated_segments, mor.vehicle_type_id, nvl(number2, 0), nvl(number3, 0), nvl(number4, 0), mp.currency_uom from mst_out_requests mor, wsh_lookups wlk, wsh_lookups wlk1, wsh_carriers wc, wsh_carrier_services wcs, mtl_system_items_kfv msikfv, fte_vehicle_types fvt, mst_plans mp WHERE mor.service_level = wlk.lookup_code and wlk.lookup_type = 'WSH_SERVICE_LEVELS' and mor.carrier_service_id = wcs.carrier_service_id and wcs.mode_of_transport = wlk1.lookup_code and wlk1.lookup_type = 'WSH_MODE_OF_TRANSPORT' and wc.carrier_id = mor.carrier_id and fvt.vehicle_type_id (+) = mor.vehicle_type_id and fvt.organization_id = msikfv.organization_id (+) and fvt.inventory_item_id = msikfv.inventory_item_id (+) and mor.plan_id = mp.plan_id

View Text - HTML Formatted

SELECT MOR.PLAN_ID
, MOR.IN_REQUEST_ID
, MOR.CARRIER_ID
, MOR.CARRIER_SERVICE_ID
, WC.FREIGHT_CODE
, MOR.SERVICE_LEVEL
, WLK.MEANING
, WLK1.MEANING
, MSIKFV.CONCATENATED_SEGMENTS
, MOR.VEHICLE_TYPE_ID
, NVL(NUMBER2
, 0)
, NVL(NUMBER3
, 0)
, NVL(NUMBER4
, 0)
, MP.CURRENCY_UOM
FROM MST_OUT_REQUESTS MOR
, WSH_LOOKUPS WLK
, WSH_LOOKUPS WLK1
, WSH_CARRIERS WC
, WSH_CARRIER_SERVICES WCS
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, FTE_VEHICLE_TYPES FVT
, MST_PLANS MP
WHERE MOR.SERVICE_LEVEL = WLK.LOOKUP_CODE
AND WLK.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'
AND MOR.CARRIER_SERVICE_ID = WCS.CARRIER_SERVICE_ID
AND WCS.MODE_OF_TRANSPORT = WLK1.LOOKUP_CODE
AND WLK1.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND WC.CARRIER_ID = MOR.CARRIER_ID
AND FVT.VEHICLE_TYPE_ID (+) = MOR.VEHICLE_TYPE_ID
AND FVT.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID (+)
AND FVT.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID (+)
AND MOR.PLAN_ID = MP.PLAN_ID