VIEW: APPS.MST_CARR_FAC_APPOINT_VIO_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.exception_detail_id , med.trip_id1 , mt.carrier_id , mt.trip_number , mt.mode_of_transport , wc.freight_code , flp.facility_code , (select shippingcalendar from mst_carrier_fac_calendar_v where carrier_id = mt.carrier_id and locationid = mts.stop_location_id and rownum = 1) , mts.planned_departure_date , substr ( mst_wb_util.get_local_chardtzone ( mts.stop_location_id, mts.planned_departure_date ), 1, 40 ) , mts.planned_arrival_date , substr ( mst_wb_util.get_local_chardtzone ( mts.stop_location_id, mts.planned_arrival_date ), 1, 40 ) , wl.address1 , wl.city , wl.state , wl.postal_code , wl.country , ml.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_trips mt , mst_trip_stops mts , wsh_carriers wc , fte_location_parameters flp , mfg_lookups ml , wsh_locations wl WHERE med.plan_id = mt.plan_id and med.trip_id1 = mt.trip_id and mt.carrier_id = wc.carrier_id and med.plan_id = mts.plan_id and med.stop_id1 = mts.stop_id and mts.stop_location_id = flp.location_id and mts.stop_location_id = wl.wsh_location_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.TRIP_ID1
, MT.CARRIER_ID
, MT.TRIP_NUMBER
, MT.MODE_OF_TRANSPORT
, WC.FREIGHT_CODE
, FLP.FACILITY_CODE
, (SELECT SHIPPINGCALENDAR
FROM MST_CARRIER_FAC_CALENDAR_V
WHERE CARRIER_ID = MT.CARRIER_ID
AND LOCATIONID = MTS.STOP_LOCATION_ID
AND ROWNUM = 1)
, MTS.PLANNED_DEPARTURE_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MTS.STOP_LOCATION_ID
, MTS.PLANNED_DEPARTURE_DATE )
, 1
, 40 )
, MTS.PLANNED_ARRIVAL_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MTS.STOP_LOCATION_ID
, MTS.PLANNED_ARRIVAL_DATE )
, 1
, 40 )
, WL.ADDRESS1
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, ML.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_TRIPS MT
, MST_TRIP_STOPS MTS
, WSH_CARRIERS WC
, FTE_LOCATION_PARAMETERS FLP
, MFG_LOOKUPS ML
, WSH_LOCATIONS WL
WHERE MED.PLAN_ID = MT.PLAN_ID
AND MED.TRIP_ID1 = MT.TRIP_ID
AND MT.CARRIER_ID = WC.CARRIER_ID
AND MED.PLAN_ID = MTS.PLAN_ID
AND MED.STOP_ID1 = MTS.STOP_ID
AND MTS.STOP_LOCATION_ID = FLP.LOCATION_ID
AND MTS.STOP_LOCATION_ID = WL.WSH_LOCATION_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE