When you run he report you have to get only that particular organization po numbers or item number how can do it?
Answers were Sorted based on User's Feedback
Answer / vaidinindia@gmail.com
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dheeraj kain
Simply set organization context in belofore report trigger.
e.g mo_global.set_policy_context('S','FND_PROFILE.VALUE('ORG_ID'))
and then use po_headers view to fetch needed PO_NUMBER.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is cursor?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
can we pass bind variablein lexical parameter?
AOL?
Which module is not in multiorg
What is Place holder Columns?
How will you get the concurrent program output as email?
What repots or concurrent program run to transfer data from Inventory to GL.
what is the difference between procedure and function
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
What r the validation types?
what is the differences between internal requisition and internal sales order?