VIEW: APPS.CZ_UI_COLLECT_TMPLS_V

Source

View Text - Preformatted

SELECT UDF.UI_DEF_ID, UDF.NAME, UDF.DEVL_PROJECT_ID, UDF.COMPONENT_ID, UDF.PERSISTENT_UI_DEF_ID, UDF.MASTER_TEMPLATE_FLAG, UDF.FROM_MASTER_TEMPLATE_ID, uit.TEMPLATE_ID, uit.TEMPLATE_NAME, uit.TEMPLATE_TYPE, uit.PARENT_CONTAINER_TYPE, uit.UI_DEF_ID as template_ui_def_id FROM CZ_UI_DEFS UDF, CZ_UI_TEMPLATES uit WHERE udf.ui_def_id = uit.ui_def_id AND udf.deleted_flag = '0' AND uit.deleted_flag = '0' OR EXISTS (SELECT 1 FROM ( SELECT ui_def_id, template_id, template_ui_def_id as templ_ui_def_id FROM cz_ui_cont_type_templs uct WHERE deleted_flag = '0' UNION ALL SELECT ui_def_id, upe.ctrl_template_id as template_id, upe.ctrl_template_ui_def_id as templ_ui_def_id FROM cz_ui_page_elements upe WHERE deleted_flag = '0' UNION ALL SELECT ui_def_id, outer_page_template_id as template_id, outer_page_templ_uidef_id as templ_ui_def_id FROM cz_ui_pages WHERE deleted_flag = '0' UNION ALL SELECT ui_def_id, page_status_template_id AS template_id, page_status_templ_uidef_id AS templ_ui_def_id FROM cz_ui_pages WHERE deleted_flag = '0' UNION ALL SELECT ui_def_id, PROCESSING_PAGE_TEMPL_ID AS template_id, PROC_PAGE_TEMPL_UI_DEF_ID AS templ_ui_def_id FROM cz_ui_actions WHERE deleted_flag = '0' ) ui_templ_refs WHERE ui_templ_refs.ui_def_id = udf.ui_def_id AND uit.template_id = ui_templ_refs.template_id AND ui_templ_refs.templ_ui_def_id = uit.ui_def_id )

View Text - HTML Formatted

SELECT UDF.UI_DEF_ID
, UDF.NAME
, UDF.DEVL_PROJECT_ID
, UDF.COMPONENT_ID
, UDF.PERSISTENT_UI_DEF_ID
, UDF.MASTER_TEMPLATE_FLAG
, UDF.FROM_MASTER_TEMPLATE_ID
, UIT.TEMPLATE_ID
, UIT.TEMPLATE_NAME
, UIT.TEMPLATE_TYPE
, UIT.PARENT_CONTAINER_TYPE
, UIT.UI_DEF_ID AS TEMPLATE_UI_DEF_ID
FROM CZ_UI_DEFS UDF
, CZ_UI_TEMPLATES UIT
WHERE UDF.UI_DEF_ID = UIT.UI_DEF_ID
AND UDF.DELETED_FLAG = '0'
AND UIT.DELETED_FLAG = '0' OR EXISTS (SELECT 1
FROM ( SELECT UI_DEF_ID
, TEMPLATE_ID
, TEMPLATE_UI_DEF_ID AS TEMPL_UI_DEF_ID
FROM CZ_UI_CONT_TYPE_TEMPLS UCT
WHERE DELETED_FLAG = '0' UNION ALL SELECT UI_DEF_ID
, UPE.CTRL_TEMPLATE_ID AS TEMPLATE_ID
, UPE.CTRL_TEMPLATE_UI_DEF_ID AS TEMPL_UI_DEF_ID
FROM CZ_UI_PAGE_ELEMENTS UPE
WHERE DELETED_FLAG = '0' UNION ALL SELECT UI_DEF_ID
, OUTER_PAGE_TEMPLATE_ID AS TEMPLATE_ID
, OUTER_PAGE_TEMPL_UIDEF_ID AS TEMPL_UI_DEF_ID
FROM CZ_UI_PAGES
WHERE DELETED_FLAG = '0' UNION ALL SELECT UI_DEF_ID
, PAGE_STATUS_TEMPLATE_ID AS TEMPLATE_ID
, PAGE_STATUS_TEMPL_UIDEF_ID AS TEMPL_UI_DEF_ID
FROM CZ_UI_PAGES
WHERE DELETED_FLAG = '0' UNION ALL SELECT UI_DEF_ID
, PROCESSING_PAGE_TEMPL_ID AS TEMPLATE_ID
, PROC_PAGE_TEMPL_UI_DEF_ID AS TEMPL_UI_DEF_ID
FROM CZ_UI_ACTIONS
WHERE DELETED_FLAG = '0' ) UI_TEMPL_REFS
WHERE UI_TEMPL_REFS.UI_DEF_ID = UDF.UI_DEF_ID
AND UIT.TEMPLATE_ID = UI_TEMPL_REFS.TEMPLATE_ID
AND UI_TEMPL_REFS.TEMPL_UI_DEF_ID = UIT.UI_DEF_ID )