View: CZ_EXPLNODES_WITHIMAGES_V

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

View Text

SELECT XPND.SUPPRESS_FLAG
, XPND.STRUCTURAL_PARENT_ID
, XPND.EFFECTIVE_PARENT_ID
, XPND.PARENT_PSNODE_EXPL_ID
, XPND.PS_NODE_ID
, XPND.DEVL_PROJECT_ID
, XPND.INTL_TEXT_ID
, XPND.NAME
, XPND.RESOURCE_FLAG
, XPND.INITIAL_VALUE
, XPND.PARENT_ID
, XPND.MINIMUM
, XPND.MAXIMUM
, XPND.FEATURE_TYPE
, XPND.REFERENCE_ID
, XPND.MULTI_CONFIG_FLAG
, XPND.ORDER_SEQ_FLAG
, XPND.TREE_SEQ
, XPND.COUNTED_OPTIONS_FLAG
, XPND.UI_OMIT
, XPND.UI_SECTION
, XPND.BOM_TREATMENT
, XPND.COMPONENT_SEQUENCE_ID
, XPND.BOM_REQUIRED_FLAG
, XPND.SO_ITEM_TYPE_CODE
, XPND.MINIMUM_SELECTED
, XPND.MAXIMUM_SELECTED
, XPND.EFFECTIVE_USAGE_MASK
, XPND.EFFECTIVE_FROM
, XPND.EFFECTIVE_UNTIL
, XPND.DECIMAL_QTY_FLAG
, XPND.PERSISTENT_NODE_ID
, XPND.COMPONENT_SEQUENCE_PATH
, XPND.VIOLATION_TEXT_ID
, XPND.EFFECTIVITY_SET_ID
, XPND.QUOTEABLE_FLAG
, XPND.PRIMARY_UOM_CODE
, XPND.BOM_SORT_ORDER
, XPND.IB_TRACKABLE
, XPND.ACCUMULATOR_FLAG
, XPND.NOTES_TEXT_ID
, XPND.INSTANTIABLE_FLAG
, XPND.FROM_POPULATOR_ID
, XPND.PROPERTY_BACKPTR
, XPND.ITEM_TYPE_BACKPTR
, XPND.ITEM_ID
, XPND.ORIG_SYS_REF
, XPND.CHECKOUT_USER
, XPND.USER_NUM01
, XPND.USER_NUM02
, XPND.USER_NUM03
, XPND.USER_NUM04
, XPND.USER_STR01
, XPND.USER_STR02
, XPND.USER_STR03
, XPND.USER_STR04
, XPND.MODEL_REF_EXPL_ID
, XPND.PARENT_EXPL_NODE_ID
, XPND.MODEL_ID
, XPND.NODE_DEPTH
, XPND.REFERRING_NODE_ID
, XPND.CHILD_MODEL_EXPL_ID
, XPND.EXPL_NODE_TYPE
, XPND.HAS_TRACKABLE_CHILDREN
, XPND.PSN_COMPONENT_ID
, XPND.XPL_COMPONENT_ID
, XPND.PSN_VIRTUAL_FLAG
, XPND.XPL_VIRTUAL_FLAG
, XPND.PSN_PS_NODE_TYPE AS PS_NODE_TYPE
, NIMG.IMAGE_USAGE_CODE
, NIMG.REFERENCED_USAGE_FLAG
, NIMG.PSNODETYPE_ID
, NIMG.PSNODETYPE_NAME
, NIMG.IMAGE_FILE
, NIMG.ALT_TEXT
, NIMG.SUB_NODETYPE_ID AS DETAILED_TYPE_ID
, NIMG.UI_DEF_ID
, NIMG.FULL_IMAGE_PATH
, XPND.PSN_CREATION_DATE
, XPND.PSN_CREATED_BY
, XPND.PSN_LAST_UPDATE_DATE
, XPND.PSN_LAST_UPDATED_BY
, XPND.INITIAL_NUM_VALUE
, LTX.TEXT_STR
, LTX.LANGUAGE
, XPND.ORGANIZATION_ID
, XPND.TOP_ITEM_ID
, XPND.INVENTORY_ITEM_ID
, NIMG.ATTACH_NODETYPE_ALT_TEXT
, CZ_DEVELOPER_UTILS_PVT.GET_FULL_LABEL_PATH(PS_NODE_ID
, MODEL_REF_EXPL_ID
, XPND.MODEL_ID) AS USER_PREF_NODE_PATH
, CZ_DEVELOPER_UTILS_PVT.GET_NODE_LABEL(XPND.PSN_PS_NODE_TYPE
, NAME
, TEXT_STR) AS USER_PREF_NODE_LABEL
, CZ_DEVELOPER_UTILS_PVT.GET_FULL_MODEL_PATH(PS_NODE_ID
, MODEL_REF_EXPL_ID
, XPND.MODEL_ID) AS NAME_ONLY_NODE_PATH
, NVL( (SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM CZ_PS_NODES REF
WHERE DELETED_FLAG = '0'
AND PARENT_ID = XPND.PS_NODE_ID
AND (PS_NODE_TYPE NOT IN (263
, 264
, 436
, 437
, 438) OR (PS_NODE_TYPE IN (263
, 264)
AND (SELECT PS_NODE_TYPE
FROM CZ_PS_NODES
WHERE DELETED_FLAG = '0'
AND PS_NODE_ID = REF.REFERENCE_ID) <> 436))) )
, 'N') AS DISPLAY_REORDER_CHILD_IMG
FROM CZ_EXPLMODEL_NODES_V XPND
, CZ_PSNODETYPE_IMAGES_V NIMG
, CZ_LOCALIZED_TEXTS_VL LTX
WHERE LTX.INTL_TEXT_ID (+) = XPND.INTL_TEXT_ID
AND NIMG.REFERENCED_USAGE_FLAG(+) = DECODE (XPND.MODEL_ID
, XPND.DEVL_PROJECT_ID
, DECODE (XPND.PSN_PS_NODE_TYPE
, 263
, '1'
, '0')
, '1')
AND NIMG.SUB_NODETYPE_ID(+) = CZ_TYPES.GET_RULE_SIGNATURE_ID ( XPND.INSTANTIABLE_FLAG
, XPND.FEATURE_TYPE
, XPND.COUNTED_OPTIONS_FLAG
, XPND.MAXIMUM
, XPND.MINIMUM
, XPND.PSN_PS_NODE_TYPE
, XPND.REFERENCE_ID
, XPND.MAXIMUM_SELECTED
, XPND.DECIMAL_QTY_FLAG
, XPND.IB_TRACKABLE
, XPND.DEVL_PROJECT_ID )

Columns