VIEW: APPS.MST_CM_IMPROPER_TIME_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.trip_id1 , med.trip_id2 , med.carrier_id , mct.continuous_move_id , med.exception_detail_id , mct.cm_trip_number , wc.freight_code , mct.service_level , wlk.meaning , msikfv.concatenated_segments , ml2.meaning , ml1.meaning , substr(mst_wb_util.get_threshold_value(med.exception_type),1,20) , substr(mst_wb_util.get_workflow_status(med.plan_id, med.exception_detail_id),1,20) from mst_exception_details med , mst_cm_trips mct , mfg_lookups ml1 , mfg_lookups ml2 , fte_vehicle_types fvt , mtl_system_items_kfv msikfv , wsh_carriers wc , wsh_lookups wlk WHERE med.status = ml1.lookup_code and ml1.lookup_type = 'MST_EXCEPTION_STATUS' and nvl(mct.planned_flag, 2) = ml2.lookup_code and ml2.lookup_type = 'MST_CM_TRIP_PLANNED_FLAG' and med.continuous_move_id = mct.continuous_move_id and med.carrier_id = wc.carrier_id and med.vehicle_type_id = fvt.vehicle_type_id and fvt.inventory_item_id = msikfv.inventory_item_id and fvt.organization_id = msikfv.organization_id and mct.service_level = wlk.lookup_code and wlk.lookup_type = 'WSH_SERVICE_LEVELS'

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.TRIP_ID1
, MED.TRIP_ID2
, MED.CARRIER_ID
, MCT.CONTINUOUS_MOVE_ID
, MED.EXCEPTION_DETAIL_ID
, MCT.CM_TRIP_NUMBER
, WC.FREIGHT_CODE
, MCT.SERVICE_LEVEL
, WLK.MEANING
, MSIKFV.CONCATENATED_SEGMENTS
, ML2.MEANING
, ML1.MEANING
, SUBSTR(MST_WB_UTIL.GET_THRESHOLD_VALUE(MED.EXCEPTION_TYPE)
, 1
, 20)
, SUBSTR(MST_WB_UTIL.GET_WORKFLOW_STATUS(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID)
, 1
, 20)
FROM MST_EXCEPTION_DETAILS MED
, MST_CM_TRIPS MCT
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, FTE_VEHICLE_TYPES FVT
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, WSH_CARRIERS WC
, WSH_LOOKUPS WLK
WHERE MED.STATUS = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND NVL(MCT.PLANNED_FLAG
, 2) = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'MST_CM_TRIP_PLANNED_FLAG'
AND MED.CONTINUOUS_MOVE_ID = MCT.CONTINUOUS_MOVE_ID
AND MED.CARRIER_ID = WC.CARRIER_ID
AND MED.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID
AND FVT.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND FVT.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MCT.SERVICE_LEVEL = WLK.LOOKUP_CODE
AND WLK.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'