UFN_NAMINGOPPORTUNITYRECOGNITION_INSTALLEDLOCATIONS

Returns the installed locations associated with a naming opportunity recognition record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NAMINGOPPORTUNITYRECOGNITIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_NAMINGOPPORTUNITYRECOGNITION_INSTALLEDLOCATIONS
            (
                @NAMINGOPPORTUNITYRECOGNITIONID uniqueidentifier
            )
            returns table
            as
            return 
            (
                select 
                    ID,
                    LOCATION,
                    TYPECODEID,
                    STATUSCODEID,
                    STATUSDATE
                from dbo.NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION
                where NAMINGOPPORTUNITYRECOGNITIONID = @NAMINGOPPORTUNITYRECOGNITIONID
            )