Wednesday, 9 October 2013

Query to know a responsibility is related to which operating unit

SELECT FRV.RESPONSIBILITY_NAME,
       PROFILE_OPTION_VALUE ORG_ID
  FROM FND_PROFILE_OPTIONS_VL FPO,
       FND_PROFILE_OPTION_VALUES FPOV,
       FND_RESPONSIBILITY_VL FRV
 WHERE FPO.PROFILE_OPTION_NAME = 'ORG_ID'
   AND FPOV.APPLICATION_ID = FPO.APPLICATION_ID
   AND FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
   AND FRV.RESPONSIBILITY_ID = FPOV.LEVEL_VALUE
   AND FPOV.LEVEL_ID = 10003
   AND FRV.RESPONSIBILITY_NAME = :resp_name

No comments:

Post a Comment