UFN_TICKET_GETTICKETSTOREPRINT

CREATE function dbo.UFN_TICKET_GETTICKETSTOREPRINT(
    @REPRINTJOBID uniqueidentifier,
    @WORKSTATIONID uniqueidentifier)
returns table
as return
select distinct 
    DOCUMENT.ID,
    PROGRAM.NAME, 
    2 TEMPLATEPRINTORDER, 
    DOCUMENT.REPORTCATALOGID,
    PROGRAMDOCUMENT.PROGRAMID,
    WORKSTATIONPRINTER.PRINTERNAME,
    WORKSTATIONPRINTER.SEQUENCE PRINTERSEQUENCE,
    10 TEMPLATETYPECODE,
    null CREDITCARDPAYMENTMETHODDETAILID,
    0 ISMERCHANTCOPY,
    SALESORDER.ID SALESORDERID,
    null DOCUMENTPRINTINGHISTORYID,
    null CREDITPAYMENTID,
    null CREDITID,
    PROGRAMDOCUMENT.SEQUENCE DOCUMENTSEQUENCE,
    DOCUMENTSVGTEMPLATE.TEMPLATE as SVGTEMPLATE
from 
    dbo.SALESORDER inner join dbo.SALESORDERITEM on 
        SALESORDER.ID =  SALESORDERITEM.SALESORDERID and
        SALESORDERITEM.TYPECODE = 0    
    inner join dbo.SALESORDERITEMTICKET on SALESORDERITEM.ID = SALESORDERITEMTICKET.ID
    inner join dbo.PROGRAM on SALESORDERITEMTICKET.PROGRAMID = PROGRAM.ID
    inner join dbo.PROGRAMDOCUMENT on PROGRAMDOCUMENT.PROGRAMID = PROGRAM.ID
    inner join dbo.DOCUMENT on PROGRAMDOCUMENT.DOCUMENTID = DOCUMENT.ID            
    inner join dbo.PRINTERLIST on DOCUMENT.PRINTERLISTID = PRINTERLIST.ID
    inner join dbo.PRINTERLISTITEM on PRINTERLIST.ID = PRINTERLISTITEM.PRINTERLISTID
    inner join dbo.WORKSTATIONPRINTER on PRINTERLISTITEM.PRINTERNAME = WORKSTATIONPRINTER.PRINTERNAME            
    inner join dbo.TICKET on SALESORDERITEMTICKET.ID = TICKET.SALESORDERITEMTICKETID
    inner join dbo.TICKETPRINTINFO on TICKET.ID = TICKETPRINTINFO.TICKETID    
    left outer join dbo.DOCUMENTSVGTEMPLATE on DOCUMENT.ID = DOCUMENTSVGTEMPLATE.ID
    where
        DOCUMENT.TYPECODE = 0 and
        --SALESORDER.ID = @SALESORDERID and

        WORKSTATIONPRINTER.WORKSTATIONID = @WORKSTATIONID and
        DOCUMENT.ISACTIVE = 1 and
        TICKETPRINTINFO.REPRINTJOB = @REPRINTJOBID