eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_PAGE_ELEMENT_CHILDREN_CV

Source

View Text - Preformatted


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')) ) AND EXISTS(SELECT NULL FROM CZ_SIGNATURES sg WHERE sg.signature_id=pch.object_type AND sg.config_engine_type IN (NVL(prj.config_engine_type, 'L'),'B'))

View Text - HTML Formatted

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')) )
AND EXISTS(SELECT NULL
FROM CZ_SIGNATURES SG
WHERE SG.SIGNATURE_ID=PCH.OBJECT_TYPE
AND SG.CONFIG_ENGINE_TYPE IN (NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L')
, 'B'))