| Screen or Report that shows all Responsibilities for Org Unit [message #577794] |
Wed, 20 February 2013 12:39 |
 |
rollingstar35
Messages: 4
Registered: February 2013
Location: New Jersey
|
Junior Member |
|
|
How can we find out in Oracle application from the front end,,,, the screens... or may be report that shows all responsibilities for ORG Unit 'Vision Operation' (204).
SELECT FR.RESPONSIBILITY_NAME, FPOV.PROFILE_OPTION_VALUE ORGID, NAME ORG_NAME
FROM FND_PROFILE_OPTIONS FPO,
FND_PROFILE_OPTION_VALUES FPOV,
FND_RESPONSIBILITY_TL FR,
HR_ALL_ORGANIZATION_UNITS HOU
--HR_OPERATING_UNITS HOU
WHERE --UPPER (FPO.PROFILE_OPTION_NAME) LIKE UPPER ('MO%OPERATIN%')
PROFILE_OPTION_NAME = 'ORG_ID'
AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND FPOV.LEVEL_VALUE = FR.RESPONSIBILITY_ID
AND HOU.ORGANIZATION_ID = FPOV.PROFILE_OPTION_VALUE
the above query displays the data from the backend,,I want to see how to see that data from the front end,, does anyone know the navigation, thank you so much in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
