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
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