Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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..

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

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

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,


Define multi org structure with example(take any businees).

1 Answers   Oracle, Wipro,


what is mutating table and mutating error and how to solve that?

3 Answers  


HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,


what is organization id

2 Answers   Wipro,


Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,


What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,


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?

0 Answers  


What is Formula Column?

4 Answers  


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

2 Answers   Zensar,


is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)