Operation Details
Description: Retreves the taxonomy term name details based on index, status 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 
TAXONOMYTERM.TAXONOMYTERMID,
TAXONOMYTERM.NAMETEXTID,
TEXTTRANSLATION.LOCALECODE,
TEXTTRANSLATION.TEXTTRANSLATIONID 
INTO
:taxonomyTermID, 
:localisationTextID,
:locale,
:textTranslationID 
FROM TAXONOMYTERM,
TAXONOMYTERMNAMELINK,
LOCALIZABLETEXT,
TEXTTRANSLATION
WHERE TAXONOMYTERM.NAMETEXTID = LOCALIZABLETEXT.LOCALIZABLETEXTID 
AND LOCALIZABLETEXT.LOCALIZABLETEXTID = TEXTTRANSLATION.LOCALIZABLETEXTID
AND TEXTTRANSLATION.LOCALECODE = TAXONOMYTERMNAMELINK.LOCALECODE
AND TAXONOMYTERMNAMELINK.NAMETEXTID = TAXONOMYTERM.NAMETEXTID 
AND TAXONOMYTERMNAMELINK.INDEXINGSTATUS= :indexingStatus
AND TAXONOMYTERMNAMELINK.LOCALECODE= :locale