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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is gap analysis, how do you defined. What are the pre-requisities?

630


What is automation of accounts payable activities (evaluated receipt settlement)?

694


what r issues faced in gl

2272


what is the difference between bonus reserve and bonus expense

3986


can any one tell me what exactly functional consultant do on daily basis? client requirements?

524






What are the types of setups in apps inventory module

1898


What are register in India localisation?

1573


What kind of budgets have you worked on?

1874


Substitute receipts and Unordered Receipts

2880


Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1251


SLA usage ans how to define setups?

2166


We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

2150


What is multi org? What is difference between 11i and 12i multi org structure?

640


I am traying to access oracle functiona/ technical interview questions asked by the consultancy "infosys", but i cant find anything when i go the to the links, i need the oracle erp techno functiona questions pls, Thanks, in advance Tovia

1901


Can I do a payment of 50 bills on a post date. If yes, then how?

1307