Query to get the concurrent request phase code and status code meaning

-->

In FND_CONCURRENT_REQUESTS TABLE we have status and phase codes and not meaning, so how can we get the actual meaning of status or phase if we would like to display the actual meaning full status in the forms or reports.

Below is the query


select (select meaning from fnd_lookups where lookup_type ='CP_PROCESS_STATUS_CODE' and LOOKUP_code=fcr.phase_code) phase_value

  ,(select meaning from fnd_lookups where lookup_type ='CP_STATUS_CODE' and LOOKUP_code=fcr.STATUS_code) phase_value

 from fnd_concurrent_requests fcr where fcr.request_id=89500591