eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MST_ACT_ADD_SHIP_LTLP_V

Source

View Text - Preformatted


SELECT mor.number1 , mir.plan_id , mir.trip_id , mir.delivery_id , mor.carrier_id , mor.carrier_service_id , mor.vehicle_type_id , mir.in_request_id , mor.char1 , wlk1.meaning , wc.freight_code , mor.service_level , wlk2.meaning , msikfv.concatenated_segments , mor.number2, mor.out_request_id, mp.currency_uom from mst_in_requests mir , mst_plans mp, mst_out_requests mor, fte_vehicle_types fvt , mtl_system_items_kfv msikfv , wsh_carriers wc , wsh_lookups wlk1 , wsh_lookups wlk2 , wsh_carrier_services wcs where mir.plan_id = mp.plan_id and mir.plan_id = mor.plan_id and mir.in_request_id = mor.in_request_id and mor.vehicle_type_id = fvt.vehicle_type_id (+) and fvt.organization_id = msikfv.organization_id (+) and fvt.inventory_item_id = msikfv.inventory_item_id (+) and mor.carrier_id = wc.carrier_id and mor.carrier_service_id = wcs.carrier_service_id and mor.char1 = wlk1.lookup_code and wlk1.lookup_type = 'WSH_MODE_OF_TRANSPORT' and mor.service_level = wlk2.lookup_code and wlk2.lookup_type = 'WSH_SERVICE_LEVELS' order by 1

View Text - HTML Formatted

SELECT MOR.NUMBER1
, MIR.PLAN_ID
, MIR.TRIP_ID
, MIR.DELIVERY_ID
, MOR.CARRIER_ID
, MOR.CARRIER_SERVICE_ID
, MOR.VEHICLE_TYPE_ID
, MIR.IN_REQUEST_ID
, MOR.CHAR1
, WLK1.MEANING
, WC.FREIGHT_CODE
, MOR.SERVICE_LEVEL
, WLK2.MEANING
, MSIKFV.CONCATENATED_SEGMENTS
, MOR.NUMBER2
, MOR.OUT_REQUEST_ID
, MP.CURRENCY_UOM
FROM MST_IN_REQUESTS MIR
, MST_PLANS MP
, MST_OUT_REQUESTS MOR
, FTE_VEHICLE_TYPES FVT
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, WSH_CARRIERS WC
, WSH_LOOKUPS WLK1
, WSH_LOOKUPS WLK2
, WSH_CARRIER_SERVICES WCS
WHERE MIR.PLAN_ID = MP.PLAN_ID
AND MIR.PLAN_ID = MOR.PLAN_ID
AND MIR.IN_REQUEST_ID = MOR.IN_REQUEST_ID
AND MOR.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID (+)
AND FVT.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID (+)
AND FVT.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID (+)
AND MOR.CARRIER_ID = WC.CARRIER_ID
AND MOR.CARRIER_SERVICE_ID = WCS.CARRIER_SERVICE_ID
AND MOR.CHAR1 = WLK1.LOOKUP_CODE
AND WLK1.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND MOR.SERVICE_LEVEL = WLK2.LOOKUP_CODE
AND WLK2.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS' ORDER BY 1