Thursday, July 21, 2016

Query to find Person and Position R12 , link Between per_all_people and per_all_positions

--Person and Position link

SELECT PAPF.FULL_NAME,
  PAP.NAME POSITION
FROM APPS.PER_ALL_PEOPLE_F PAPF,
  APPS.PER_ALL_POSITIONS PAP,
  APPS.PER_ALL_ASSIGNMENTS_F PAAF
WHERE PAPF.PERSON_ID=PAAF.PERSON_ID
AND PAAF.POSITION_ID=PAP.POSITION_ID
  --AND PAAF.POSITION_ID='2122';
AND PAP.NAME LIKE '%SELL%';

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...