eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_UIDEF_SIGNATURE_TEMPLS_V

Source

View Text - Preformatted


SELECT UCTT.UI_DEF_ID, RELS.OBJECT_TYPE AS SIGNATURE_ID, uctt.TEMPLATE_ID, UCTT.TEMPLATE_UI_DEF_ID, '1' AS EXACT_TEMPL_ASSIGN_FLAG FROM CZ_UI_CONT_TYPE_TEMPLS UCTT, CZ_TYPE_RELATIONSHIPS RELS WHERE UCTT.DELETED_FLAG = '0' AND RELS.SUBJECT_TYPE = UCTT.CONTENT_TYPE AND RELS.REL_TYPE_CODE = 'CNV' AND RELS.DELETED_FLAG = '0'

View Text - HTML Formatted

SELECT UCTT.UI_DEF_ID
, RELS.OBJECT_TYPE AS SIGNATURE_ID
, UCTT.TEMPLATE_ID
, UCTT.TEMPLATE_UI_DEF_ID
, '1' AS EXACT_TEMPL_ASSIGN_FLAG
FROM CZ_UI_CONT_TYPE_TEMPLS UCTT
, CZ_TYPE_RELATIONSHIPS RELS
WHERE UCTT.DELETED_FLAG = '0'
AND RELS.SUBJECT_TYPE = UCTT.CONTENT_TYPE
AND RELS.REL_TYPE_CODE = 'CNV'
AND RELS.DELETED_FLAG = '0'