VIEW: APPS.CZ_UIS_FOR_EXPLNODES_V

Source

View Text - Preformatted

SELECT reqxpl.model_id, reqxpl.model_ref_expl_id, rootui.ui_def_id AS root_ui_def_id, rootui.NAME AS root_ui_name, enclui.ui_def_id AS encl_ui_def_id, enclui.NAME AS encl_ui_name, DECODE (rootui.ui_def_id, enclui.ui_def_id, '1', '0') AS is_root_ui_flag, '2005-08-10' AS cz_view_revision FROM cz_model_ref_expls reqxpl, cz_ui_defs rootui, cz_ui_defs enclui WHERE reqxpl.deleted_flag = '0' AND reqxpl.model_id = rootui.devl_project_id AND rootui.deleted_flag = '0' AND enclui.ui_def_id IN ( SELECT rootui.ui_def_id FROM dual UNION ALL SELECT ref_ui_def_id FROM cz_ui_refs urf WHERE EXISTS (SELECT NULL FROM cz_model_ref_expls climbx WHERE climbx.ps_node_type = 263 AND climbx.deleted_flag = '0' AND (climbx.component_id, climbx.referring_node_id) IN (SELECT urxpl.component_id,urxpl.referring_node_id FROM cz_model_ref_expls urxpl WHERE urxpl.model_ref_expl_id=urf.model_ref_expl_id) START WITH climbx.model_ref_expl_id = reqxpl.model_ref_expl_id CONNECT BY climbx.model_ref_expl_id = PRIOR climbx.parent_expl_node_id AND climbx.deleted_flag = '0' ) START WITH urf.ui_def_id = rootui.ui_def_id CONNECT by urf.ui_def_id = PRIOR urf.ref_ui_def_id AND deleted_flag='0' AND PRIOR deleted_flag='0' )

View Text - HTML Formatted

SELECT REQXPL.MODEL_ID
, REQXPL.MODEL_REF_EXPL_ID
, ROOTUI.UI_DEF_ID AS ROOT_UI_DEF_ID
, ROOTUI.NAME AS ROOT_UI_NAME
, ENCLUI.UI_DEF_ID AS ENCL_UI_DEF_ID
, ENCLUI.NAME AS ENCL_UI_NAME
, DECODE (ROOTUI.UI_DEF_ID
, ENCLUI.UI_DEF_ID
, '1'
, '0') AS IS_ROOT_UI_FLAG
, '2005-08-10' AS CZ_VIEW_REVISION
FROM CZ_MODEL_REF_EXPLS REQXPL
, CZ_UI_DEFS ROOTUI
, CZ_UI_DEFS ENCLUI
WHERE REQXPL.DELETED_FLAG = '0'
AND REQXPL.MODEL_ID = ROOTUI.DEVL_PROJECT_ID
AND ROOTUI.DELETED_FLAG = '0'
AND ENCLUI.UI_DEF_ID IN ( SELECT ROOTUI.UI_DEF_ID
FROM DUAL UNION ALL SELECT REF_UI_DEF_ID
FROM CZ_UI_REFS URF
WHERE EXISTS (SELECT NULL
FROM CZ_MODEL_REF_EXPLS CLIMBX
WHERE CLIMBX.PS_NODE_TYPE = 263
AND CLIMBX.DELETED_FLAG = '0'
AND (CLIMBX.COMPONENT_ID
, CLIMBX.REFERRING_NODE_ID) IN (SELECT URXPL.COMPONENT_ID
, URXPL.REFERRING_NODE_ID
FROM CZ_MODEL_REF_EXPLS URXPL
WHERE URXPL.MODEL_REF_EXPL_ID=URF.MODEL_REF_EXPL_ID) START WITH CLIMBX.MODEL_REF_EXPL_ID = REQXPL.MODEL_REF_EXPL_ID CONNECT BY CLIMBX.MODEL_REF_EXPL_ID = PRIOR CLIMBX.PARENT_EXPL_NODE_ID
AND CLIMBX.DELETED_FLAG = '0' ) START WITH URF.UI_DEF_ID = ROOTUI.UI_DEF_ID CONNECT BY URF.UI_DEF_ID = PRIOR URF.REF_UI_DEF_ID
AND DELETED_FLAG='0'
AND PRIOR DELETED_FLAG='0' )