Answer / sangeetha

po_headers is a VIEW
while po_headers_all is a TABLE

Answer / sanjoy mukhopadhyay, cesc ltd,

Po_headers_all is a table which stores org_id as a column.
But Po_headers is a multi-org sensitive view of
po_headers_all.
Actually , any table in oracle apps , having _all in its
name at last position is a table with org_id and without
this _all is a view of that table which shows data
pertaining to the org_id through which apps uaser has
logged in ( based on profile set up , reponsibility level )

Answer / prasanth

PO_HEADERS IS A VIEW WHERE AS
PO_HEADERS_ALL IS A TABLE ,The difference is po_headers_all contains all operating units information, where as po_headers contains particular operating unit information.so po_headers is the best.because of security.if any person login he can see only that particular operating unit information.he cant see all operating unit information

Answer / devi nossam

here we can see clearly
po_headers_all is base table(multi org table)
po_lines_all is view(multi org view)

difference is

when we create a report in report builder,we can directly
run the report with out executing the some api's

where it is in view means we have to run api's in [pl/sql )
the api's are

begin
fnd_profile.get('org_id');
end;

Answer / mry

both are related to purchase module.

-all table is multiorg level table

what is the use of anchors?

2 Answers   IBM,

---

What are the requests groups?

3 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

---

how many layout sections are tehre in layout editor?

1 Answers  

---

---

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

---

where we find the status of order information.

2 Answers  

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

what is the invoice matching

2 Answers  

---

Is it possible to do purchase order without requisition?

8 Answers  

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---