We need a value set through which we can auto generate the incident numbers.

Summary:

We are looking to setup a value set through which we can auto generate incident numbers where incident number is a DFF on DOR. We are trying to create a Value set with a SQL query but not sure how to insert the Select clause based on which the query will run. Can someone please help on this?

Query -

select max(HRD.DEI_ATTRIBUTE2)+1

from HR_DOCUMENTS_OF_RECORD HRD, per_all_people_f papf

where 

papf.person_id = HRD.person_id 

and HRD.DEI_ATTRIBUTE_CATEGORY = 'GB_ACCIDENT_PART_A'

and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date