Query to retrieve Employee Image – Oracle Fusion

SELECT 
 per_name.first_name, 
 per_name.last_Name,
 per_i.image_name ,
 per_i.image,
 per_i.image_id 
FROM PER_IMAGES per_i,
 per_all_people_f per_all,
per_person_names_f_v per_name
where 1=1
and PRIMARY_FLAG= 'Y'
and per_i.person_id = per_all.person_Id 
and per_name.person_id = per_all.person_id 
and per_name.name_type ='GLOBAL' 
AND ROWNUM < 10

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>