VIEW: APPS.CZ_EXPLNODES_WITHIMAGES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )