eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_UIPAGES_FOR_EXPLNODES_V

Source

View Text - Preformatted


SELECT pglist.element_id AS element_id, rootui.ui_def_id AS root_ui_def_id, rootui.NAME AS root_ui_name, getchx.root_model_id, getchx.root_model_expl_id AS ROOT_MODEL_EXPL_ID, reqnd.persistent_node_id AS ROOT_MODEL_NODE_ID, reqnd.ps_node_id AS ps_node_id_per_root_mdl, DECODE (reqnd.instantiable_flag, 4, ( SELECT DECODE (COUNT (*), 0, '1', '0') FROM cz_model_ref_expls collchk WHERE collchk.MODEL_REF_EXPL_ID = getchx.desc_expl_node_id START WITH collchk.model_ref_expl_id = pglist.local_pgbase_expl_node_id CONNECT by collchk.model_ref_expl_id = PRIOR collchk.parent_expl_node_id AND collchk.deleted_flag = '0' ), '0' ) AS node_collection_flag, pglist.local_ui_def_id AS target_ui_def_id, pageui.NAME AS target_ui_name, pglist.local_page_id AS target_page_id, pglist.local_pgbase_pers_node_id AS target_page_pers_node_id, ( TO_CHAR (rtrootnd.persistent_node_id) || DECODE (pgbase.devl_project_id, getchx.root_model_id, '', '.' || cz_developer_utils_pvt.annotated_node_path ( getchx.root_model_id, rtpguixpl.model_ref_expl_id, NVL (rtpguixpl.referring_node_id, rtpguixpl.component_id) ) ) || DECODE (pgbase.ps_node_id, getchx.root_model_id, '', pgbase.devl_project_id, '', '.' || cz_developer_utils_pvt.annotated_node_path ( pageui.devl_project_id, pglist.local_pgbase_expl_node_id, pgbase.ps_node_id) ) ) AS target_page_ann_path, pglist.display_condition_id AS target_page_dispcond_id, pglist.display_condition_comp AS target_page_dispcond_comp, pglist.display_condition_value AS target_page_dispcond_value, pglist.element_binding_flag AS element_binding_flag, DECODE (reqnd.ps_node_id, bindnd.ps_node_id, '0', '1') AS bound_via_parent_flag, 0 AS page_inclusion_depth, getchx.ref_depth AS target_page_reference_depth, getchx.root_model_expl_node_depth AS target_page_expl_node_depth, '2005-08-10 11:59' AS view_revision FROM cz_ps_nodes pgbase, cz_ps_nodes reqnd, cz_ps_nodes bindnd, cz_ui_defs rootui, cz_ps_nodes rtrootnd, cz_model_ref_expls rtpguixpl, cz_model_ref_expls pguitopxpl, cz_ui_defs pageui, ( SELECT pge.element_id, pge.element_signature_id, pge.ctrl_template_id, pge.element_type, pge.ui_def_id AS local_ui_def_id, pge.page_id AS local_page_id, pge.MODEL_REF_EXPL_ID AS local_pgelement_expl_id, pge.PERSISTENT_NODE_ID AS local_pgelement_pers_node_id, elepg.PERSISTENT_NODE_ID AS local_pgbase_pers_node_id, elepg.PAGEBASE_EXPL_NODE_ID AS local_pgbase_expl_node_id, elepg.DISPLAY_CONDITION_ID, elepg.DISPLAY_CONDITION_COMP, elepg.DISPLAY_CONDITION_VALUE, DECODE (NVL(pge.PARENT_ELEMENT_ID,0), 0, '0', '1') AS element_binding_flag FROM cz_ui_page_elements pge, cz_ui_pages elepg WHERE pge.deleted_flag = '0' AND pge.ui_def_id = elepg.ui_def_id AND pge.page_id = elepg.page_id AND elepg.deleted_flag = '0' ) pglist, ( SELECT rootx.model_id AS root_model_id, rootx.model_ref_expl_id AS root_model_expl_id, rootx.node_depth AS root_model_expl_node_depth, 0 AS ref_depth, chlxp.model_ref_expl_id AS desc_expl_node_id, chlxp.model_id AS desc_model_id, chlxp.COMPONENT_ID, chlxp.referring_node_id FROM cz_model_ref_expls chlxp, cz_model_ref_expls rootx WHERE chlxp.deleted_flag = '0' AND rootx.deleted_flag = '0' AND EXISTS ( SELECT 1 FROM cz_model_ref_expls findch WHERE findch.model_ref_expl_id = chlxp.model_ref_expl_id START WITH findch.model_ref_expl_id = rootx.model_ref_expl_id CONNECT by findch.model_ref_expl_id = PRIOR findch.child_model_expl_id AND findch.deleted_flag = '0' ) ) getchx WHERE rtrootnd.ps_node_id = getchx.root_model_id AND pgbase.persistent_node_id = pglist.local_pgbase_pers_node_id AND pgbase.devl_project_id = pageui.devl_project_id AND pgbase.deleted_flag = '0' AND ( bindnd.ps_node_id = reqnd.ps_node_id OR bindnd.ps_node_id = DECODE (reqnd.ps_node_type, 262, reqnd.parent_id, 263, reqnd.reference_id, 438, reqnd.parent_id, NULL) ) AND pageui.deleted_flag = '0' AND pageui.ui_def_id = pglist.local_ui_def_id AND rtpguixpl.deleted_flag = '0' AND rtpguixpl.model_id = getchx.root_model_id AND rtpguixpl.COMPONENT_ID = pageui.devl_project_id AND pguitopxpl.model_id = pageui.devl_project_id AND pguitopxpl.parent_expl_node_id IS NULL AND pguitopxpl.deleted_flag = '0' AND EXISTS ( SELECT 1 FROM cz_model_ref_expls req2root WHERE req2root.model_ref_expl_id = rtpguixpl.model_ref_expl_id AND req2root.deleted_flag = '0' START WITH req2root.model_ref_expl_id = getchx.root_model_expl_id CONNECT by req2root.model_ref_expl_id = PRIOR req2root.parent_expl_node_id AND req2root.deleted_flag = '0' ) AND getchx.component_id = bindnd.component_id AND ( bindnd.reference_id IS NULL OR bindnd.ps_node_id = getchx.referring_node_id ) AND bindnd.persistent_node_id = pglist.local_pgelement_pers_node_id AND getchx.desc_expl_node_id = pglist.local_pgelement_expl_id AND rootui.devl_project_id = getchx.root_model_id AND EXISTS ( SELECT 1 FROM cz_uis_for_explnodes_v xuilist WHERE xuilist.root_ui_def_id = rootui.ui_def_id AND xuilist.model_ref_expl_id = getchx.root_model_expl_id AND xuilist.encl_ui_def_id = pglist.local_ui_def_id ) AND NOT(pglist.element_signature_id IS NULL AND pglist.ctrl_template_id IS NULL AND pglist.element_type=522)

View Text - HTML Formatted

SELECT PGLIST.ELEMENT_ID AS ELEMENT_ID
, ROOTUI.UI_DEF_ID AS ROOT_UI_DEF_ID
, ROOTUI.NAME AS ROOT_UI_NAME
, GETCHX.ROOT_MODEL_ID
, GETCHX.ROOT_MODEL_EXPL_ID AS ROOT_MODEL_EXPL_ID
, REQND.PERSISTENT_NODE_ID AS ROOT_MODEL_NODE_ID
, REQND.PS_NODE_ID AS PS_NODE_ID_PER_ROOT_MDL
, DECODE (REQND.INSTANTIABLE_FLAG
, 4
, ( SELECT DECODE (COUNT (*)
, 0
, '1'
, '0')
FROM CZ_MODEL_REF_EXPLS COLLCHK
WHERE COLLCHK.MODEL_REF_EXPL_ID = GETCHX.DESC_EXPL_NODE_ID START WITH COLLCHK.MODEL_REF_EXPL_ID = PGLIST.LOCAL_PGBASE_EXPL_NODE_ID CONNECT BY COLLCHK.MODEL_REF_EXPL_ID = PRIOR COLLCHK.PARENT_EXPL_NODE_ID
AND COLLCHK.DELETED_FLAG = '0' )
, '0' ) AS NODE_COLLECTION_FLAG
, PGLIST.LOCAL_UI_DEF_ID AS TARGET_UI_DEF_ID
, PAGEUI.NAME AS TARGET_UI_NAME
, PGLIST.LOCAL_PAGE_ID AS TARGET_PAGE_ID
, PGLIST.LOCAL_PGBASE_PERS_NODE_ID AS TARGET_PAGE_PERS_NODE_ID
, ( TO_CHAR (RTROOTND.PERSISTENT_NODE_ID) || DECODE (PGBASE.DEVL_PROJECT_ID
, GETCHX.ROOT_MODEL_ID
, ''
, '.' || CZ_DEVELOPER_UTILS_PVT.ANNOTATED_NODE_PATH ( GETCHX.ROOT_MODEL_ID
, RTPGUIXPL.MODEL_REF_EXPL_ID
, NVL (RTPGUIXPL.REFERRING_NODE_ID
, RTPGUIXPL.COMPONENT_ID) ) ) || DECODE (PGBASE.PS_NODE_ID
, GETCHX.ROOT_MODEL_ID
, ''
, PGBASE.DEVL_PROJECT_ID
, ''
, '.' || CZ_DEVELOPER_UTILS_PVT.ANNOTATED_NODE_PATH ( PAGEUI.DEVL_PROJECT_ID
, PGLIST.LOCAL_PGBASE_EXPL_NODE_ID
, PGBASE.PS_NODE_ID) ) ) AS TARGET_PAGE_ANN_PATH
, PGLIST.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID
, PGLIST.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP
, PGLIST.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE
, PGLIST.ELEMENT_BINDING_FLAG AS ELEMENT_BINDING_FLAG
, DECODE (REQND.PS_NODE_ID
, BINDND.PS_NODE_ID
, '0'
, '1') AS BOUND_VIA_PARENT_FLAG
, 0 AS PAGE_INCLUSION_DEPTH
, GETCHX.REF_DEPTH AS TARGET_PAGE_REFERENCE_DEPTH
, GETCHX.ROOT_MODEL_EXPL_NODE_DEPTH AS TARGET_PAGE_EXPL_NODE_DEPTH
, '2005-08-10 11:59' AS VIEW_REVISION
FROM CZ_PS_NODES PGBASE
, CZ_PS_NODES REQND
, CZ_PS_NODES BINDND
, CZ_UI_DEFS ROOTUI
, CZ_PS_NODES RTROOTND
, CZ_MODEL_REF_EXPLS RTPGUIXPL
, CZ_MODEL_REF_EXPLS PGUITOPXPL
, CZ_UI_DEFS PAGEUI
, ( SELECT PGE.ELEMENT_ID
, PGE.ELEMENT_SIGNATURE_ID
, PGE.CTRL_TEMPLATE_ID
, PGE.ELEMENT_TYPE
, PGE.UI_DEF_ID AS LOCAL_UI_DEF_ID
, PGE.PAGE_ID AS LOCAL_PAGE_ID
, PGE.MODEL_REF_EXPL_ID AS LOCAL_PGELEMENT_EXPL_ID
, PGE.PERSISTENT_NODE_ID AS LOCAL_PGELEMENT_PERS_NODE_ID
, ELEPG.PERSISTENT_NODE_ID AS LOCAL_PGBASE_PERS_NODE_ID
, ELEPG.PAGEBASE_EXPL_NODE_ID AS LOCAL_PGBASE_EXPL_NODE_ID
, ELEPG.DISPLAY_CONDITION_ID
, ELEPG.DISPLAY_CONDITION_COMP
, ELEPG.DISPLAY_CONDITION_VALUE
, DECODE (NVL(PGE.PARENT_ELEMENT_ID
, 0)
, 0
, '0'
, '1') AS ELEMENT_BINDING_FLAG
FROM CZ_UI_PAGE_ELEMENTS PGE
, CZ_UI_PAGES ELEPG
WHERE PGE.DELETED_FLAG = '0'
AND PGE.UI_DEF_ID = ELEPG.UI_DEF_ID
AND PGE.PAGE_ID = ELEPG.PAGE_ID
AND ELEPG.DELETED_FLAG = '0' ) PGLIST
, ( SELECT ROOTX.MODEL_ID AS ROOT_MODEL_ID
, ROOTX.MODEL_REF_EXPL_ID AS ROOT_MODEL_EXPL_ID
, ROOTX.NODE_DEPTH AS ROOT_MODEL_EXPL_NODE_DEPTH
, 0 AS REF_DEPTH
, CHLXP.MODEL_REF_EXPL_ID AS DESC_EXPL_NODE_ID
, CHLXP.MODEL_ID AS DESC_MODEL_ID
, CHLXP.COMPONENT_ID
, CHLXP.REFERRING_NODE_ID
FROM CZ_MODEL_REF_EXPLS CHLXP
, CZ_MODEL_REF_EXPLS ROOTX
WHERE CHLXP.DELETED_FLAG = '0'
AND ROOTX.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1
FROM CZ_MODEL_REF_EXPLS FINDCH
WHERE FINDCH.MODEL_REF_EXPL_ID = CHLXP.MODEL_REF_EXPL_ID START WITH FINDCH.MODEL_REF_EXPL_ID = ROOTX.MODEL_REF_EXPL_ID CONNECT BY FINDCH.MODEL_REF_EXPL_ID = PRIOR FINDCH.CHILD_MODEL_EXPL_ID
AND FINDCH.DELETED_FLAG = '0' ) ) GETCHX
WHERE RTROOTND.PS_NODE_ID = GETCHX.ROOT_MODEL_ID
AND PGBASE.PERSISTENT_NODE_ID = PGLIST.LOCAL_PGBASE_PERS_NODE_ID
AND PGBASE.DEVL_PROJECT_ID = PAGEUI.DEVL_PROJECT_ID
AND PGBASE.DELETED_FLAG = '0'
AND ( BINDND.PS_NODE_ID = REQND.PS_NODE_ID OR BINDND.PS_NODE_ID = DECODE (REQND.PS_NODE_TYPE
, 262
, REQND.PARENT_ID
, 263
, REQND.REFERENCE_ID
, 438
, REQND.PARENT_ID
, NULL) )
AND PAGEUI.DELETED_FLAG = '0'
AND PAGEUI.UI_DEF_ID = PGLIST.LOCAL_UI_DEF_ID
AND RTPGUIXPL.DELETED_FLAG = '0'
AND RTPGUIXPL.MODEL_ID = GETCHX.ROOT_MODEL_ID
AND RTPGUIXPL.COMPONENT_ID = PAGEUI.DEVL_PROJECT_ID
AND PGUITOPXPL.MODEL_ID = PAGEUI.DEVL_PROJECT_ID
AND PGUITOPXPL.PARENT_EXPL_NODE_ID IS NULL
AND PGUITOPXPL.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1
FROM CZ_MODEL_REF_EXPLS REQ2ROOT
WHERE REQ2ROOT.MODEL_REF_EXPL_ID = RTPGUIXPL.MODEL_REF_EXPL_ID
AND REQ2ROOT.DELETED_FLAG = '0' START WITH REQ2ROOT.MODEL_REF_EXPL_ID = GETCHX.ROOT_MODEL_EXPL_ID CONNECT BY REQ2ROOT.MODEL_REF_EXPL_ID = PRIOR REQ2ROOT.PARENT_EXPL_NODE_ID
AND REQ2ROOT.DELETED_FLAG = '0' )
AND GETCHX.COMPONENT_ID = BINDND.COMPONENT_ID
AND ( BINDND.REFERENCE_ID IS NULL OR BINDND.PS_NODE_ID = GETCHX.REFERRING_NODE_ID )
AND BINDND.PERSISTENT_NODE_ID = PGLIST.LOCAL_PGELEMENT_PERS_NODE_ID
AND GETCHX.DESC_EXPL_NODE_ID = PGLIST.LOCAL_PGELEMENT_EXPL_ID
AND ROOTUI.DEVL_PROJECT_ID = GETCHX.ROOT_MODEL_ID
AND EXISTS ( SELECT 1
FROM CZ_UIS_FOR_EXPLNODES_V XUILIST
WHERE XUILIST.ROOT_UI_DEF_ID = ROOTUI.UI_DEF_ID
AND XUILIST.MODEL_REF_EXPL_ID = GETCHX.ROOT_MODEL_EXPL_ID
AND XUILIST.ENCL_UI_DEF_ID = PGLIST.LOCAL_UI_DEF_ID )
AND NOT(PGLIST.ELEMENT_SIGNATURE_ID IS NULL
AND PGLIST.CTRL_TEMPLATE_ID IS NULL
AND PGLIST.ELEMENT_TYPE=522)