View: CZ_UICOMPONENT_HGRID_V

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

View Text

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

Columns