Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI Reporting

Summary

Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI Reporting

Content

Hi All,

We are trying to build an OTBI Analysis for Bank Transaction Codes. The Subject Area has 'Cash Management - Bank Statement Balances Real time' has the Statement Line Transaction Type but the Transaction Codes and the Transaction Description are stored at FND_LOOKUP_VALUES_TL.

  Is there any way that we can get the values from that table in OTBI Reporting.

The Transaction Codes and Description can be found in the Setup and Maintanence Task --> Manage Bank Statement Transaction Codes.

Please share your thoughts or ideas on how to achieve this via OTBI .