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 do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
Define multi org structure with example(take any businees).
what is mutating table and mutating error and how to solve that?
HOW CAN U KNOW THE STAUS OF PO?
what is organization id
Challenges faced during upgradation of 11i to R12
What is the Exception. Types of exception, Difference between those. And example
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
How to create a purchase order without a requisition?
What is Formula Column?
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
is UOM maintained at master level or organization level or both?