dbo.vw_ms_part_list_in_out_to_change_part_detail

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO





CREATE view  dbo.vw_ms_part_list_in_out_to_change_part_detail
---XencX---with encryption
as    
select
 dt_ms_assets_list.assets_list_id 
 , vw_part_list_change_part_header.ms_part_list_change_part_no as doc_no
 , vw_part_list_change_part_header.ms_part_list_change_part_date as doc_date
 , vw_part_list_change_part_detail.quantity
 , 'Change Part' AS ms_process_name
 , vw_part_list_change_part_header.ms_part_list_change_part_status_id as status_id
 , vw_part_list_change_part_header.ms_part_list_change_part_status_name as status_name
 , dt_ms_assets_list.ms_item_id
 , dt_ms_assets_list.ms_part_list_production_id
from
dt_ms_assets_list
inner join vw_part_list_change_part_header on dt_ms_assets_list.assets_list_id = vw_part_list_change_part_header.assets_list_id
inner join vw_part_list_change_part_detail on vw_part_list_change_part_header.ms_part_list_change_part_id = vw_part_list_change_part_detail.ms_part_list_change_part_id


GO