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_UICOMPONENT_HGRID_V

Source

View Text - Preformatted


SELECT decode(object_type,'PAG',( select name from cz_ps_nodes where ps_node_id = allui.ps_node_id),'') as AMNNAME, rudf.ui_def_id as root_ui_def_id, rootxp.model_id, rudf.name as root_ui_name, rudf.desc_text as root_ui_description, rudf.tree_seq as root_ui_list_seq, rudf.ui_style as root_ui_style, rtdownx.model_ref_expl_id as root_model_expl_id, rtdownx.parent_expl_node_id as root_mdl_parnt_expl_id, rtdownx.referring_node_id, rtdownx.node_depth as expl_node_depth, to_number (null) as model_reference_depth, rtdownx.virtual_flag, allui.local_ui_def_id as child_ui_def_id, allui.parent_ui_def_id as expl_parent_ui_def_id, allui.devl_project_id as child_model_id, to_number (null) as ref_expl_node_id, allui.leaf_expl_node_id as leaf_expl_node_id, allui.persistent_node_id as leaf_persistent_node_id, allui.local_ui_def_id, allui.object_type, ALLUI.object_type_code, allui.object_id, allui.name, allui.description, allui.parent_object_type, allui.parent_object_id, allui.PARENT_UI_DEF_ID as uicomp_parent_ui_def_id, allui.PS_NODE_ID as leaf_ps_node_id, allui.tree_seq, root_ui_marker, rootxp.model_ref_expl_id as root_model_start_expl_id, rootxp.parent_expl_node_id as root_start_parnt_expl_id, descxp.model_ref_expl_id as desc_model_start_expl_id, parlel.descendant_expl_id as desc_model_expl_id, allui.local_expl_node_id, allui.devl_project_id as ui_devl_project_id, '2004-09-28' AS VIEWREV, allui.PAGE_SET_ID AS LOCAL_UI_PAGE_SET_ID, (select persistent_node_id from cz_ps_nodes where ps_node_id = rtdownx.referring_node_id ) as ROOT_REFING_NODE_PERSIST_ID, rtdownx.ps_node_type as root_mdl_expl_node_type, decode (rtdownx.ps_node_type, 263, decode (rtdownx.component_id, allui.ps_node_id, rtdownx.referring_node_id, allui.ps_node_id), allui.ps_node_id ) as ROOT_MDL_PS_NODE_ID, decode (rtdownx.ps_node_type, 263, decode (rtdownx.component_id, allui.ps_node_id, ( select persistent_node_id from cz_ps_nodes where ps_node_id = rtdownx.referring_node_id ), allui.persistent_node_id), allui.persistent_node_id ) as root_mdl_persistent_node_id, parlel.desc_expl_reference_depth FROM cz_model_ref_expls rootxp, cz_model_ref_expls descxp, table ( cast ( cz_model_util_pvt.GET_PARALLEL_EXPLS ( rootxp.model_ref_expl_id, descxp.model_ref_expl_id, to_number (null) ) as "SYSTEM".cz_expl_pair_tbl) ) parlel, cz_ui_components_v allui, cz_ui_defs rudf, cz_model_ref_expls rtdownx WHERE rtdownx.deleted_flag = '0' and rtdownx.model_ref_expl_id = parlel.enclosing_expl_id and rudf.deleted_flag = '0' and rudf.devl_project_id = rootxp.model_id and rootxp.deleted_flag = '0' and descxp.deleted_flag = '0' and allui.local_EXPL_NODE_ID = parlel.descendant_expl_id

View Text - HTML Formatted

SELECT DECODE(OBJECT_TYPE
, 'PAG'
, ( SELECT NAME
FROM CZ_PS_NODES
WHERE PS_NODE_ID = ALLUI.PS_NODE_ID)
, '') AS AMNNAME
, RUDF.UI_DEF_ID AS ROOT_UI_DEF_ID
, ROOTXP.MODEL_ID
, RUDF.NAME AS ROOT_UI_NAME
, RUDF.DESC_TEXT AS ROOT_UI_DESCRIPTION
, RUDF.TREE_SEQ AS ROOT_UI_LIST_SEQ
, RUDF.UI_STYLE AS ROOT_UI_STYLE
, RTDOWNX.MODEL_REF_EXPL_ID AS ROOT_MODEL_EXPL_ID
, RTDOWNX.PARENT_EXPL_NODE_ID AS ROOT_MDL_PARNT_EXPL_ID
, RTDOWNX.REFERRING_NODE_ID
, RTDOWNX.NODE_DEPTH AS EXPL_NODE_DEPTH
, TO_NUMBER (NULL) AS MODEL_REFERENCE_DEPTH
, RTDOWNX.VIRTUAL_FLAG
, ALLUI.LOCAL_UI_DEF_ID AS CHILD_UI_DEF_ID
, ALLUI.PARENT_UI_DEF_ID AS EXPL_PARENT_UI_DEF_ID
, ALLUI.DEVL_PROJECT_ID AS CHILD_MODEL_ID
, TO_NUMBER (NULL) AS REF_EXPL_NODE_ID
, ALLUI.LEAF_EXPL_NODE_ID AS LEAF_EXPL_NODE_ID
, ALLUI.PERSISTENT_NODE_ID AS LEAF_PERSISTENT_NODE_ID
, ALLUI.LOCAL_UI_DEF_ID
, ALLUI.OBJECT_TYPE
, ALLUI.OBJECT_TYPE_CODE
, ALLUI.OBJECT_ID
, ALLUI.NAME
, ALLUI.DESCRIPTION
, ALLUI.PARENT_OBJECT_TYPE
, ALLUI.PARENT_OBJECT_ID
, ALLUI.PARENT_UI_DEF_ID AS UICOMP_PARENT_UI_DEF_ID
, ALLUI.PS_NODE_ID AS LEAF_PS_NODE_ID
, ALLUI.TREE_SEQ
, ROOT_UI_MARKER
, ROOTXP.MODEL_REF_EXPL_ID AS ROOT_MODEL_START_EXPL_ID
, ROOTXP.PARENT_EXPL_NODE_ID AS ROOT_START_PARNT_EXPL_ID
, DESCXP.MODEL_REF_EXPL_ID AS DESC_MODEL_START_EXPL_ID
, PARLEL.DESCENDANT_EXPL_ID AS DESC_MODEL_EXPL_ID
, ALLUI.LOCAL_EXPL_NODE_ID
, ALLUI.DEVL_PROJECT_ID AS UI_DEVL_PROJECT_ID
, '2004-09-28' AS VIEWREV
, ALLUI.PAGE_SET_ID AS LOCAL_UI_PAGE_SET_ID
, (SELECT PERSISTENT_NODE_ID
FROM CZ_PS_NODES
WHERE PS_NODE_ID = RTDOWNX.REFERRING_NODE_ID ) AS ROOT_REFING_NODE_PERSIST_ID
, RTDOWNX.PS_NODE_TYPE AS ROOT_MDL_EXPL_NODE_TYPE
, DECODE (RTDOWNX.PS_NODE_TYPE
, 263
, DECODE (RTDOWNX.COMPONENT_ID
, ALLUI.PS_NODE_ID
, RTDOWNX.REFERRING_NODE_ID
, ALLUI.PS_NODE_ID)
, ALLUI.PS_NODE_ID ) AS ROOT_MDL_PS_NODE_ID
, DECODE (RTDOWNX.PS_NODE_TYPE
, 263
, DECODE (RTDOWNX.COMPONENT_ID
, ALLUI.PS_NODE_ID
, ( SELECT PERSISTENT_NODE_ID
FROM CZ_PS_NODES
WHERE PS_NODE_ID = RTDOWNX.REFERRING_NODE_ID )
, ALLUI.PERSISTENT_NODE_ID)
, ALLUI.PERSISTENT_NODE_ID ) AS ROOT_MDL_PERSISTENT_NODE_ID
, PARLEL.DESC_EXPL_REFERENCE_DEPTH
FROM CZ_MODEL_REF_EXPLS ROOTXP
, CZ_MODEL_REF_EXPLS DESCXP
, TABLE ( CAST ( CZ_MODEL_UTIL_PVT.GET_PARALLEL_EXPLS ( ROOTXP.MODEL_REF_EXPL_ID
, DESCXP.MODEL_REF_EXPL_ID
, TO_NUMBER (NULL) ) AS "SYSTEM".CZ_EXPL_PAIR_TBL) ) PARLEL
, CZ_UI_COMPONENTS_V ALLUI
, CZ_UI_DEFS RUDF
, CZ_MODEL_REF_EXPLS RTDOWNX
WHERE RTDOWNX.DELETED_FLAG = '0'
AND RTDOWNX.MODEL_REF_EXPL_ID = PARLEL.ENCLOSING_EXPL_ID
AND RUDF.DELETED_FLAG = '0'
AND RUDF.DEVL_PROJECT_ID = ROOTXP.MODEL_ID
AND ROOTXP.DELETED_FLAG = '0'
AND DESCXP.DELETED_FLAG = '0'
AND ALLUI.LOCAL_EXPL_NODE_ID = PARLEL.DESCENDANT_EXPL_ID