Interested to Buy Any Domain ? << Click Here >> for more details...
When you run he report you have to get only that particular organization po numbers or item number how can do it?
- 2 Answers
- 4504 Views
- IBM, I also Faced
- E-Mail Answers
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 are the validations you don in .CTL file in inbound interface process?
what is the use of format trigger?a
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
What do you understand by concurrent programs?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
why r u move in the cus_top only why not move another top
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Do you know what are user profiles in apps. Any examples you can give?
what is the prerequisite for defining unit of measure?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is difference between po_headers_all and po_headers
Oracle Apps Technical 
