VIEW: APPS.CZ_PSNODE_WITH_UIREFS_V

Source

View Text - Preformatted

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 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, udf.devl_project_id as model_id, udf.name as ui_def_name, udf.UI_STYLE from cz_ui_pages pag, cz_ui_defs udf where pag.deleted_flag = '0' and pag.ui_def_id = udf.ui_def_id and udf.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, udf.devl_project_id as model_id, udf.name as ui_def_name, udf.UI_STYLE from cz_ui_page_elements pge, cz_ui_defs udf where pge.deleted_flag = '0' and pge.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

View Text - HTML Formatted

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 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
, UDF.DEVL_PROJECT_ID AS MODEL_ID
, UDF.NAME AS UI_DEF_NAME
, UDF.UI_STYLE
FROM CZ_UI_PAGES PAG
, CZ_UI_DEFS UDF
WHERE PAG.DELETED_FLAG = '0'
AND PAG.UI_DEF_ID = UDF.UI_DEF_ID
AND UDF.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
, UDF.DEVL_PROJECT_ID AS MODEL_ID
, UDF.NAME AS UI_DEF_NAME
, UDF.UI_STYLE
FROM CZ_UI_PAGE_ELEMENTS PGE
, CZ_UI_DEFS UDF
WHERE PGE.DELETED_FLAG = '0'
AND PGE.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