USP_DATALIST_SALESORDER_FACILITY

Lists all facilities belonging to a sales order.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_SALESORDER_FACILITY
            (
                @CONTEXTID uniqueidentifier
            )
            as

                select
                    SALESORDERITEM.ID,
                    EVENTLOCATION.NAME,
                    ITINERARYITEM.STARTDATETIME as STARTDATETIME,
                    ITINERARYITEM.ENDDATETIME as ENDDATETIME,
                    SALESORDERITEM.TOTAL
                from dbo.SALESORDERITEM
                inner join dbo.SALESORDERITEMFACILITY on
                    SALESORDERITEM.ID = SALESORDERITEMFACILITY.ID
                inner join dbo.EVENTLOCATION on
                    SALESORDERITEMFACILITY.EVENTLOCATIONID = EVENTLOCATION.ID
                left join dbo.ITINERARYITEMLOCATION on
                    SALESORDERITEM.ID = ITINERARYITEMLOCATION.SALESORDERITEMID
                left join dbo.ITINERARYITEM on
                    ITINERARYITEM.ID = ITINERARYITEMLOCATION.ID
                where
                    SALESORDERITEM.SALESORDERID = @CONTEXTID and
                    SALESORDERITEM.TYPECODE = 7
                order by STARTDATETIME