dbo.vw_ms_part_list_detail_supply

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO










CREATE view dbo.vw_ms_part_list_detail_supply
---XencX---with encryption
as  
 



SELECT   
 dt_ms_part_list_out.ms_part_list_out_id
, dt_ms_part_list_out.quantity
, dt_ms_part_list_out.quantity_new_part  
, dt_ms_part_list_out.quantity_recycle
, dt_ms_part_list_out.quantity_used
, dt_ms_part_list_out.ms_part_list_process_detail_id 
, dt_ms_part_list_out.ms_process_id
, enum_ms_part_list_process.ms_process_name  
, dt_ms_part_list_out.ms_item_out_detail_id
, enum_ms_part_list_trans.ms_trans_type_name
FROM dt_ms_part_list_out 
left outer join vw_ms_production_in_detail ON dt_ms_part_list_out.ms_item_out_detail_id = vw_ms_production_in_detail.ms_production_in_detail_id
left outer join vw_ms_production_in_detail_recycle ON dt_ms_part_list_out.ms_item_out_detail_id = vw_ms_production_in_detail_recycle.ms_production_in_detail_id
LEFT OUTER JOIN dbo.enum_ms_part_list_process ON dt_ms_part_list_out.ms_process_id = enum_ms_part_list_process.ms_process_id
LEFT OUTER JOIN dbo.enum_ms_part_list_trans ON dt_ms_part_list_out.ms_trans_type_id = enum_ms_part_list_trans.ms_trans_type_id


GO