Operation Details
Description: Retrieves the use references 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
    UseReference.useReferenceID,
    UseReference.taxonomyTermID,
    UseReference.referenceNameTextID

INTO
    :useReferenceID,
    :taxonomyTermID,
    :referenceNameTextID
FROM
    UseReference,
    LocalizableText,
    TextTranslation
WHERE
    UseReference.referenceNameTextID = LocalizableText.localizableTextID 
    AND
    LocalizableText.localizableTextID = TextTranslation.localizableTextID 
    AND
    TextTranslation.localeCode = :locale 
    AND 
    TextTranslation.upperShortText LIKE :name