EBS information for table begin with all*

1)  select table_name from all_tables

2)  select view_name from all_views

3)  select distinct type from all_source 

    where name = 'CUX_SEND_MAIL_PKG' 

    and type = 'PACKAGE BODY'

    order by line;

TYPE:

PACKAGE BODY

TYPE BODY

TRIGGER

PACKAGE

PROCEDURE

FUNCTION

LIBRARY

TYPE

JAVA SOURCE