Query to locate user defined data on Project codes

What user defined codes are populated on project codes?

How can we report on user defined data through SQL for project codes? 

• Project Master

• User Defined Fields

• User Defined Codes

The query below can be run to report on the Project Code, User Defined Field, Field Value, and Code Descriptions if a user defined code was used.

select pama_proj [Project Code],
spuf_label [Field Name],
spud_data [Field Value],
spuc_short [Short Code Description],
spuc_long [Long Code Description]
from spusrdat UDD
join spusrfld UDF on UDD.spud_field = UDF.spuf_field and UDD.spud_applid = UDF.spuf_applid and UDF.spuf_applid = 'pamaster'
join pamaster P on UDD.spud_key = P.pama_proj
left join spusrcod UDC on UDD.spud_data = UDC.spuc_value and UDC.spuc_applid = UDD.spud_applid and spuc_field = UDF.spuf_field
--where pama_proj = ''
order by spud_key