Can anyone tell me why in some tables in AR , AP, GL modules
they r using int_all after every table

Answers were Sorted based on User's Feedback



Can anyone tell me why in some tables in AR , AP, GL modules they r using int_all after every table..

Answer / srini

_all will represent the multiorg tables

Is This Answer Correct ?    5 Yes 1 No

Can anyone tell me why in some tables in AR , AP, GL modules they r using int_all after every table..

Answer / sugam ghosh

All _all tables are having org_id column by which you can
extract all information kept in that table for a particular
org.
For example, in PO_HEADERS_ALL table if you wish to extract
all header level information of all POs created for org 89,
you just have to run,

select * from PO_HEADERS_ALL where org_id=89;

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Apps Financial Interview Questions

What are the various information that needs to set up inventory org ? in multi org ?

2 Answers   IBM, ups,


How can i increase the number of invoices at the time of payment. Actualty in my setup it will not take more than 300 invoices. plz suggest.

2 Answers  


I paid 10,000 Rs in advance to the employee for meeting his expenses. The employee met only 5000 expenses and the remaining 5000 he has to retern to the company. How will you define it.

4 Answers   Sonata,


How you will transfer payables to general ledger?

7 Answers   HCL, IBM, TCS,


you have received excess money from the customer. now you want to refund the excess money. what is the set up for that?

4 Answers   Conacent,






What is the difference between Electronic fund transfer and wire?

1 Answers   Genesis,


In Oracle GL how to review the accounts associated with the financial statements?

1 Answers  


What is is "Depreciable Basis" which is coming in "Asset Register Report" in Oracle Fixed Assets. How to calclate the Original Cost to get the same value which is coming in the Report. I got the information that Cost - Salvage Value. Its working fine only with One Addition. If we have multiple additions, then I am not getting calculated these Depreciable Basis Amount which is coming in Asset Register Report. Can any one help me out in getting this value calculation Please. Thanks & Regards, Rajkumar Peddi Cell: 9849024872

1 Answers  


Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.

0 Answers   TCS,


On what different real time issues you worked while doing P2P cycle implementation?

0 Answers   Cap Gemini,


segment qualifier types and usage

4 Answers   Cap Gemini,


Is it possible to change the functional currency during the mid of financial year ?

9 Answers   Oracle,


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)