VIEW: APPS.CZ_PSNODES_FOR_UIELEMS_CV

Source

View Text - Preformatted

SELECT CZEXPLIMGV.PS_NODE_ID , CZEXPLIMGV.NAME , CZEXPLIMGV.INITIAL_VALUE , CZEXPLIMGV.PARENT_ID , CZEXPLIMGV.MINIMUM , CZEXPLIMGV.MAXIMUM , CZEXPLIMGV.FEATURE_TYPE , CZEXPLIMGV.MINIMUM_SELECTED , CZEXPLIMGV.MAXIMUM_SELECTED , CZEXPLIMGV.PSN_CREATION_DATE , CZEXPLIMGV.PSN_CREATED_BY , CZEXPLIMGV.PSN_LAST_UPDATE_DATE , CZEXPLIMGV.EFFECTIVE_USAGE_MASK , CZEXPLIMGV.EFFECTIVE_FROM , CZEXPLIMGV.EFFECTIVE_UNTIL , CZEXPLIMGV.DEVL_PROJECT_ID , CZEXPLIMGV.INTL_TEXT_ID , CZEXPLIMGV.UI_OMIT , CZEXPLIMGV.PARENT_EXPL_NODE_ID , CZEXPLIMGV.NODE_DEPTH , CZEXPLIMGV.PARENT_PSNODE_EXPL_ID , CZEXPLIMGV.FULL_IMAGE_PATH , CZEXPLIMGV.ALT_TEXT , CZEXPLIMGV.TEXT_STR , CZEXPLIMGV.CHILD_MODEL_EXPL_ID , CZEXPLIMGV.TREE_SEQ , CZEXPLIMGV.PSN_COMPONENT_ID , CZEXPLIMGV.XPL_VIRTUAL_FLAG , CZEXPLIMGV.MODEL_REF_EXPL_ID , CZEXPLIMGV.INSTANTIABLE_FLAG , CZEXPLIMGV.COUNTED_OPTIONS_FLAG , CZEXPLIMGV.PS_NODE_TYPE , CZEXPLIMGV.REFERENCE_ID , CZEXPLIMGV.EFFECTIVE_PARENT_ID , CZEXPLIMGV.MODEL_ID , CZEXPLIMGV.PERSISTENT_NODE_ID , pgesig.signature_id as p_page_element_type , ( SELECT 1 - COUNT(*) FROM DUAL WHERE EXISTS ( SELECT 1 FROM CZ_TYPE_RELATIONSHIPS CZTYPREL, cz_pdt_2_pge_rels_v czpdt2pge WHERE CZTYPREL.REL_TYPE_CODE = 'CNV' AND CZTYPREL.OBJECT_TYPE = CZ_TYPES.GET_UI_SIGNATURE_ID ( CZEXPLIMGV.PS_NODE_ID, CZEXPLIMGV.INSTANTIABLE_FLAG, CZEXPLIMGV.FEATURE_TYPE, CZEXPLIMGV.COUNTED_OPTIONS_FLAG, CZEXPLIMGV.MAXIMUM, CZEXPLIMGV.MINIMUM, CZEXPLIMGV.PS_NODE_TYPE, CZEXPLIMGV.REFERENCE_ID, CZEXPLIMGV.MAXIMUM_SELECTED ) AND CZTYPREL.DELETED_FLAG = '0' AND CZTYPREL.suBJECT_TYPE = czpdt2pge.detailed_type_id AND czpdt2pge.DELETED_FLAG = '0' and czpdt2pge.PAGE_ELEMENT_TYPE = pgesig.signature_id ) ) as node_disabled_flag, CZ_TYPES.GET_UI_SIGNATURE_ID ( CZEXPLIMGV.PS_NODE_ID, CZEXPLIMGV.INSTANTIABLE_FLAG, CZEXPLIMGV.FEATURE_TYPE, CZEXPLIMGV.COUNTED_OPTIONS_FLAG, CZEXPLIMGV.MAXIMUM, CZEXPLIMGV.MINIMUM, CZEXPLIMGV.PS_NODE_TYPE, CZEXPLIMGV.REFERENCE_ID, CZEXPLIMGV.MAXIMUM_SELECTED ) as ui_type, czexplimgv.detailed_type_id, czexplimgv.effectivity_set_id FROM CZ_EXPLNODES_WITHIMAGES_V CZEXPLIMGV, cz_signatures pgesig WHERE pgesig.deleted_flag = '0' and pgesig.signature_type = 'PGE' and czexplimgv.suppress_flag = '0'

View Text - HTML Formatted

SELECT CZEXPLIMGV.PS_NODE_ID
, CZEXPLIMGV.NAME
, CZEXPLIMGV.INITIAL_VALUE
, CZEXPLIMGV.PARENT_ID
, CZEXPLIMGV.MINIMUM
, CZEXPLIMGV.MAXIMUM
, CZEXPLIMGV.FEATURE_TYPE
, CZEXPLIMGV.MINIMUM_SELECTED
, CZEXPLIMGV.MAXIMUM_SELECTED
, CZEXPLIMGV.PSN_CREATION_DATE
, CZEXPLIMGV.PSN_CREATED_BY
, CZEXPLIMGV.PSN_LAST_UPDATE_DATE
, CZEXPLIMGV.EFFECTIVE_USAGE_MASK
, CZEXPLIMGV.EFFECTIVE_FROM
, CZEXPLIMGV.EFFECTIVE_UNTIL
, CZEXPLIMGV.DEVL_PROJECT_ID
, CZEXPLIMGV.INTL_TEXT_ID
, CZEXPLIMGV.UI_OMIT
, CZEXPLIMGV.PARENT_EXPL_NODE_ID
, CZEXPLIMGV.NODE_DEPTH
, CZEXPLIMGV.PARENT_PSNODE_EXPL_ID
, CZEXPLIMGV.FULL_IMAGE_PATH
, CZEXPLIMGV.ALT_TEXT
, CZEXPLIMGV.TEXT_STR
, CZEXPLIMGV.CHILD_MODEL_EXPL_ID
, CZEXPLIMGV.TREE_SEQ
, CZEXPLIMGV.PSN_COMPONENT_ID
, CZEXPLIMGV.XPL_VIRTUAL_FLAG
, CZEXPLIMGV.MODEL_REF_EXPL_ID
, CZEXPLIMGV.INSTANTIABLE_FLAG
, CZEXPLIMGV.COUNTED_OPTIONS_FLAG
, CZEXPLIMGV.PS_NODE_TYPE
, CZEXPLIMGV.REFERENCE_ID
, CZEXPLIMGV.EFFECTIVE_PARENT_ID
, CZEXPLIMGV.MODEL_ID
, CZEXPLIMGV.PERSISTENT_NODE_ID
, PGESIG.SIGNATURE_ID AS P_PAGE_ELEMENT_TYPE
, ( SELECT 1 - COUNT(*)
FROM DUAL
WHERE EXISTS ( SELECT 1
FROM CZ_TYPE_RELATIONSHIPS CZTYPREL
, CZ_PDT_2_PGE_RELS_V CZPDT2PGE
WHERE CZTYPREL.REL_TYPE_CODE = 'CNV'
AND CZTYPREL.OBJECT_TYPE = CZ_TYPES.GET_UI_SIGNATURE_ID ( CZEXPLIMGV.PS_NODE_ID
, CZEXPLIMGV.INSTANTIABLE_FLAG
, CZEXPLIMGV.FEATURE_TYPE
, CZEXPLIMGV.COUNTED_OPTIONS_FLAG
, CZEXPLIMGV.MAXIMUM
, CZEXPLIMGV.MINIMUM
, CZEXPLIMGV.PS_NODE_TYPE
, CZEXPLIMGV.REFERENCE_ID
, CZEXPLIMGV.MAXIMUM_SELECTED )
AND CZTYPREL.DELETED_FLAG = '0'
AND CZTYPREL.SUBJECT_TYPE = CZPDT2PGE.DETAILED_TYPE_ID
AND CZPDT2PGE.DELETED_FLAG = '0'
AND CZPDT2PGE.PAGE_ELEMENT_TYPE = PGESIG.SIGNATURE_ID ) ) AS NODE_DISABLED_FLAG
, CZ_TYPES.GET_UI_SIGNATURE_ID ( CZEXPLIMGV.PS_NODE_ID
, CZEXPLIMGV.INSTANTIABLE_FLAG
, CZEXPLIMGV.FEATURE_TYPE
, CZEXPLIMGV.COUNTED_OPTIONS_FLAG
, CZEXPLIMGV.MAXIMUM
, CZEXPLIMGV.MINIMUM
, CZEXPLIMGV.PS_NODE_TYPE
, CZEXPLIMGV.REFERENCE_ID
, CZEXPLIMGV.MAXIMUM_SELECTED ) AS UI_TYPE
, CZEXPLIMGV.DETAILED_TYPE_ID
, CZEXPLIMGV.EFFECTIVITY_SET_ID
FROM CZ_EXPLNODES_WITHIMAGES_V CZEXPLIMGV
, CZ_SIGNATURES PGESIG
WHERE PGESIG.DELETED_FLAG = '0'
AND PGESIG.SIGNATURE_TYPE = 'PGE'
AND CZEXPLIMGV.SUPPRESS_FLAG = '0'