Operation Details
Description: Retrieves the related concepts based on name and locale. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.
Sterotype: nsmulti
SQL 
SELECT
    RelatedConcept.relatedConceptID,
    RelatedConcept.code,
    RelatedConcept.nameTextID,
    RelatedConcept.customConceptInd,
    RelatedConcept.commentsTextID,
    RelatedConcept.codeUpper,
    RelatedConcept.versionNo
INTO
    :relatedConceptID,
    :code,
    :nameTextID,
    :customConceptInd,
    :commentsTextID,
    :codeUpper,
    :versionNo
FROM
    RelatedConcept,
    LocalizableText,
    TextTranslation
WHERE
    RelatedConcept.nameTextID = LocalizableText.localizableTextID AND
    LocalizableText.localizableTextID = TextTranslation.localizableTextID AND
    TextTranslation.localeCode = :locale 
AND 
    TextTranslation.upperShortText LIKE :name