viw_gl_price_list.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.viw_GL_Price_List') is not null
drop view dbo.viw_GL_Price_List
go


create view viw_GL_Price_List
as
select (select count(*) from  PO_Price_Mstr where 
isnull(hpn,'')<>'' and 
hpn=a.hpn --and moq = a.moq
--and item <= a.item
and itemseq<=a.itemseq ) as Item,a.hpn,a.CPN,a.MPN,a.Description,convert(float,a.Unit_Price) as Unit_Price,a.Currency,
a.MoQ,a.Effective_dt,a.Expire_dt as Expiration_dt,
a.Basic_UoM,Vendor_UoM,a.vendor_id,b.vendor_nm

from PO_Price_Mstr a ,PO_vendor_Mstr b where a.vendor_id =b.Vendor_ID
and isnull(a.hpn,'')<>''