VIEW: SYS._ALL_INSTANTIATION_DDL

Source

View Text - Preformatted

select refresh_template_id, ddl_text, ddl_num, phase
from system.repcat$_instantiation_ddl

View Text - HTML Formatted

SELECT REFRESH_TEMPLATE_ID
, DDL_TEXT
, DDL_NUM
, PHASE FROM SYSTEM.REPCAT$_INSTANTIATION_DDL