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