How is the profile option related to your query?
Do you have a RESP_ID column in your custom table or view?
The function FND_GLOBAL.RESP_ID returns the current responsibility, if this is what you are looking for.
For current resp. you can use FND_PROFILE.VALUE('RESP_ID') also.
My questions is to use this FND_PROFILE.VALUE('RESP_ID') or FND_PROFILE.VALUE('ORG_ID')
When ever you will run the above flex values query, it will come for all company or org id.
I want specific for one org for all the flex values when i will run the above query.
I try to initialize the query for the org_id,resp_id. But it returning for all of the org.
I have to filter out the values based on Org.Where as in the above query there is no org_id column for joing so how should i ?
Hope i make my questions right.
Look at the query in the following link:
If you said that you want only the values allowed by the cross validation rule then we would have reached a solution faster.
This is I am sharing with you folks.
This table I used fnd_flex_value_rule_usages to join with the fnd_flex_values to get the responsibility as per user want by passing the value.
No need to use the PROFILE option.
Thanks to all of you guyz.