DBA Data[Home] [Help]

VIEW: APPS.CZ_UITEMPL_UTILITY_V

Source

View Text - Preformatted

SELECT template_type_name, template_type_id, templtype_group_name, templtype_group_id, client_code from cz_ui_template_types_v WHERE templtype_group_id = 180 and client_code = 'NEWTEMPL' and template_type_id in (170,174,545,565,188,622)
View Text - HTML Formatted

SELECT TEMPLATE_TYPE_NAME
, TEMPLATE_TYPE_ID
, TEMPLTYPE_GROUP_NAME
, TEMPLTYPE_GROUP_ID
, CLIENT_CODE
FROM CZ_UI_TEMPLATE_TYPES_V
WHERE TEMPLTYPE_GROUP_ID = 180
AND CLIENT_CODE = 'NEWTEMPL'
AND TEMPLATE_TYPE_ID IN (170
, 174
, 545
, 565
, 188
, 622)