VIEW: APPS.MST_ARRIVAL_SET_VIOLATION_V

Source

View Text - Preformatted

SELECT distinct med.plan_id , med.exception_type , med.exception_detail_id , os.set_name , mdd.source_header_number , mdd.source_code , substr ( mst_wb_util.get_name ( mdd.ship_to_location_id ), 1, 80 ) , wl.city , wl.state , wl.postal_code , wl.country , ml.meaning , substr ( mst_wb_util.get_workflow_status ( med.plan_id, med.exception_detail_id ), 1, 20 ) from mst_exception_details med , oe_sets os , mst_delivery_details mdd , wsh_locations wl , mfg_lookups ml WHERE med.plan_id = mdd.plan_id and med.number1 = mdd.arrival_set_id and med.number1 = os.set_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code and mdd.ship_to_location_id = wl.wsh_location_id

View Text - HTML Formatted

SELECT DISTINCT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, OS.SET_NAME
, MDD.SOURCE_HEADER_NUMBER
, MDD.SOURCE_CODE
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_TO_LOCATION_ID )
, 1
, 80 )
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, ML.MEANING
, SUBSTR ( MST_WB_UTIL.GET_WORKFLOW_STATUS ( MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID )
, 1
, 20 )
FROM MST_EXCEPTION_DETAILS MED
, OE_SETS OS
, MST_DELIVERY_DETAILS MDD
, WSH_LOCATIONS WL
, MFG_LOOKUPS ML
WHERE MED.PLAN_ID = MDD.PLAN_ID
AND MED.NUMBER1 = MDD.ARRIVAL_SET_ID
AND MED.NUMBER1 = OS.SET_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE
AND MDD.SHIP_TO_LOCATION_ID = WL.WSH_LOCATION_ID