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 setups in R11i for fund transfer between two bank

2 Answers  


What is the use of mo: security profile, while configure multiorg?

0 Answers  


whenever i run the programe transfered to GL from payables that programe is shown with warning error and not transferred entries to GL

1 Answers   Hitachi, Satyam,


What is ment by physical inventory reconciliation?

1 Answers  


Payment void is disabled for only one specific payment. what will be the problem..if any idea Please guide me

3 Answers   ACC,






Steps for payment batch?

2 Answers  


What is Zero-Payment in AP

4 Answers   DELL,


what is $flex used in oracle apps ?

5 Answers   iFlex,


6. TDS accounting entry

1 Answers   ABC, Arihant,


r there any setups to enable budget tab while entering journals

2 Answers   Pfizer,


what is the use of hr: security profile, while configure multiorg?

0 Answers  


how to transfer the Invoices entries from AP to GL, can any body give the answer

3 Answers   First Indian Corporation,


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)