OE_ORDER_HEADERS, OE_ORDER_LINES

Execute the below SQL query in SQL Developer or TOAD in APPS Instance.

Query :

  1. Select * from OE_ORDER_HEADERS
  2. Select * from OE_ORDER_LINES


You notice that these queries do not fetch any records. Ofcourse, these are views derived from their base tables OE_ORDER_HEADERS_ALL,OE_ORDER_LINES_ALL

So, what you do in order to fetch all the records? Ofcourse, the above query may not be of use,but when you are working on complex queries with joins and working on SQL Developer,you need to verify the records.


Execute below piece of code - anonymous block.
This is for R12 instance.

BEGIN
mo_global.init('ONT');
END;

Now try running the same above queries, you notice the records fetched.