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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...