In Oracle PL/SQL, the ALL_REPCAT_TEMPLATE_OBJECTS view maintains the deployment template information accessible to the current user.
The structure of the data dictionary view attributes is as below.
refresh_template_name [VARCHAR2(30)] -Deployment template name
object_name [VARCHAR2(30)]- Deployment template object name
object_type [VARCHAR2(17)]- The object type of the deployment template object
ddl_num [NUMBER] - Specifies the order of execution of DDL statements contained in DDL_TEXT column
ddl_text[CLOB] - DDL statement to be executed to create deployment object
master_rollback_segment - Rollback segment used during the instantiation of the deployment template object
flavor_id - Flavor ID
derived_from_sname - Schema from which the deployment object is created
derived_from_oname - Object name from which the deployment object is created