USP_DATALIST_NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATIONS

This datalist returns all installed locations for a naming opportunity recognition.

Parameters

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

Definition

Copy



                    create procedure dbo.USP_DATALIST_NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATIONS
                    (
                        @RECOGNITIONID uniqueidentifier
                    )
                    as
                    set nocount on;

                    select
                        [INSTALLEDLOCATIONS].ID,
                        [INSTALLEDLOCATIONS].LOCATION,
                        (select DESCRIPTION from dbo.NAMINGOPPORTUNITYTYPECODE where NAMINGOPPORTUNITYTYPECODE.ID = [INSTALLEDLOCATIONS].TYPECODEID),
                        (select DESCRIPTION from dbo.NAMINGOPPLOCATIONSTATUSCODE where NAMINGOPPLOCATIONSTATUSCODE.ID = [INSTALLEDLOCATIONS].STATUSCODEID),
                        [INSTALLEDLOCATIONS].STATUSDATE
                    from dbo.UFN_NAMINGOPPORTUNITYRECOGNITION_INSTALLEDLOCATIONS(@RECOGNITIONID) as [INSTALLEDLOCATIONS];