Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_EXPLODED_UI_V |
SELECT RUDF.UI_DEF_ID AS ROOT_UI_DEF_ID
, RUDF.NAME AS ROOT_UI_NAME
, RUDF.DESC_TEXT AS ROOT_UI_DESCRIPTION
, RUDF.DEVL_PROJECT_ID AS ROOT_MODEL_ID
, RUDF.TREE_SEQ AS ROOT_UI_LIST_SEQ
, RUDF.UI_STYLE
, RUDF.GEN_VERSION
, RUDF.TREENODE_DISPLAY_SOURCE
, RUDF.GEN_HEADER
, RUDF.LOOK_AND_FEEL
, RUDF.PERSISTENT_UI_DEF_ID
, RUDF.MASTER_TEMPLATE_FLAG
, RUDF.SEEDED_FLAG
, RUDF.UI_STATUS
, UIXPL.ROOT_MODEL_EXPL_ID
, UIXPL.REFERRING_NODE_ID
, UIXPL.EXPL_NODE_DEPTH
, UIXPL.MODEL_REFERENCE_DEPTH
, UIXPL.VIRTUAL_FLAG
, UIXPL.CHILD_UI_DEF_ID
, UIXPL.CHILD_MODEL_ID
, UIXPL.REF_EXPL_NODE_ID
, UIXPL.LEAF_EXPL_NODE_ID
, UIXPL.ROOT_MDL_PARNT_EXPL_ID
, UIXPL.PARENT_UI_DEF_ID
, UIXPL.LEAF_PERSISTENT_NODE_ID
FROM CZ_UI_DEFS RUDF
, TABLE ( CAST ( CZ_MODEL_UTIL_PVT.GET_UI_REFS_UNDER_MODEL ( RUDF.UI_DEF_ID
, TO_NUMBER (NULL) ) AS "SYSTEM".CZ_UIREFS_INMODEL_TBL_TYPE ) ) UIXPL
WHERE RUDF.DELETED_FLAG = '0'
AND RUDF.MASTER_TEMPLATE_FLAG = '0'