DBA Data[Home] [Help]

VIEW: APPS.CZ_UITEMPL_MESSAGES_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 in (168, 620) and client_code = 'NEWTEMPL' and template_type_id in (600,601,603,606,608,610,616,620,621,622,623,625,628,630,639)
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 IN (168
, 620)
AND CLIENT_CODE = 'NEWTEMPL'
AND TEMPLATE_TYPE_ID IN (600
, 601
, 603
, 606
, 608
, 610
, 616
, 620
, 621
, 622
, 623
, 625
, 628
, 630
, 639)