ALTER PROCEDURE [dbo].[ZVN_Rpt_PurchaseOrders09] --'PVL','POM0000007'

    @SizeRef SiteType,
    @PoNum PoNumType
AS
BEGIN
    SET NOCOUNT ON;
    EXEC dbo.SetSiteSp @Site = @SizeRef, @Infobar = NULL;

    SELECT CONVERT(DATE, A.order_date) AS OrderDate,
           B.contact,
           C.addr##1 AS Address,
           B.phone,
           C.fax_num,
           A.po_num,
           g.fname + ' ' + g.lname AS buyername,
           g.phone AS buyerphone,
           F.proj_num + '-' + F.proj_desc AS proj_desc,
           E.item + '-' + E.description AS Item,
           E.u_m AS uom,
           D.qty_ordered_conv AS Accumulated,
           0 correction,
           0 AS QtyNewOrder,
           D.Uf_ZVN_OtherNotes AS Note,
           A.Uf_ZVN_OtherNotes AS NoteOrder
    FROM po A WITH (NOLOCK)
        LEFT JOIN dbo.vendor B WITH (NOLOCK)
            ON A.vend_num = B.vend_num
        LEFT JOIN dbo.vendaddr C WITH (NOLOCK)
            ON C.vend_num = A.vend_num
        LEFT JOIN dbo.poitem D WITH (NOLOCK)
            ON D.po_num = A.po_num
        LEFT JOIN item E WITH (NOLOCK)
            ON E.item = D.item
        LEFT JOIN dbo.proj F WITH (NOLOCK)
            ON F.proj_num = ISNULL(A.Uf_ProjNum, '')
        LEFT JOIN dbo.employee g WITH (NOLOCK)
            ON A.buyer = g.username
        LEFT JOIN dbo.PVG_poitemHis H WITH (NOLOCK)
            ON H.po_num = D.po_num
    WHERE
        A.po_num = @PoNum;
END;