dbo.vw_ms_production_in_out_to_retur_detail

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view  dbo.vw_ms_production_in_out_to_retur_detail
---XencX---with encryption
as    

SELECT
 dt_ms_production_retur_detail.ms_item_out_detail_id AS ms_production_in_detail_id
,dt_ms_item_out_detail.id_source_header
,dt_ms_item_out_detail.mode_source 
,101 as  mode_out_id 
,'RETUR ' as  mode_out_name
,abs( dt_ms_production_retur_detail.quantity) as qty
, dt_ms_production_retur.retur_no as doc_code
, dt_ms_production_retur.retur_date as doc_date
, dt_ms_production_retur_detail.retur_info as info
, dt_ms_item_in_detail.ms_item_id   
, dt_ms_production_retur_h_status.status_production_retur_id as status_id
,enum_status_production_retur.status_production_retur_name as status_name
FROM            dt_ms_production_retur INNER JOIN
                         dt_ms_production_retur_h_status ON dt_ms_production_retur.ms_production_retur_h_status_id = dt_ms_production_retur_h_status.ms_production_retur_h_status_id INNER JOIN
                         dt_ms_production_retur_detail ON dt_ms_production_retur.ms_production_retur_id = dt_ms_production_retur_detail.ms_production_retur_id INNER JOIN
                         enum_status_production_retur ON dt_ms_production_retur_h_status.status_production_retur_id = enum_status_production_retur.status_production_retur_id INNER JOIN
                         dt_ms_item_out_detail ON dt_ms_production_retur_detail.ms_item_out_detail_id = dt_ms_item_out_detail.ms_item_out_detail_id INNER JOIN
                         dt_ms_item_in_detail ON dt_ms_item_out_detail.ms_in_item_detail_id = dt_ms_item_in_detail.ms_in_item_detail_id

GO