Question { IBM, 3525 }

When you run he report you have to get only that particular organization po numbers or item number how can do it?

Answer

We can get the item or po number on basis of its Organization. So we can provide organization id in parameter. If you want to take default organization profile then you can use SELECT FND_PROFILE.VALUE('ORG_ID') FROM DUAL; in parameter value set definition. and what ever will be token value (P_ORG) you are going to define you need to same token while defining a parameter for report. Ex: (P_ORG)