VIEW: APPS.CZ_PAGE_ELEMENT_CHILDREN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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