Identify table,fields and Field values.

[dhavalvyas]

Actually I received BRD of following type ? how to identify table,fields and Field values from the following SQL Code ?

What indicates,

1>det

2>temp

3>r

4>Term after temp. and r. 

select * from

(select det.*,

temp.BATCHOUTPUT,               

temp.reason,                    

temp.JOB_START_DTTM BatchDate,

r.RO_NAME LocationName,

row_number() over (partition by policyproposalnumber order by  RO_NAME ) seq