FND_LOOKUP_VALUES on Cloud?
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
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.