?? viw_im_rtn_list.sql
字號(hào):
if object_id('dbo.Viw_IM_RTN_List') is not null
drop
create view Viw_IM_RTN_List
as
select
distinct
a.Dn_no as Dn_Number,
b.single_no as RTN_No,
b.Lotno,
a.Pono as Order_Number,
a.Itemno as HPN,
c.Description,
c.MPN,
a.Rej_Qty,
a.Unit as UoM,
a.cause as Rej_Reason,
b.rej_date as Rej_dt,
b.iscust as Consignement_flag,
b.vdr_no as Vendor_id,
a.Remark as Remark1,
b.Remark as Remark2,
a.fir_date as Creation_dt,
a.Fir_oper as Created_by,
a.che as Confirmed,
a.cher as Confirmed_by,
a.che_date as Confirmed_dt
from mrpii..Dpt_Pur_Rejectc a,Mrpii..Dpt_Pur_Reject b,mrpii..bas_item c where a.single_id = b.single_id and a.itemno = c.itemno
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -