need help with the query

Hi All,

I have a below query which i am using to do the manual mock up of data as i have to go through the Performance test.

select distinct C.eods_grp_id,'DMU_1' PRTT_CDE,(select face_prfl_id from seods02.face_prfl 

                          where face_prfl_id not in 

                          (select face_prfl_id from seods02.grp_face_prfl)

and rownum=1)                       

from GRP C 

where eods_grp_id not in (select eods_grp_id from grp_face_prfl);

here i basically have to mock up the table called grp_face_prfl where the primary key is on the columns EODS_GRP_ID,FACE_PRFL_ID,PRTT_CDE

I am getting EODS_GRP_CDE,PRTT_CDE from GRP which is fine but to get FACE_PRFL_ID i have another table which is in the inner query of the select statement. unfortunately there is no join between FACE_PRFL & GRP table and hence i am writing select statement like this:

I am getting below output from my query where the value of face_prfl_id is not changing with every row:

eods_grp_id prtt_cde face_prfl_id

35016657 DMU_1 5654808

35016807 DMU_1 5654808

35016821 DMU_1 5654808

Please help how i can get the distinct value for the face_prfl_id for every row: