View: CZ_PAGE_ELEMENT_CHILDREN_CV

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

View Text

SELECT OUTPGE.SIGNATURE_ID AS P_PARENT_PGELEMENT_TYPE_ID
, OUTPGE.NAME AS PARENT_PGELEMENT_NAME
, UICONT.VALUE_SEQ AS CONTENT_CATEGORY_SEQ
, UICONT.VALUE_LABEL AS CONTENT_CATEGORY_LABEL
, NVL (TPL.MESSAGE_TYPE
, UICONT.NUMERIC_ID_VALUE) AS REQUIRED_BINDING_TYPE_ID
, DECODE (PCH.OBJECT_TYPE
, NULL
, '0'
, '1' ) AS CAT_CHILD_ELS_AVAIL_FLAG
, PCH.OBJECT_TYPE AS CHILD_PGELEMENT_TYPE_ID
, ELSBYCAT.VALUE_SEQ AS CHILD_PGELEMENT_TYPE_SEQ
, ELSBYCAT.VALUE_LABEL AS CONTENT_CATEGORY_LABEL
, TPL.ROOT_REGION_TYPE AS CHILD_PGELEMENT_JRAD_TAG
, TPL.JRAD_DOC AS CHILD_PGELEMENT_ATTR_SET
, CONTEXTTYPE.SIGNATURE_ID AS P_CONTEXT_TYPE_ID
, CONTAINERTYPE.SIGNATURE_ID AS P_CONTAINER_TYPE_ID
, UIDEF.UI_DEF_ID AS P_UI_DEF_ID
FROM CZ_LOOKUP_VALUES_VL UICONT
, CZ_SIGNATURES OUTPGE
, CZ_PARENT_CHILD_RELS_V PCH
, CZ_LOOKUP_VALUES_VL ELSBYCAT
, CZ_UI_TEMPLATES TPL
, CZ_SIGNATURES CONTEXTTYPE
, CZ_TYPE_RELATIONSHIPS UTERELS
, CZ_PARENT_CHILD_RELS_V PCH2
, CZ_SIGNATURES CONTAINERTYPE
, CZ_UI_DEFS UIDEF
WHERE UICONT.LIST_NAME = 'CREATE_UI_CONTENT'
AND OUTPGE.DELETED_FLAG = '0'
AND OUTPGE.SIGNATURE_TYPE = 'PGE'
AND PCH.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND TPL.UI_DEF_ID(+) = '0'
AND TPL.DELETED_FLAG(+) = '0'
AND TPL.TEMPLATE_TYPE(+) = PCH.OBJECT_TYPE
AND ELSBYCAT.LIST_NAME(+) = UICONT.DATA_VALUE
AND PCH.SUBJECT_TYPE(+) = OUTPGE.SIGNATURE_ID
AND CONTEXTTYPE.SEEDED_FLAG = '1'
AND CONTEXTTYPE.DELETED_FLAG = '0'
AND UTERELS.REL_TYPE_CODE = 'UTE'
AND UTERELS.DELETED_FLAG = '0'
AND UTERELS.SEEDED_FLAG = '1'
AND UTERELS.SUBJECT_TYPE = CONTEXTTYPE.SIGNATURE_ID
AND UTERELS.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND CONTAINERTYPE.DELETED_FLAG = '0'
AND CONTAINERTYPE.SEEDED_FLAG = '1'
AND CONTAINERTYPE.SIGNATURE_TYPE = 'PGE'
AND PCH2.SUBJECT_TYPE = CONTAINERTYPE.SIGNATURE_ID
AND PCH2.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND UIDEF.UI_DEF_ID=0 UNION ALL SELECT OUTPGE.SIGNATURE_ID AS P_PARENT_PGELEMENT_TYPE_ID
, OUTPGE.NAME AS PARENT_PGELEMENT_NAME
, UICONT.VALUE_SEQ AS CONTENT_CATEGORY_SEQ
, UICONT.VALUE_LABEL AS CONTENT_CATEGORY_LABEL
, NVL(TPL.MESSAGE_TYPE
, UICONT.NUMERIC_ID_VALUE) AS REQUIRED_BINDING_TYPE_ID
, DECODE(PCH.OBJECT_TYPE
, NULL
, '0'
, '1') AS CAT_CHILD_ELS_AVAIL_FLAG
, PCH.OBJECT_TYPE AS CHILD_PGELEMENT_TYPE_ID
, ELSBYCAT.VALUE_SEQ AS CHILD_PGELEMENT_TYPE_SEQ
, ELSBYCAT.VALUE_LABEL AS CONTENT_CATEGORY_LABEL
, TPL.ROOT_REGION_TYPE AS CHILD_PGELEMENT_JRAD_TAG
, TPL.JRAD_DOC AS CHILD_PGELEMENT_ATTR_SET
, CONTEXTTYPE.SIGNATURE_ID AS P_CONTEXT_TYPE_ID
, CONTAINERTYPE.SIGNATURE_ID AS P_CONTAINER_TYPE_ID
, UIDEF.UI_DEF_ID AS P_UI_DEF_ID
FROM CZ_LOOKUP_VALUES_VL UICONT
, CZ_SIGNATURES OUTPGE
, CZ_PARENT_CHILD_RELS_V PCH
, CZ_LOOKUP_VALUES_VL ELSBYCAT
, CZ_UI_TEMPLATES TPL
, CZ_SIGNATURES CONTEXTTYPE
, CZ_TYPE_RELATIONSHIPS UTERELS
, CZ_PARENT_CHILD_RELS_V PCH2
, CZ_SIGNATURES CONTAINERTYPE
, CZ_UI_DEFS UIDEF
, CZ_DEVL_PROJECTS PRJ
WHERE UICONT.LIST_NAME = 'CREATE_UI_CONTENT'
AND OUTPGE.DELETED_FLAG = '0'
AND OUTPGE.SIGNATURE_TYPE = 'PGE'
AND PCH.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND TPL.UI_DEF_ID(+) = '0'
AND TPL.DELETED_FLAG(+) = '0'
AND TPL.TEMPLATE_TYPE(+) = PCH.OBJECT_TYPE
AND ELSBYCAT.LIST_NAME(+) = UICONT.DATA_VALUE
AND PCH.SUBJECT_TYPE(+) = OUTPGE.SIGNATURE_ID
AND CONTEXTTYPE.SEEDED_FLAG = '1'
AND CONTEXTTYPE.DELETED_FLAG = '0'
AND UTERELS.REL_TYPE_CODE = 'UTE'
AND UTERELS.DELETED_FLAG = '0'
AND UTERELS.SEEDED_FLAG = '1'
AND UTERELS.SUBJECT_TYPE = CONTEXTTYPE.SIGNATURE_ID
AND UTERELS.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND CONTAINERTYPE.DELETED_FLAG = '0'
AND CONTAINERTYPE.SEEDED_FLAG = '1'
AND CONTAINERTYPE.SIGNATURE_TYPE = 'PGE'
AND PCH2.SUBJECT_TYPE = CONTAINERTYPE.SIGNATURE_ID
AND PCH2.OBJECT_TYPE = ELSBYCAT.NUMERIC_ID_VALUE
AND UIDEF.UI_DEF_ID>0
AND UIDEF.DEVL_PROJECT_ID=PRJ.DEVL_PROJECT_ID
AND ( (NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')
AND NVL(CONTAINERTYPE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')
AND NVL(CONTEXTTYPE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')
AND NVL(OUTPGE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')) OR (NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')
AND NVL(CONTAINERTYPE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')
AND NVL(CONTEXTTYPE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')
AND NVL(OUTPGE.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')) )

Columns