View: CZ_UIEXPL_HGRID

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_UIEXPL_HGRID

View Text

SELECT 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.PERSISTENT_NODE_ID
, ALLUI.PARENT_OBJECT_TYPE
, ALLUI.PARENT_OBJECT_ID
, ALLUI.PARENT_UI_DEF_ID AS UICOMP_PARENT_UI_DEF_ID
, ALLUI.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
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_ALL_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

Columns