Smart Forms / Information Templates

select 
tt.template_name, 
tt.template_code,
tat.attribute_code,
tat.attribute_name, 
tat.description, 
tat.creation_date, 
tab.node_display_flag displayed

from 
por_template_attributes_tl tat, 
por_template_attributes_b tab, 
por_templates_all_tl tt

where
tat.attribute_code = tab.attribute_code
and tab.template_code = tt.template_code
and tt.template_name like nvl(:p_template_name,tt.template_name)

order by 
tat.creation_date