View: CZ_UIDEF_SIGNATURE_TEMPLS_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_UIDEF_SIGNATURE_TEMPLS_V

View Text

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'

Columns