VIEW: APPS.CZ_UI_COMPONENTS_V

Source

View Text - Preformatted

SELECT udf.UI_DEF_ID as local_ui_def_id, udf.devl_project_id, 'UDF' as object_type, CZ_UTILS.CONV_NUM (udf.UI_STYLE) AS OBJECT_TYPE_CODE, udf.UI_DEF_ID AS OBJECT_ID, to_char (null) as parent_object_type, to_number (null) as parent_object_id, to_number (null) as parent_ui_def_id, udf.tree_seq, xpl.model_ref_expl_id AS local_EXPL_NODE_ID, xpl.model_ref_expl_id AS leaf_EXPL_NODE_ID, udf.devl_project_id as ps_node_id, rootn.persistent_node_id, udf.NAME, udf.DESC_TEXT as description, udf.ui_def_id as root_ui_marker, TO_NUMBER(NULL) AS page_set_id FROM CZ_UI_DEFS udf, cz_model_ref_expls xpl, cz_ps_nodes rootn WHERE UDF.master_template_flag = '0' and udf.devl_project_id = xpl.model_id and xpl.deleted_flag = '0' and xpl.parent_expl_node_id is null and rootn.ps_node_id = udf.devl_project_id and rootn.deleted_flag = '0' and udf.DELETED_FLAG = '0' UNION ALL SELECT udf.UI_DEF_ID as local_ui_def_id, udf.devl_project_id, uicmpv.data_value as object_type, CZ_UTILS.CONV_NUM (udf.UI_STYLE) AS OBJECT_TYPE_CODE, udf.UI_DEF_ID AS OBJECT_ID, 'UDF' as parent_object_type, udf.ui_def_id as parent_object_id, udf.ui_def_id as parent_ui_def_id, uicmpv.value_seq as tree_seq, xpl.model_ref_expl_id AS local_EXPL_NODE_ID, xpl.model_ref_expl_id AS leaf_EXPL_NODE_ID, udf.devl_project_id as ps_node_id, rootn.persistent_node_id, uicmpv.value_label as NAME, uicmpv.value_description as description, to_number (null) as root_ui_marker, TO_NUMBER(NULL) as page_set_id FROM CZ_UI_DEFS udf, cz_model_ref_expls xpl, cz_ps_nodes rootn, cz_uicomponents_lkv uicmpv WHERE uicmpv.data_value like '%List' and udf.devl_project_id = xpl.model_id and xpl.deleted_flag = '0' and xpl.parent_expl_node_id is null and rootn.ps_node_id = udf.devl_project_id and rootn.deleted_flag = '0' and udf.DELETED_FLAG = '0' UNION ALL SELECT PAG.UI_DEF_ID as local_ui_def_id, pgudf.devl_project_id, 'PAG' as object_type, -1 as object_type_code, pag.PAGE_ID as object_id, 'UI Page List' as parent_object_type, pgudf.ui_def_id as parent_object_id, pgudf.ui_def_id as parent_ui_def_id, to_number (null) as tree_seq, pag.PAGEBASE_EXPL_NODE_ID as local_expl_node_id, pag.PAGEBASE_EXPL_NODE_ID as leaf_expl_node_id, pgpsn.ps_node_id, pag.PERSISTENT_NODE_ID, pag.NAME, pag.DESC_TEXT as description, to_number (null) as root_ui_marker, PAG.page_set_id as page_set_id FROM CZ_UI_PAGES PAG, cz_ui_defs pgudf, cz_ps_nodes pgpsn, cz_model_ref_expls pgxpl where pag.deleted_flag = '0' and pag.ui_def_id = pgudf.ui_def_id and pgudf.deleted_flag = '0' and pag.pagebase_expl_node_id = pgxpl.model_ref_expl_id and pgxpl.deleted_flag = '0' and pgxpl.component_id = pgpsn.component_id and ((pgpsn.reference_id IS NULL ) OR (pgxpl.referring_node_id = pgpsn.ps_node_id)) AND pgpsn.persistent_node_id = pag.persistent_node_id and pgpsn.deleted_flag = '0' UNION ALL SELECT PST.UI_DEF_ID as local_ui_def_id, psudf.devl_project_id, DECODE (PST.PAGE_SET_TYPE, 2, 'MNU', 3, 'MNU', 4, 'MNU', 'PGF' ) AS OBJECT_TYPE, PST.PAGE_SET_TYPE AS OBJECT_TYPE_CODE, PST.PAGE_SET_ID AS OBJECT_ID, DECODE (PST.PAGE_SET_TYPE, 2, 'UI Menu List', 3, 'UI Menu List', 4, 'UI Menu List', 'UI Page Flow List' ) as parent_object_type, psudf.ui_def_id as parent_object_id, psudf.ui_def_id as parent_ui_def_id, to_number (null) as tree_seq, pst.PAGEBASE_EXPL_NODE_ID AS LOCAL_EXPL_NODE_ID, pst.PAGEBASE_EXPL_NODE_ID AS leaf_EXPL_NODE_ID, PSPSN.PS_NODE_ID AS PS_NODE_ID, pst.PERSISTENT_NODE_ID, PST.NAME, PST.DESCRIPTION, to_number (null) as root_ui_marker, TO_NUMBER(NULL) as page_set_id FROM CZ_UI_PAGE_SETS PST, CZ_UI_DEFS PSUDF, CZ_PS_NODES PSPSN, cz_model_ref_expls psxpl WHERE PSUDF.UI_DEF_ID = PST.UI_DEF_ID AND PSUDF.DELETED_FLAG = '0' AND pst.pagebase_expl_node_id = psxpl.model_ref_expl_id and psxpl.deleted_flag = '0' and psxpl.component_id = pspsn.component_id and ((pspsn.reference_id IS NULL ) OR (psxpl.referring_node_id = pspsn.ps_node_id)) AND PSPSN.DELETED_FLAG = '0' AND PSPSN.PERSISTENT_NODE_ID = PST.PERSISTENT_NODE_ID AND PST.DELETED_FLAG = '0' union all SELECT urf.UI_DEF_ID AS LOCAL_UI_DEF_ID, fromui.devl_project_id, 'URF' as object_type, -1 as object_type_code, urf.model_ref_expl_ID AS OBJECT_ID, 'UI Reference List' AS PARENT_OBJECT_TYPE, urf.ui_def_id as parent_object_id, urf.ui_def_id as parent_ui_def_id, to_number (null) as tree_seq, urf.MODEL_REF_EXPL_ID as local_expl_node_id, fromxpl.child_model_expl_id as leaf_expl_node_id, fromxpl.referring_node_id as ps_node_id, urf.REF_PERSISTENT_NODE_ID, targui.NAME, targui.desc_text as DESCRIPTION, to_number (null) as root_ui_marker, TO_NUMBER(NULL) as page_set_id FROM CZ_UI_REFS urf, cz_ui_defs fromui, cz_model_ref_expls fromxpl, cz_ui_defs targui WHERE targui.deleted_flag = '0' and targui.ui_def_id = urf.ref_ui_def_id and fromxpl.deleted_flag = '0' and fromxpl.model_ref_expl_id = urf.model_ref_expl_id and urf.DELETED_FLAG = '0' and fromui.deleted_flag = '0' and fromui.ui_def_id = urf.ui_def_id UNION ALL select rfudf.ref_ui_def_id as local_ui_def_id, refxp.model_id as devl_project_id, lslkv.data_value as object_type, lslkv.numeric_id_value as object_type_code, rfudf.ref_ui_def_id as object_id, 'URF' as parent_object_type, rfudf.model_ref_expl_id as parent_object_id, rfudf.ui_def_id as parent_ui_def_id, lslkv.value_seq as tree_seq, refxp.child_model_expl_id as local_expl_node_id, refxp.child_model_expl_id as leaf_expl_node_id, refxp.component_id as ps_node_id, refrt.persistent_node_id, lslkv.value_label as name, lslkv.value_description as description, to_number (null) as root_ui_marker, TO_NUMBER(NULL) as page_set_id from cz_ui_refs rfudf, cz_uicomponents_lkv lslkv, cz_ps_nodes refrt, cz_model_ref_expls refxp where lslkv.data_value like '%List' and rfudf.deleted_flag = '0' and rfudf.model_ref_expl_id = refxp.model_ref_expl_id and refxp.component_id = refrt.ps_node_id and refrt.deleted_flag = '0' and refxp.deleted_flag = '0'

View Text - HTML Formatted

SELECT UDF.UI_DEF_ID AS LOCAL_UI_DEF_ID
, UDF.DEVL_PROJECT_ID
, 'UDF' AS OBJECT_TYPE
, CZ_UTILS.CONV_NUM (UDF.UI_STYLE) AS OBJECT_TYPE_CODE
, UDF.UI_DEF_ID AS OBJECT_ID
, TO_CHAR (NULL) AS PARENT_OBJECT_TYPE
, TO_NUMBER (NULL) AS PARENT_OBJECT_ID
, TO_NUMBER (NULL) AS PARENT_UI_DEF_ID
, UDF.TREE_SEQ
, XPL.MODEL_REF_EXPL_ID AS LOCAL_EXPL_NODE_ID
, XPL.MODEL_REF_EXPL_ID AS LEAF_EXPL_NODE_ID
, UDF.DEVL_PROJECT_ID AS PS_NODE_ID
, ROOTN.PERSISTENT_NODE_ID
, UDF.NAME
, UDF.DESC_TEXT AS DESCRIPTION
, UDF.UI_DEF_ID AS ROOT_UI_MARKER
, TO_NUMBER(NULL) AS PAGE_SET_ID
FROM CZ_UI_DEFS UDF
, CZ_MODEL_REF_EXPLS XPL
, CZ_PS_NODES ROOTN
WHERE UDF.MASTER_TEMPLATE_FLAG = '0'
AND UDF.DEVL_PROJECT_ID = XPL.MODEL_ID
AND XPL.DELETED_FLAG = '0'
AND XPL.PARENT_EXPL_NODE_ID IS NULL
AND ROOTN.PS_NODE_ID = UDF.DEVL_PROJECT_ID
AND ROOTN.DELETED_FLAG = '0'
AND UDF.DELETED_FLAG = '0' UNION ALL SELECT UDF.UI_DEF_ID AS LOCAL_UI_DEF_ID
, UDF.DEVL_PROJECT_ID
, UICMPV.DATA_VALUE AS OBJECT_TYPE
, CZ_UTILS.CONV_NUM (UDF.UI_STYLE) AS OBJECT_TYPE_CODE
, UDF.UI_DEF_ID AS OBJECT_ID
, 'UDF' AS PARENT_OBJECT_TYPE
, UDF.UI_DEF_ID AS PARENT_OBJECT_ID
, UDF.UI_DEF_ID AS PARENT_UI_DEF_ID
, UICMPV.VALUE_SEQ AS TREE_SEQ
, XPL.MODEL_REF_EXPL_ID AS LOCAL_EXPL_NODE_ID
, XPL.MODEL_REF_EXPL_ID AS LEAF_EXPL_NODE_ID
, UDF.DEVL_PROJECT_ID AS PS_NODE_ID
, ROOTN.PERSISTENT_NODE_ID
, UICMPV.VALUE_LABEL AS NAME
, UICMPV.VALUE_DESCRIPTION AS DESCRIPTION
, TO_NUMBER (NULL) AS ROOT_UI_MARKER
, TO_NUMBER(NULL) AS PAGE_SET_ID
FROM CZ_UI_DEFS UDF
, CZ_MODEL_REF_EXPLS XPL
, CZ_PS_NODES ROOTN
, CZ_UICOMPONENTS_LKV UICMPV
WHERE UICMPV.DATA_VALUE LIKE '%LIST'
AND UDF.DEVL_PROJECT_ID = XPL.MODEL_ID
AND XPL.DELETED_FLAG = '0'
AND XPL.PARENT_EXPL_NODE_ID IS NULL
AND ROOTN.PS_NODE_ID = UDF.DEVL_PROJECT_ID
AND ROOTN.DELETED_FLAG = '0'
AND UDF.DELETED_FLAG = '0' UNION ALL SELECT PAG.UI_DEF_ID AS LOCAL_UI_DEF_ID
, PGUDF.DEVL_PROJECT_ID
, 'PAG' AS OBJECT_TYPE
, -1 AS OBJECT_TYPE_CODE
, PAG.PAGE_ID AS OBJECT_ID
, 'UI PAGE LIST' AS PARENT_OBJECT_TYPE
, PGUDF.UI_DEF_ID AS PARENT_OBJECT_ID
, PGUDF.UI_DEF_ID AS PARENT_UI_DEF_ID
, TO_NUMBER (NULL) AS TREE_SEQ
, PAG.PAGEBASE_EXPL_NODE_ID AS LOCAL_EXPL_NODE_ID
, PAG.PAGEBASE_EXPL_NODE_ID AS LEAF_EXPL_NODE_ID
, PGPSN.PS_NODE_ID
, PAG.PERSISTENT_NODE_ID
, PAG.NAME
, PAG.DESC_TEXT AS DESCRIPTION
, TO_NUMBER (NULL) AS ROOT_UI_MARKER
, PAG.PAGE_SET_ID AS PAGE_SET_ID
FROM CZ_UI_PAGES PAG
, CZ_UI_DEFS PGUDF
, CZ_PS_NODES PGPSN
, CZ_MODEL_REF_EXPLS PGXPL
WHERE PAG.DELETED_FLAG = '0'
AND PAG.UI_DEF_ID = PGUDF.UI_DEF_ID
AND PGUDF.DELETED_FLAG = '0'
AND PAG.PAGEBASE_EXPL_NODE_ID = PGXPL.MODEL_REF_EXPL_ID
AND PGXPL.DELETED_FLAG = '0'
AND PGXPL.COMPONENT_ID = PGPSN.COMPONENT_ID
AND ((PGPSN.REFERENCE_ID IS NULL ) OR (PGXPL.REFERRING_NODE_ID = PGPSN.PS_NODE_ID))
AND PGPSN.PERSISTENT_NODE_ID = PAG.PERSISTENT_NODE_ID
AND PGPSN.DELETED_FLAG = '0' UNION ALL SELECT PST.UI_DEF_ID AS LOCAL_UI_DEF_ID
, PSUDF.DEVL_PROJECT_ID
, DECODE (PST.PAGE_SET_TYPE
, 2
, 'MNU'
, 3
, 'MNU'
, 4
, 'MNU'
, 'PGF' ) AS OBJECT_TYPE
, PST.PAGE_SET_TYPE AS OBJECT_TYPE_CODE
, PST.PAGE_SET_ID AS OBJECT_ID
, DECODE (PST.PAGE_SET_TYPE
, 2
, 'UI MENU LIST'
, 3
, 'UI MENU LIST'
, 4
, 'UI MENU LIST'
, 'UI PAGE FLOW LIST' ) AS PARENT_OBJECT_TYPE
, PSUDF.UI_DEF_ID AS PARENT_OBJECT_ID
, PSUDF.UI_DEF_ID AS PARENT_UI_DEF_ID
, TO_NUMBER (NULL) AS TREE_SEQ
, PST.PAGEBASE_EXPL_NODE_ID AS LOCAL_EXPL_NODE_ID
, PST.PAGEBASE_EXPL_NODE_ID AS LEAF_EXPL_NODE_ID
, PSPSN.PS_NODE_ID AS PS_NODE_ID
, PST.PERSISTENT_NODE_ID
, PST.NAME
, PST.DESCRIPTION
, TO_NUMBER (NULL) AS ROOT_UI_MARKER
, TO_NUMBER(NULL) AS PAGE_SET_ID
FROM CZ_UI_PAGE_SETS PST
, CZ_UI_DEFS PSUDF
, CZ_PS_NODES PSPSN
, CZ_MODEL_REF_EXPLS PSXPL
WHERE PSUDF.UI_DEF_ID = PST.UI_DEF_ID
AND PSUDF.DELETED_FLAG = '0'
AND PST.PAGEBASE_EXPL_NODE_ID = PSXPL.MODEL_REF_EXPL_ID
AND PSXPL.DELETED_FLAG = '0'
AND PSXPL.COMPONENT_ID = PSPSN.COMPONENT_ID
AND ((PSPSN.REFERENCE_ID IS NULL ) OR (PSXPL.REFERRING_NODE_ID = PSPSN.PS_NODE_ID))
AND PSPSN.DELETED_FLAG = '0'
AND PSPSN.PERSISTENT_NODE_ID = PST.PERSISTENT_NODE_ID
AND PST.DELETED_FLAG = '0' UNION ALL SELECT URF.UI_DEF_ID AS LOCAL_UI_DEF_ID
, FROMUI.DEVL_PROJECT_ID
, 'URF' AS OBJECT_TYPE
, -1 AS OBJECT_TYPE_CODE
, URF.MODEL_REF_EXPL_ID AS OBJECT_ID
, 'UI REFERENCE LIST' AS PARENT_OBJECT_TYPE
, URF.UI_DEF_ID AS PARENT_OBJECT_ID
, URF.UI_DEF_ID AS PARENT_UI_DEF_ID
, TO_NUMBER (NULL) AS TREE_SEQ
, URF.MODEL_REF_EXPL_ID AS LOCAL_EXPL_NODE_ID
, FROMXPL.CHILD_MODEL_EXPL_ID AS LEAF_EXPL_NODE_ID
, FROMXPL.REFERRING_NODE_ID AS PS_NODE_ID
, URF.REF_PERSISTENT_NODE_ID
, TARGUI.NAME
, TARGUI.DESC_TEXT AS DESCRIPTION
, TO_NUMBER (NULL) AS ROOT_UI_MARKER
, TO_NUMBER(NULL) AS PAGE_SET_ID
FROM CZ_UI_REFS URF
, CZ_UI_DEFS FROMUI
, CZ_MODEL_REF_EXPLS FROMXPL
, CZ_UI_DEFS TARGUI
WHERE TARGUI.DELETED_FLAG = '0'
AND TARGUI.UI_DEF_ID = URF.REF_UI_DEF_ID
AND FROMXPL.DELETED_FLAG = '0'
AND FROMXPL.MODEL_REF_EXPL_ID = URF.MODEL_REF_EXPL_ID
AND URF.DELETED_FLAG = '0'
AND FROMUI.DELETED_FLAG = '0'
AND FROMUI.UI_DEF_ID = URF.UI_DEF_ID UNION ALL SELECT RFUDF.REF_UI_DEF_ID AS LOCAL_UI_DEF_ID
, REFXP.MODEL_ID AS DEVL_PROJECT_ID
, LSLKV.DATA_VALUE AS OBJECT_TYPE
, LSLKV.NUMERIC_ID_VALUE AS OBJECT_TYPE_CODE
, RFUDF.REF_UI_DEF_ID AS OBJECT_ID
, 'URF' AS PARENT_OBJECT_TYPE
, RFUDF.MODEL_REF_EXPL_ID AS PARENT_OBJECT_ID
, RFUDF.UI_DEF_ID AS PARENT_UI_DEF_ID
, LSLKV.VALUE_SEQ AS TREE_SEQ
, REFXP.CHILD_MODEL_EXPL_ID AS LOCAL_EXPL_NODE_ID
, REFXP.CHILD_MODEL_EXPL_ID AS LEAF_EXPL_NODE_ID
, REFXP.COMPONENT_ID AS PS_NODE_ID
, REFRT.PERSISTENT_NODE_ID
, LSLKV.VALUE_LABEL AS NAME
, LSLKV.VALUE_DESCRIPTION AS DESCRIPTION
, TO_NUMBER (NULL) AS ROOT_UI_MARKER
, TO_NUMBER(NULL) AS PAGE_SET_ID
FROM CZ_UI_REFS RFUDF
, CZ_UICOMPONENTS_LKV LSLKV
, CZ_PS_NODES REFRT
, CZ_MODEL_REF_EXPLS REFXP
WHERE LSLKV.DATA_VALUE LIKE '%LIST'
AND RFUDF.DELETED_FLAG = '0'
AND RFUDF.MODEL_REF_EXPL_ID = REFXP.MODEL_REF_EXPL_ID
AND REFXP.COMPONENT_ID = REFRT.PS_NODE_ID
AND REFRT.DELETED_FLAG = '0'
AND REFXP.DELETED_FLAG = '0'