USP_DATALIST_AUCTIONPACKAGEITEM

Lists the auction items contained in an auction package.
Parameters

Parameter	Parameter Type	Mode	Description
@PACKAGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_AUCTIONPACKAGEITEM
                (
                    @PACKAGEID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        [ITEM].ID,
                        [ITEM].NAME,
                        [CATEGORY].NAME [CATEGORYNAME],
                        [SUBCATEGORY].NAME [SUBCATEGORYNAME],
                        [ITEM].TRANSACTIONVALUE,
                        EVENT.NAME [AUCTIONNAME],
                        coalesce(DL5.SITEID, DL4.SITEID, DL3.SITEID, DL2.SITEID, DL1.SITEID) [DESIGNATIONSITEID],
                        SITE.NAME [DESIGNATIONSITENAME],
                        [ITEM].BASECURRENCYID,
                        [ITEM].TRANSACTIONCURRENCYID
                    from 
                        dbo.AUCTIONITEM [ITEM]
                        left join dbo.AUCTIONITEMCATEGORY [CATEGORY] on [ITEM].AUCTIONITEMCATEGORYID = [CATEGORY].ID
                        left join dbo.AUCTIONITEMSUBCATEGORY [SUBCATEGORY] on [ITEM].AUCTIONITEMSUBCATEGORYID = [SUBCATEGORY].ID
                        left join dbo.EVENT on [ITEM].EVENTAUCTIONID = EVENT.ID
                        left join dbo.REVENUESPLIT on [ITEM].REVENUEAUCTIONDONATIONID = REVENUESPLIT.REVENUEID
                        left join dbo.DESIGNATION on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                        left join dbo.DESIGNATIONLEVEL DL1 on DL1.ID = DESIGNATION.DESIGNATIONLEVEL1ID
                        left join dbo.DESIGNATIONLEVEL DL2 on DL2.ID = DESIGNATION.DESIGNATIONLEVEL2ID
                        left join dbo.DESIGNATIONLEVEL DL3 on DL3.ID = DESIGNATION.DESIGNATIONLEVEL3ID
                        left join dbo.DESIGNATIONLEVEL DL4 on DL4.ID = DESIGNATION.DESIGNATIONLEVEL4ID
                        left join dbo.DESIGNATIONLEVEL DL5 on DL5.ID = DESIGNATION.DESIGNATIONLEVEL5ID
                        left join dbo.SITE on coalesce(DL5.SITEID, DL4.SITEID, DL3.SITEID, DL2.SITEID, DL1.SITEID) = SITE.ID
                    where [ITEM].PACKAGEID = @PACKAGEID
                    order by [ITEM].NAME