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

Last updated on NOVEMBER 28, 2022

Applies to:

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=<DEF DICTIONARY ID>
and def_level_id=<DEF LEVEL ID>

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

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.