VIEW: APPS.MST_SHIP_SET_VIOLATION_V

Source

View Text - Preformatted

SELECT distinct med.plan_id , med.exception_type , med.exception_detail_id , os.set_name , to_number ( null ) , to_char ( null ) , mdd.source_header_number , mdd.source_code , substr ( mst_wb_util.get_name ( mdd.ship_from_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.ship_set_id and mdd.ship_from_location_id = wl.wsh_location_id and med.number1 = os.set_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code union all select distinct med.plan_id , med.exception_type , med.exception_detail_id , to_char ( null ) , oola.line_number , oola.ordered_item , mdd.source_header_number , mdd.source_code , substr ( mst_wb_util.get_name ( mdd.ship_from_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 , mst_delivery_details mdd , oe_order_lines_all oola , wsh_locations wl , mfg_lookups ml where med.plan_id = mdd.plan_id and med.number2 = mdd.top_model_line_id and oola.line_id = mdd.top_model_line_id and mdd.ship_from_location_id = wl.wsh_location_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code

View Text - HTML Formatted

SELECT DISTINCT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, OS.SET_NAME
, TO_NUMBER ( NULL )
, TO_CHAR ( NULL )
, MDD.SOURCE_HEADER_NUMBER
, MDD.SOURCE_CODE
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_FROM_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.SHIP_SET_ID
AND MDD.SHIP_FROM_LOCATION_ID = WL.WSH_LOCATION_ID
AND MED.NUMBER1 = OS.SET_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE UNION ALL SELECT DISTINCT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, TO_CHAR ( NULL )
, OOLA.LINE_NUMBER
, OOLA.ORDERED_ITEM
, MDD.SOURCE_HEADER_NUMBER
, MDD.SOURCE_CODE
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_FROM_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
, MST_DELIVERY_DETAILS MDD
, OE_ORDER_LINES_ALL OOLA
, WSH_LOCATIONS WL
, MFG_LOOKUPS ML
WHERE MED.PLAN_ID = MDD.PLAN_ID
AND MED.NUMBER2 = MDD.TOP_MODEL_LINE_ID
AND OOLA.LINE_ID = MDD.TOP_MODEL_LINE_ID
AND MDD.SHIP_FROM_LOCATION_ID = WL.WSH_LOCATION_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE