BIP SQL to Retrieve Meaning Instead of Lookup Codes for Multi-Select FCLs
Our organization has a requirement to depict the meaning of a multi-select FCL in a BIP report. The attribute currently pulls the lookup codes properly, but when applying SQL to retrieve the meaning from the FND_LOOKUP table, no results are returned in the column. Is this possible to accomplish via BIP or OTBI?
Please see below for SQL that was used to attempt to acquired the Meaning. This SQL works fine for existing single select FCLs we currently have.
FROM fnd_lookup_values f
WHERE f.lookup_code = opty.EXTN_ATTRIBUTE_CHAR080
AND f.lookup_type = 'ABT_SOLUTIONS'