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