In Oracle PL/SQL, ALL_REPCAT_REFRESH_TEMPLATES maintains information about the deployment templates which can be accessed by the currently logged in user. Deployment templates details are template name, its type, owner, and refresh group.
The structure of the dictionary view is as 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