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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how can i print random rows in plsql table

1931


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2590


How can you achieve loose coupling in soa framework?

716


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3076


testing tools?

1748






tell me the scenarios of the independent in reports

2044


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1753


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2460


tell my any difficult situtation you solved in your experience in your company?

1866


What is instead of trigger in where we will use?

674


can we get profile values in report without using user exists is it possible how?

2316


what is global tempory table?

6293


Which oracle apps version you are very confident in?

703


what is the differences between internal requisition and internal sales order?

2153


how do you describe O2C along with tables

2309