Can anyone tell me why in some tables in AR , AP, GL modules they r using int

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

Question Posted / sumesh

2 Answers
13522 Views
Accenture, I also Faced
E-Mail Answers

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

There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

2 Answers

how to create a journal source by user9

1 Answers Logica CMG,

What is Reporting of financial data in a project.

0 Answers

What is the value/Amount Oracle takes for COGS Account (while shipment is done)? What is the value the Oracle taken when the revenue account is created during AR Invoice creation?

1 Answers

Explain Secondary Tracking Segments.

1 Answers

what is the use of matching tab in payables options in Payables module?

1 Answers Genesis,

Is Multi Org. setup is mandetory or optional?

4 Answers

what is the difference between conversion,customization,inbound and outbound programs ?

2 Answers

encumbrence set ups?

0 Answers ABC, Hexaware,

What is primary set of book?