View: CZ_PSNODE_WITH_UIREFS_V

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

View Text

SELECT PSN.DEVL_PROJECT_ID AS MODEL_ID
, PSN.PS_NODE_ID
, PSN.PARENT_ID
, PSN.PERSISTENT_NODE_ID
, PSN.PS_NODE_TYPE
, PSN.NAME
, UIREF2ND.UI_DEF_ID
, UIREF2ND.PAGE_ID
, UIREF2ND.ELEMENT_ID
, UIREF2ND.PARENT_ELEMENT_ID
, UIREF2ND.PAGE_STRUCTURE_NAME
, UIREF2ND.STRUCT_SIGNATURE_ID
, UIREF2ND.ELEMENT_TYPE
, UIREF2ND.UI_STRUCT_CODE
, UIREF2ND.UI_DEF_NAME
, UIREF2ND.UI_STYLE
FROM ( SELECT UISTRUCT.UI_DEF_ID
, UISTRUCT.PAGE_ID
, UISTRUCT.ELEMENT_ID
, UISTRUCT.PARENT_ELEMENT_ID
, UISTRUCT.PERSISTENT_NODE_ID
, UISTRUCT.PAGE_STRUCTURE_NAME
, UISTRUCT.STRUCT_SIGNATURE_ID
, UISTRUCT.ELEMENT_TYPE
, UISTRUCT.UI_STRUCT_CODE
, UDF.DEVL_PROJECT_ID AS MODEL_ID
, UDF.NAME AS UI_DEF_NAME
, UDF.UI_STYLE
FROM ( SELECT PAG.UI_DEF_ID
, PAG.PAGE_ID
, TO_CHAR (NULL) AS ELEMENT_ID
, TO_CHAR (NULL) AS PARENT_ELEMENT_ID
, PAG.PERSISTENT_NODE_ID
, PAG.NAME AS PAGE_STRUCTURE_NAME
, 6044 AS STRUCT_SIGNATURE_ID
, 6044 AS ELEMENT_TYPE
, 'PAG' AS UI_STRUCT_CODE
FROM CZ_UI_PAGES PAG
WHERE PAG.DELETED_FLAG = '0' UNION ALL SELECT PGE.UI_DEF_ID
, PGE.PAGE_ID
, PGE.ELEMENT_ID
, PGE.PARENT_ELEMENT_ID
, PGE.PERSISTENT_NODE_ID
, PGE.NAME AS PAGE_STRUCTURE_NAME
, PGE.ELEMENT_SIGNATURE_ID AS STRUCT_SIGNATURE_ID
, PGE.ELEMENT_TYPE
, 'PGE' AS UI_STRUCT_CODE
FROM CZ_UI_PAGE_ELEMENTS PGE
WHERE PGE.DELETED_FLAG = '0' ) UISTRUCT
, CZ_UI_DEFS UDF
WHERE UISTRUCT.UI_DEF_ID = UDF.UI_DEF_ID
AND UDF.DELETED_FLAG = '0' ) UIREF2ND
, CZ_PS_NODES PSN
WHERE PSN.DELETED_FLAG = '0'
AND PSN.PERSISTENT_NODE_ID = UIREF2ND.PERSISTENT_NODE_ID
AND PSN.DEVL_PROJECT_ID = UIREF2ND.MODEL_ID

Columns