[dbo].[spRevenueGetItemsForRatePlan

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inOrderId	int	4

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
* Don't use this stored proc directly but instead use spRevenueGetItemsForRatePlan_Synonym.
* spRevenueGetItemsForRatePlan_Synonym will either point to this stored proc or to
* spRevenueGetItemsForRatePlan_XLedger if that is active.
*
*
*    Description: ItemCodes that are associated to a specific order's rate plan..
*
*    @params:
*    @inOrderId: The primary key for the current order.
*
*/

CREATE PROCEDURE [dbo].[spRevenueGetItemsForRatePlan_Legacy]
    @inOrderId int
as
set nocount on

select distinct
    ItemCode.ICPriKey,
    ItemCode.ItemCode,
    ItemCode.[Description]
from Rates
inner join ItemCode on Rates.ICPriKey = ItemCode.ICPriKey
inner join Orders on Rates.RPPriKey = Orders.RPPriKey
where Orders.PriKey = @inOrderId
GO
GRANT EXECUTE ON  [dbo].[spRevenueGetItemsForRatePlan_Legacy] TO [MssExec]
GO