dbo.vw_ms_item_final_cost_last

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE view dbo.vw_ms_item_final_cost_last
---XencX---with encryption
AS
SELECT        
ms_item_h_price_id,ms_cost_final_avg_id
,[start_date]
, end_date
, info
, ms_item_id
, end_qty
, end_price
, end_price_usd
,carline_avg_qty
,carline_max_qty
,carline_min_qty
,carline_safty
, create_date
, create_by
, modify_date
, modify_by
FROM            vw_ms_item_final_cost
where ms_cost_final_avg_id=(  
SELECT        TOP (1) ms_cost_final_avg_id
FROM            vw_ms_item_final_avg
WHERE        (ms_cost_final_avg_status_id = 1)
ORDER BY end_date DESC
)
      

GO