Advice on custom TMS query, how to link VT to responses table (Doc ID 2200295.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Thesaurus Management System - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Goal

Your trying to put together a custom query which needs to join derived custom values stored in the value_text column on the responses table, with LLT codes in TMS. These response values are also stored on a custom table.

The query is so you can compare TMS (response value is linked to the LLT) with the same on the custom table.

What's the most efficient way to join the derived LLT term(s) to the responses table, or is there an existing View?

You're thinking something like e.g. to find the terms loaded with dictionary id 1 and dictionary level 81 (which is LLT from tms_def_levels) a query similar to below:

select *
from TMS_DICT_CONTENTS
where def_dictionary_id=1
and def_level_id=81

But your not totally sure how to link to the responses table.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms