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.

[Home] [Help]

View: CZ_PSNODES_FOR_UIELEMS_CV

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

View Text

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'

Columns

Name
PS_NODE_ID
NAME
INITIAL_VALUE
PARENT_ID
MINIMUM
MAXIMUM
FEATURE_TYPE
MINIMUM_SELECTED
MAXIMUM_SELECTED
PSN_CREATION_DATE
PSN_CREATED_BY
PSN_LAST_UPDATE_DATE
EFFECTIVE_USAGE_MASK
EFFECTIVE_FROM
EFFECTIVE_UNTIL
DEVL_PROJECT_ID
INTL_TEXT_ID
UI_OMIT
PARENT_EXPL_NODE_ID
NODE_DEPTH
PARENT_PSNODE_EXPL_ID
FULL_IMAGE_PATH
ALT_TEXT
TEXT_STR
CHILD_MODEL_EXPL_ID
TREE_SEQ
PSN_COMPONENT_ID
XPL_VIRTUAL_FLAG
MODEL_REF_EXPL_ID
INSTANTIABLE_FLAG
COUNTED_OPTIONS_FLAG
PS_NODE_TYPE
REFERENCE_ID
EFFECTIVE_PARENT_ID
MODEL_ID
PERSISTENT_NODE_ID
P_PAGE_ELEMENT_TYPE
NODE_DISABLED_FLAG
UI_TYPE
DETAILED_TYPE_ID
EFFECTIVITY_SET_ID