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

    Beauty_and_dBest

      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,

      jc