[dbo].[GetXmlSystemOptionForVendorConnectKey]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inVendorConnectKeyId	nvarchar(4)	8
@inOptionName	varchar(128)	128

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/**
*
*    Gets an XmlSystemOption value for a VendorConnect integrator by the KeyID for the integrator.
*    @param: @inVendorConnectKeyId    The KeyID for a specific VendorConnect integrator (i.e. ADOC ).
*    @param: @inOptionName            The name of the Xml system option. (i.e. DocumentServiceUrl).
*/
CREATE PROCEDURE [dbo].[GetXmlSystemOptionForVendorConnectKey]
    @inVendorConnectKeyId nvarchar(4),
    @inOptionName varchar(128)
as
set nocount on

select
    XmlSystemOptions.[Value]
from MoversConnectVendor
inner join VendorConnect on VendorConnect.MoversConnectVendorFID = MoversConnectVendor.MoversConnectVendorID
inner join XmlSystemDataTypeMap on XmlSystemDataTypeMap.XmlSystemDataTypeMapID = VendorConnect.XmlSystemDataTypeMapFID
inner join XmlSystemOptions on XmlSystemOptions.XmlSystemFID = XmlSystemDataTypeMap.XmlSystemFID
where
    MoversConnectVendor.IntegratorKeyID = @inVendorConnectKeyId and
    XmlSystemOptions.[Name] = @inOptionName
GO
GRANT EXECUTE ON  [dbo].[GetXmlSystemOptionForVendorConnectKey] TO [MssExec]
GO