Smart Form / Information Templates

- header

SELECT * FROM icx.por_templates_all_tl;

 

-- fields

SELECT * FROM icx.por_template_attributes_tl;

 

-- header and fields together

SELECT   ptat2.template_name

       , ptat2.template_code

       , ptat.attribute_code

       , ptat.attribute_name

       , ptat.description

       , ptat.creation_date

       , ptab.node_display_flag displayed

    FROM icx.por_template_attributes_tl ptat

       , icx.por_template_attributes_b ptab

       , icx.por_templates_all_tl ptat2

       , applsys.fnd_user fu

   WHERE ptat.attribute_code = ptab.attribute_code

     AND ptab.template_code = ptat2.template_code

     AND ptat.created_by = fu.user_id

     AND ptat2.template_name LIKE 'Consultancy Information'

ORDER BY ptat.creation_date DESC;