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%';

1 Comments :

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle AME , kindly contact us http://www.maxmunus.com/contactMaxMunus Offer World Class Virtual Instructor led training on Oracle AME . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/

Reply

Post a Comment