VIEW: APPS.CZ_EXPLODED_UI_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'