How to access display mappings Description value defined in project attribute?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In Calculation, I want to use specific value defined on Display Mappings section of Object Attribute.. I have searched many tables like [niku].[ODF_MAPPINGS] and [niku].[ODF_DISPLAY_MAPPINGS] but can not find the values associated with it.

Example -

 

Environment

Release : 16.0.1

Resolution

The Display mapping Description can be found in cmn_captions_nls table. IDs below will vary from each environment and the lookup that description is needed for.

select * from CMN_LOOKUPS where id in (5027409,
5027408,
5027407)

select * from cmn_captions_nls where language_code = 'en' and pk_id in (5027409,
5027408,
5027407)