ALL_SOURCE_AE

ALL_SOURCE_AE describes the text source of the stored objects (across all editions) accessible to the current user.

Related Views

DBA_SOURCE_AE describes the text source of all stored objects (across all editions) in the database.
USER_SOURCE_AE describes the text source of the stored objects (across all editions) owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the object
`NAME`	`VARCHAR2(30)`	Name of the object
`TYPE`	`VARCHAR2(12)`	Type of the object: `TYPE` `TYPE BODY` `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `LIBRARY` `JAVA SOURCE`
`LINE`	`NUMBER`	Line number of this line of source
`TEXT`	`VARCHAR2(4000)`	Source text
`EDITION_NAME`	`VARCHAR2(30)`	Name of the Edition