9 Replies Latest reply on Aug 7, 2015 1:28 PM by Beauty_and_dBest

    How to get ALL the "real" base table in apps/apps


      Hi all,


      EBS R12.2

      OEL 6


      I am going to create custom schema and tables derived from apps schema.


      When I connect to apps/apps, there are lots of objects, synonyms, views which are pointing to other tables, synonyms, views from other schema like AP, AR, GL, etc.

      What confusing is a view contains a joined tables, then it get created with a synonym from another joined synonyms from another schema.


      How do I get the list of actual tables being accessed from these apps objects?

      I also want to count the rows of ALL the real tables and get their actual value.



      Thanks a lot,