dbo.vw_ms_production_retur_detail_source_available

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_production_retur_detail_source_available
---XencX---with encryption
as   
SELECT       
 vw_ms_production_in_detail.ms_production_in_detail_id
, vw_ms_production_in_detail.doc_no
, vw_ms_production_in_detail.doc_date
, vw_ms_production_in_detail.part_no
, vw_ms_production_in_detail.part_name
, vw_ms_production_in_detail.uom
, vw_ms_production_in_detail.quantity AS qty_source_in
, vw_ms_production_in_detail.quantity_sisa AS qty_source_sisa 
, vw_ms_production_in_detail.ms_type_prosses_name
, vw_ms_production_in_detail.ms_car_line_no
, vw_ms_production_in_detail.ms_car_line_name
, case when  isnull(vw_ms_production_in_detail.approve_ms_cost_final_avg_id,-1) <>-1 then 1 else 0 end as is_adjusment_avg
, vw_ms_production_in_detail.price_usd
, vw_ms_production_in_detail.price
, vw_ms_production_in_detail.status_id
, vw_ms_production_in_detail.status_name
, vw_ms_production_in_detail.ms_type_prosses_id
, vw_ms_production_in_detail.ms_car_line_out_header_id
, vw_ms_production_in_detail.cancel_ms_cost_final_avg_id as cancel_ms_cost_final_avg_id_in
, vw_ms_production_in_detail.approve_ms_cost_final_avg_id as approve_ms_cost_final_avg_id_id
, vw_ms_production_in_detail.ms_item_id
, vw_ms_production_in_detail.ms_type_id  
FROM            vw_ms_production_in_detail
where vw_ms_production_in_detail.quantity_sisa>0
GO