USP_DATALIST_SALESORDER_ITEMGROUP

Lists the relations of sales order items.

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_ITEMGROUP
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                declare @GROUPID uniqueidentifier
                set @GROUPID = (select [SALESORDERITEMGROUP].[GROUPID] 
                    from dbo.[SALESORDERITEMGROUP]
                    where [SALESORDERITEMGROUP].[ID] = @CONTEXTID)

                select
                    [SALESORDERITEMGROUP].[ID],
                    [SALESORDERITEMGROUP].[GROUPID],
                    [SALESORDERITEMGROUP].[PARENTID]
                from dbo.[SALESORDERITEMGROUP]
                where 
                    [SALESORDERITEMGROUP].[GROUPID] = @GROUPID