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|
Category: OracleSaaSQueries