View: CZ_UIPAGES_FOR_EXPLNODES_V

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

View Text

SELECT PGLIST.ELEMENT_ID AS ELEMENT_ID
, ROOTUI.UI_DEF_ID AS ROOT_UI_DEF_ID
, ROOTUI.NAME AS ROOT_UI_NAME
, GETCHX.ROOT_MODEL_ID
, GETCHX.ROOT_MODEL_EXPL_ID AS ROOT_MODEL_EXPL_ID
, REQND.PERSISTENT_NODE_ID AS ROOT_MODEL_NODE_ID
, REQND.PS_NODE_ID AS PS_NODE_ID_PER_ROOT_MDL
, DECODE (REQND.INSTANTIABLE_FLAG
, 4
, ( SELECT DECODE (COUNT (*)
, 0
, '1'
, '0') FROM CZ_MODEL_REF_EXPLS COLLCHK WHERE COLLCHK.MODEL_REF_EXPL_ID = GETCHX.DESC_EXPL_NODE_ID START WITH COLLCHK.MODEL_REF_EXPL_ID = PGLIST.LOCAL_PGBASE_EXPL_NODE_ID CONNECT BY COLLCHK.MODEL_REF_EXPL_ID = PRIOR COLLCHK.PARENT_EXPL_NODE_ID
AND COLLCHK.DELETED_FLAG = '0' )
, '0' ) AS NODE_COLLECTION_FLAG
, PGLIST.LOCAL_UI_DEF_ID AS TARGET_UI_DEF_ID
, PAGEUI.NAME AS TARGET_UI_NAME
, PGLIST.LOCAL_PAGE_ID AS TARGET_PAGE_ID
, PGLIST.LOCAL_PGBASE_PERS_NODE_ID AS TARGET_PAGE_PERS_NODE_ID
, ( TO_CHAR (RTROOTND.PERSISTENT_NODE_ID) || DECODE (PGBASE.DEVL_PROJECT_ID
, GETCHX.ROOT_MODEL_ID
, ''
, '.' || CZ_DEVELOPER_UTILS_PVT.ANNOTATED_NODE_PATH ( GETCHX.ROOT_MODEL_ID
, RTPGUIXPL.MODEL_REF_EXPL_ID
, NVL (RTPGUIXPL.REFERRING_NODE_ID
, RTPGUIXPL.COMPONENT_ID) ) ) || DECODE (PGBASE.PS_NODE_ID
, GETCHX.ROOT_MODEL_ID
, ''
, PGBASE.DEVL_PROJECT_ID
, ''
, '.' || CZ_DEVELOPER_UTILS_PVT.ANNOTATED_NODE_PATH ( PAGEUI.DEVL_PROJECT_ID
, PGLIST.LOCAL_PGBASE_EXPL_NODE_ID
, PGBASE.PS_NODE_ID) ) ) AS TARGET_PAGE_ANN_PATH
, PGLIST.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID
, PGLIST.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP
, PGLIST.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE
, PGLIST.ELEMENT_BINDING_FLAG AS ELEMENT_BINDING_FLAG
, DECODE (REQND.PS_NODE_ID
, BINDND.PS_NODE_ID
, '0'
, '1') AS BOUND_VIA_PARENT_FLAG
, 0 AS PAGE_INCLUSION_DEPTH
, GETCHX.REF_DEPTH AS TARGET_PAGE_REFERENCE_DEPTH
, GETCHX.ROOT_MODEL_EXPL_NODE_DEPTH AS TARGET_PAGE_EXPL_NODE_DEPTH
, '2005-08-10 11:59' AS VIEW_REVISION
FROM CZ_PS_NODES PGBASE
, CZ_PS_NODES REQND
, CZ_PS_NODES BINDND
, CZ_UI_DEFS ROOTUI
, CZ_PS_NODES RTROOTND
, CZ_MODEL_REF_EXPLS RTPGUIXPL
, CZ_MODEL_REF_EXPLS PGUITOPXPL
, CZ_UI_DEFS PAGEUI
, ( SELECT PGE.ELEMENT_ID
, PGE.ELEMENT_SIGNATURE_ID
, PGE.CTRL_TEMPLATE_ID
, PGE.ELEMENT_TYPE
, PGE.UI_DEF_ID AS LOCAL_UI_DEF_ID
, PGE.PAGE_ID AS LOCAL_PAGE_ID
, PGE.MODEL_REF_EXPL_ID AS LOCAL_PGELEMENT_EXPL_ID
, PGE.PERSISTENT_NODE_ID AS LOCAL_PGELEMENT_PERS_NODE_ID
, ELEPG.PERSISTENT_NODE_ID AS LOCAL_PGBASE_PERS_NODE_ID
, ELEPG.PAGEBASE_EXPL_NODE_ID AS LOCAL_PGBASE_EXPL_NODE_ID
, ELEPG.DISPLAY_CONDITION_ID
, ELEPG.DISPLAY_CONDITION_COMP
, ELEPG.DISPLAY_CONDITION_VALUE
, DECODE (NVL(PGE.PARENT_ELEMENT_ID
, 0)
, 0
, '0'
, '1') AS ELEMENT_BINDING_FLAG FROM CZ_UI_PAGE_ELEMENTS PGE
, CZ_UI_PAGES ELEPG WHERE PGE.DELETED_FLAG = '0'
AND PGE.UI_DEF_ID = ELEPG.UI_DEF_ID
AND PGE.PAGE_ID = ELEPG.PAGE_ID
AND ELEPG.DELETED_FLAG = '0' ) PGLIST
, ( SELECT ROOTX.MODEL_ID AS ROOT_MODEL_ID
, ROOTX.MODEL_REF_EXPL_ID AS ROOT_MODEL_EXPL_ID
, ROOTX.NODE_DEPTH AS ROOT_MODEL_EXPL_NODE_DEPTH
, 0 AS REF_DEPTH
, CHLXP.MODEL_REF_EXPL_ID AS DESC_EXPL_NODE_ID
, CHLXP.MODEL_ID AS DESC_MODEL_ID
, CHLXP.COMPONENT_ID
, CHLXP.REFERRING_NODE_ID FROM CZ_MODEL_REF_EXPLS CHLXP
, CZ_MODEL_REF_EXPLS ROOTX WHERE CHLXP.DELETED_FLAG = '0'
AND ROOTX.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1 FROM CZ_MODEL_REF_EXPLS FINDCH WHERE FINDCH.MODEL_REF_EXPL_ID = CHLXP.MODEL_REF_EXPL_ID START WITH FINDCH.MODEL_REF_EXPL_ID = ROOTX.MODEL_REF_EXPL_ID CONNECT BY FINDCH.MODEL_REF_EXPL_ID = PRIOR FINDCH.CHILD_MODEL_EXPL_ID
AND FINDCH.DELETED_FLAG = '0' ) ) GETCHX
WHERE RTROOTND.PS_NODE_ID = GETCHX.ROOT_MODEL_ID
AND PGBASE.PERSISTENT_NODE_ID = PGLIST.LOCAL_PGBASE_PERS_NODE_ID
AND PGBASE.DEVL_PROJECT_ID = PAGEUI.DEVL_PROJECT_ID
AND PGBASE.DELETED_FLAG = '0'
AND ( BINDND.PS_NODE_ID = REQND.PS_NODE_ID OR BINDND.PS_NODE_ID = DECODE (REQND.PS_NODE_TYPE
, 262
, REQND.PARENT_ID
, 263
, REQND.REFERENCE_ID
, 438
, REQND.PARENT_ID
, NULL) )
AND PAGEUI.DELETED_FLAG = '0'
AND PAGEUI.UI_DEF_ID = PGLIST.LOCAL_UI_DEF_ID
AND RTPGUIXPL.DELETED_FLAG = '0'
AND RTPGUIXPL.MODEL_ID = GETCHX.ROOT_MODEL_ID
AND RTPGUIXPL.COMPONENT_ID = PAGEUI.DEVL_PROJECT_ID
AND PGUITOPXPL.MODEL_ID = PAGEUI.DEVL_PROJECT_ID
AND PGUITOPXPL.PARENT_EXPL_NODE_ID IS NULL
AND PGUITOPXPL.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1 FROM CZ_MODEL_REF_EXPLS REQ2ROOT WHERE REQ2ROOT.MODEL_REF_EXPL_ID = RTPGUIXPL.MODEL_REF_EXPL_ID
AND REQ2ROOT.DELETED_FLAG = '0' START WITH REQ2ROOT.MODEL_REF_EXPL_ID = GETCHX.ROOT_MODEL_EXPL_ID CONNECT BY REQ2ROOT.MODEL_REF_EXPL_ID = PRIOR REQ2ROOT.PARENT_EXPL_NODE_ID
AND REQ2ROOT.DELETED_FLAG = '0' )
AND GETCHX.COMPONENT_ID = BINDND.COMPONENT_ID
AND ( BINDND.REFERENCE_ID IS NULL OR BINDND.PS_NODE_ID = GETCHX.REFERRING_NODE_ID )
AND BINDND.PERSISTENT_NODE_ID = PGLIST.LOCAL_PGELEMENT_PERS_NODE_ID
AND GETCHX.DESC_EXPL_NODE_ID = PGLIST.LOCAL_PGELEMENT_EXPL_ID
AND ROOTUI.DEVL_PROJECT_ID = GETCHX.ROOT_MODEL_ID
AND EXISTS ( SELECT 1 FROM CZ_UIS_FOR_EXPLNODES_V XUILIST WHERE XUILIST.ROOT_UI_DEF_ID = ROOTUI.UI_DEF_ID
AND XUILIST.MODEL_REF_EXPL_ID = GETCHX.ROOT_MODEL_EXPL_ID
AND XUILIST.ENCL_UI_DEF_ID = PGLIST.LOCAL_UI_DEF_ID )
AND NOT(PGLIST.ELEMENT_SIGNATURE_ID IS NULL
AND PGLIST.CTRL_TEMPLATE_ID IS NULL
AND PGLIST.ELEMENT_TYPE=522)

Columns