Could any one guide me , how to extract the attached yellow highlighted funds reserve complete message through query?
As the message description is stored in a look up but what is the join or condition to get the complete description from fnd_lookup table?
When we open any journal , we get journal batch window at the top. Here we have 'Funds Status'.
When we click funds status e.g., 'Failed', we get the reason description.
We have a requirement to show that detailed message in a report.