USP_AMPROEXPORT_GETPACKAGEDATA

            CREATE procedure dbo.USP_AMPROEXPORT_GETPACKAGEDATA
            (
                @AUCTIONEVENTID uniqueidentifier
            )
            as
            set nocount on;

            declare @SEQUENCEIDOFFSET int = 9999999;

            select
                AUCTIONITEM.SEQUENCEID - @SEQUENCEIDOFFSET as [SEQUENCEID],
                AUCTIONITEM.ID,
                AUCTIONITEM.LOOKUPID,
                AUCTIONITEM.NAME,
                AUCTIONITEM.DESCRIPTION,
                (select top 1 NAME from AUCTIONITEMCATEGORY where ID = AUCTIONITEM.AUCTIONITEMCATEGORYID) as [CATEGORY],
                (select top 1 NAME from AUCTIONITEMSUBCATEGORY where ID = AUCTIONITEM.AUCTIONITEMSUBCATEGORYID) as [SUBCATEGORY],
                AUCTIONITEM.TRANSACTIONMINIMUMBID, --JamesWill WI130235 Send the transaction values over

                AUCTIONITEM.EXPIRATIONDATE,
                (select sum(TRANSACTIONVALUE) from dbo.AUCTIONITEM [SUBITEM] where [SUBITEM].PACKAGEID = AUCTIONITEM.ID) as [VALUE]
            from dbo.AUCTIONITEM
            left join dbo.AUCTIONITEMRESERVATION on AUCTIONITEMRESERVATION.AUCTIONITEMID = AUCTIONITEM.ID
            left join dbo.AUCTIONITEMREVENUEPURCHASE on AUCTIONITEMREVENUEPURCHASE.AUCTIONITEMID = AUCTIONITEM.ID
            where AUCTIONITEM.TYPECODE = 1 and EVENTAUCTIONID = @AUCTIONEVENTID
                and AUCTIONITEMRESERVATION.ID is null and AUCTIONITEMREVENUEPURCHASE.ID is null --Don't include items which are sold or reserved