Value of a profile in a responsibility

Submitted by Anonymous on Tue, 01/31/2012 - 14:38

Tag:

Basics

Select fpo.profile_option_name,fpo.user_visible_flag, fpo.user_changeable_flag, fr.responsibility_key, pov.profile_option_value
from apps. fnd_profile_option_values pov,
apps. FND_RESPONSIBILITY fr,
APPS.fnd_profile_options fpo
where pov.LEVEL_VALUE_APPLICATION_ID = fr.APPLICATION_ID
AND pov.LEVEL_VALUE=fr.responsibility_id
AND fpo.profile_option_id= pov.profile_option_id
AND fpo.profile_option_name LIKE '%AR%CONTEX%' -- profile name
AND fr.responsibility_key LIKE 'XX%AR%SET%' -- responsibility name

Comments

Post new comment

Ask a Question

Sponsered Links

Latest

Can you please put the	JavaOne and Oracle Develop 2012!!
When an item is already in	need to insert a row into the
can be done in R12 by using	Thanks a lot
Very userful information	Have you run the workflow
1. Create a BPA for that	Then the booking process is

Purchase Order Form	Cash Account
How can we select data for 0 on hand in discrete job pick list report	Oracle Assets - External Mass Transfers
Stockable and Transactable	Cannot close an Order
acknowledgement of item receipt by customer	After Booking a Sales Order a Schedule Ship Date has not been derived
How to automatically create a Approved PR to a PO without using Auto create	system admin activities

OracleUG