Definition:
In Oracle PL/SQL, the ALL_REPGENERATED dictionary view maintains the objects which are generated to support replication in database.
The structure of the view is as below.
SNAME [VARCHAR2(30)] - Schema name containing the generated object
ONAME [VARCHAR2(30)] - Generated object name
TYPE [VARCHAR2(12)] - Generated object type
BASE_SNAME [VARCHAR2(30)] - Object owner schema name
BASE_ONAME [VARCHAR2(30)] - Object name
BASE_TYPE [VARCHAR2(12)] - Object type
PACKAGE_PREFIX [VARCHAR2(30)] - Package prefix
PROCEDURE_PREFIX [VARCHAR2(30)] - Procedure prefix
DISTRIBUTED [VARCHAR2(1)] - Determines whether object is generated for each master or not
REASON [VARCHAR2(30)] - Reason of generating the object
