SQL & PL/SQL

Hi,
I have a query

SELECT
cf.cstm_fld_phys_nm
FROM app.fld cf
INNER JOIN ref.dmn_ref dr
ON (cf.typ_id=dr.typ_id)
WHERE dr.cd='Transaction'
AND indicator_notify=0

This query gives me the physical name of the column. I need the value of that column.

For example, If i get the output from the above query as 'dept no' then i should get the value of the column 'dept no'.

It should be something like ,

select value from transaction_table where column_name='dept no'


Can you guys please help me out here..?

Your help would be greatly appreaciated.

Thanks