View: CZ_PAGE_ELEMENT_CHILDREN_V

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

View Text

SELECT ENCLCAT.PARENT_PGELEMENT_TYPE_ID
, ENCLCAT.PARENT_PGELEMENT_NAME
, ENCLCAT.CONTENT_CATEGORY_SEQ
, ENCLCAT.CONTENT_CATEGORY_LABEL
, NVL (TPL.MESSAGE_TYPE
, ENCLCAT.REQUIRED_BINDING_TYPE_ID) AS REQUIRED_BINDING_TYPE_ID
, DECODE (CHLCAT.CHILD_PGELEMENT_TYPE_ID
, NULL
, '0'
, '1' ) AS CAT_CHILD_ELS_AVAIL_FLAG
, CHLCAT.CHILD_PGELEMENT_TYPE_ID
, CHLCAT.CHILD_PGELEMENT_TYPE_SEQ
, CHLCAT.CHILD_PGELEMENT_TYPE_LABEL
, TPL.ROOT_REGION_TYPE AS CHILD_PGELEMENT_JRAD_TAG
, TPL.JRAD_DOC AS CHILD_PGELEMENT_ATTR_SET
FROM ( SELECT OUTPGE.SIGNATURE_ID AS PARENT_PGELEMENT_TYPE_ID
, OUTPGE.NAME AS PARENT_PGELEMENT_NAME
, UICONT.VALUE_SEQ AS CONTENT_CATEGORY_SEQ
, UICONT.DATA_VALUE AS UICONT_DATA_VALUE
, UICONT.VALUE_LABEL AS CONTENT_CATEGORY_LABEL
, UICONT.CONTENT_BIND_SIGNATURE AS REQUIRED_BINDING_TYPE_ID
FROM CZ_CREATEUICONTENT_LKV UICONT
, CZ_SIGNATURES OUTPGE
WHERE OUTPGE.DELETED_FLAG = '0'
AND OUTPGE.SIGNATURE_TYPE = 'PGE' ) ENCLCAT
, ( SELECT PCH.SUBJECT_TYPE AS PCH_SUBJECT_TYPE
, PCH.OBJECT_TYPE AS CHILD_PGELEMENT_TYPE_ID
, ELSBYCAT.LIST_NAME AS ELSBYCAT_LIST_NAME
, ELSBYCAT.VALUE_SEQ AS CHILD_PGELEMENT_TYPE_SEQ
, ELSBYCAT.DATA_VALUE AS ELSBYCAT_DATA_VALUE
, ELSBYCAT.VALUE_LABEL AS CHILD_PGELEMENT_TYPE_LABEL
FROM CZ_PARENT_CHILD_RELS_V PCH
, CZ_LOOKUP_VALUES_VL ELSBYCAT
WHERE PCH.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE ) CHLCAT
, CZ_UI_TEMPLATES TPL
WHERE TPL.UI_DEF_ID (+) = '0'
AND TPL.DELETED_FLAG (+) = '0'
AND TPL.TEMPLATE_TYPE (+) = CHLCAT.CHILD_PGELEMENT_TYPE_ID
AND CHLCAT.ELSBYCAT_LIST_NAME (+) = ENCLCAT.UICONT_DATA_VALUE
AND CHLCAT.PCH_SUBJECT_TYPE (+) = ENCLCAT.PARENT_PGELEMENT_TYPE_ID

Columns