In Oracle, USER_REPCAT_REFRESH_TEMPLATES maintains the information about the deployment templates which are owned by the current user. The deployment templates details are template name, its type and owner, and the refresh group. The structure of the dictionary view is shown below.
REFRESH_TEMPLATE_NAME [VARCHAR2(30)] - Deployment template name
OWNER [VARCHAR2(30)] - Deployment template owner.
REFRESH_GROUP_NAME [VARCHAR2(30)] - Name of the refresh group associated to the template objects during the instantiation process
TEMPLATE_COMMENT [VARCHAR2(2000)] - User Comments
PUBLIC_TEMPLATE [VARCHAR2(1)] -Determines Public or Private deployment template