Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Thursday, August 25, 2016

How to query ECE_ tables?


Begin
 MO_GLOBAL.INIT('PO');
-- mo_global.set_policy_context('S',121);
End;


select count(1)
from ECE_POO_LINES_V; --43721

select *
from ECE_POO_HEADERS_V;

select *
from ECE_POO_LINES_V;

select *
from ECE_POO_SHIPMENTS_V;

select *
from po_headers;
Posted by at
Labels: , ,

1 comment:

  1. AnonymousAugust 12, 2018 at 2:13 AM

    Thanks for sharing nice information, Hope you will share many more articles like this so that it will be helpful for many of us. Oracle Fusion Cloud Financials Training

    ReplyDelete

Subscribe to: Post Comments (Atom)