FND_LOOKUP_VALUES on Cloud?

Content

Hi,

On EBS / R12 I used to find it useful when writing SQL to get at the system meanings behind various fields on the database.

For example, in Payables, I could look at AP_INVOICE_DISTRIBUTIONS_ALL.PA_ADDITION_FLAG and that might contain values like 'A' or 'Z' etc...

Rather than doing a long DECODE statement, I could look up the values in the FND_LOOKUP_VALUES table - e.g.

SELECT meaning, lookup_code
FROM fnd_lookup_values
WHERE lookup_type = 'PA_ADDITION_FLAG'

In Fusion I am finding that often that is no longer an option - for example, there is no longer a PA_ADDITION_FLAG Lookup Type - instead, the meanings have to be found via a Support Note - e.g.