VIEW: APPS.MST_FAC_VEHICLE_INCOMP_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.exception_detail_id , mt.trip_id , mt.mode_of_transport , flp.facility_id , flp.facility_code , flp.description , substr(mst_wb_util.get_name(med.location_id),1,80) , wl.address1 , wl.city , wl.state , wl.postal_code , wl.country , mt.trip_number , wc.carrier_id , wc.freight_code , mt.service_level , wlk.meaning , msikfv.concatenated_segments , nvl(msi.unit_height, 0) || ' ' || msi.dimension_uom_code || ' ' || nvl(msi.unit_width, 0) || ' ' || msi.dimension_uom_code || ' ' || nvl(msi.unit_length, 0) || ' ' || msi.dimension_uom_code , nvl(flp.maximum_vehicle_height, 0) || ' ' || flp.dimensional_uom || ' ' || nvl(flp.maximum_vehicle_width, 0) || ' ' || flp.dimensional_uom || ' ' || nvl(flp.maximum_vehicle_length, 0) || ' ' || flp.dimensional_uom , ml.meaning , substr(mst_wb_util.get_workflow_status(med.plan_id, med.exception_detail_id),1,20) from mst_exception_details med , mst_trips mt , mfg_lookups ml , fte_location_parameters flp , fte_vehicle_types fvt , mtl_system_items_kfv msikfv , wsh_locations wl , wsh_carriers wc , mtl_system_items msi , wsh_lookups wlk WHERE med.status = ml.lookup_code and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.plan_id = mt.plan_id and med.trip_id1 = mt.trip_id and med.carrier_id = wc.carrier_id and med.location_id = flp.location_id and wl.wsh_location_id = flp.location_id and med.vehicle_type_id = fvt.vehicle_type_id and fvt.organization_id = msi.organization_id and fvt.inventory_item_id = msi.inventory_item_id and fvt.inventory_item_id = msikfv.inventory_item_id and fvt.organization_id = msikfv.organization_id and mt.service_level = wlk.lookup_code and wlk.lookup_type = 'WSH_SERVICE_LEVELS'

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MT.TRIP_ID
, MT.MODE_OF_TRANSPORT
, FLP.FACILITY_ID
, FLP.FACILITY_CODE
, FLP.DESCRIPTION
, SUBSTR(MST_WB_UTIL.GET_NAME(MED.LOCATION_ID)
, 1
, 80)
, WL.ADDRESS1
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, MT.TRIP_NUMBER
, WC.CARRIER_ID
, WC.FREIGHT_CODE
, MT.SERVICE_LEVEL
, WLK.MEANING
, MSIKFV.CONCATENATED_SEGMENTS
, NVL(MSI.UNIT_HEIGHT
, 0) || ' ' || MSI.DIMENSION_UOM_CODE || ' ' || NVL(MSI.UNIT_WIDTH
, 0) || ' ' || MSI.DIMENSION_UOM_CODE || ' ' || NVL(MSI.UNIT_LENGTH
, 0) || ' ' || MSI.DIMENSION_UOM_CODE
, NVL(FLP.MAXIMUM_VEHICLE_HEIGHT
, 0) || ' ' || FLP.DIMENSIONAL_UOM || ' ' || NVL(FLP.MAXIMUM_VEHICLE_WIDTH
, 0) || ' ' || FLP.DIMENSIONAL_UOM || ' ' || NVL(FLP.MAXIMUM_VEHICLE_LENGTH
, 0) || ' ' || FLP.DIMENSIONAL_UOM
, ML.MEANING
, SUBSTR(MST_WB_UTIL.GET_WORKFLOW_STATUS(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID)
, 1
, 20)
FROM MST_EXCEPTION_DETAILS MED
, MST_TRIPS MT
, MFG_LOOKUPS ML
, FTE_LOCATION_PARAMETERS FLP
, FTE_VEHICLE_TYPES FVT
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, WSH_LOCATIONS WL
, WSH_CARRIERS WC
, MTL_SYSTEM_ITEMS MSI
, WSH_LOOKUPS WLK
WHERE MED.STATUS = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.PLAN_ID = MT.PLAN_ID
AND MED.TRIP_ID1 = MT.TRIP_ID
AND MED.CARRIER_ID = WC.CARRIER_ID
AND MED.LOCATION_ID = FLP.LOCATION_ID
AND WL.WSH_LOCATION_ID = FLP.LOCATION_ID
AND MED.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID
AND FVT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND FVT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND FVT.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND FVT.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MT.SERVICE_LEVEL = WLK.LOOKUP_CODE
AND WLK.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'