Home » Applications » Oracle Fusion Apps & E-Business Suite » Screen or Report that shows all Responsibilities for Org Unit (Oracle E-Business Suite 11i)
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.
Previous Topic: Errorr running pay_element_entry_api.create_element_entry
Next Topic: Mass User creation automation in ebs
Goto Forum:
  


Current Time: Sun Nov 23 18:39:32 CST 2014

Total time taken to generate the page: 0.08810 seconds