View: CZ_UI_COMPONENTS_V

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

View Text

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'

Columns