When you run he report you have to get only that particular organization po numb

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

Question Posted / rekha27

2 Answers
4528 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When you run he report you have to get only that particular organization po numbers or item number h..

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

When you run he report you have to get only that particular organization po numbers or item number h..

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

Post New Answer

More Oracle Apps Technical Interview Questions

do i need to declare bind parameter before using in the query?

2 Answers Satyam,

what is mean by confine mode and flexi mode?

2 Answers

What are the tables in GL?

3 Answers Convergys,

While running the concurrent program we will get the status, we have to change the status. How it will be done.