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 is the use of hr: security profile, while configure multiorg?

1 Answers  


Briefly list the steps for foreign currency journals?

2 Answers  


What type of issues You face in SLA

2 Answers  


Account receivable (ar) Transactions-transactions : Bill to ( customer not displayed). Value entered is not valid current field. Please re enter ? Customer is already created.

1 Answers   Oracle,


What is meant my PO?

4 Answers  


What is write off in payables? When do we use?

2 Answers   Genesis,


What are the back end process happening when closing period and opening period. This is the technical question and what are the tables updating in this process? pls help me

1 Answers   Bank Of America,


WHAT IS CLEARNCE METHOD IN AR ?

1 Answers   IBM, SOLiC,


What are the types of PO?

7 Answers   Omax,


How do U do the Analysis of discounts lost and fixing the root cause

1 Answers   Infosys, Wipro,


where should liability account define in account payable what are the steps for payment process

3 Answers   Oracle,


What is reconsilation flag in gl? What is use of this ?

3 Answers   IBM,


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)