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 multi org?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How to create user and how u attach with responsibility.
What is SRW Package? (Sql Report Writer)
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
Tell me some errors names and number what u got while developing the reports?
why r u transer the data base tables to flat file and what is use
what is pick selection list generation report.
Which one Module is Biggest Module in oracle apps?
how will you refer a report column (data column,formula,summery,placeholderr)?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
How You Will display the key flexifields in your report