VIEW: APPS.CZ_PSNODE_DIRECTPROP_INFO_V

Source

View Text - Preformatted

SELECT PS_NODE_ID, PS_NODE_NAME, PROPERTY_ID, PROPERTY_NAME, DATA_TYPE, PROPERTY_VALUE, PROPERTY_NUM_VALUE, ITEM_ID, ITEM_TYPE_ID, DEFAULT_VALUE, DEF_NUM_VALUE, PROP_ATTACHES, ORIG_SYS_REF, VALUE_ORIG_SYS_REF, PROPERTY_ORIG_SYS_REF, (SELECT TEXT_STR FROM cz_intl_texts WHERE deleted_flag = '0' AND cz_psnode_propval_v.DATA_TYPE = 8 AND intl_text_id=cz_psnode_propval_v.PROPERTY_NUM_VALUE) AS TRANSLATED_TEXT, (SELECT TEXT_STR FROM cz_intl_texts WHERE deleted_flag = '0' AND cz_psnode_propval_v.DATA_TYPE = 8 AND intl_text_id=cz_psnode_propval_v.DEF_NUM_VALUE) AS DEF_TRANSLATED_TEXT, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION as alt_text , cz_psnode_propval_v.ps_node_type as ps_node_type, cz_psnode_propval_v.inherited_flag, cz_psnode_propval_v.SRC_APPLICATION_ID FROM cz_psnode_propval_v, CZ_UI_PATHED_IMAGES_V, CZ_RPOBJECTTYPES_LKV WHERE CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'PRP' AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1' AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID=0 AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30

View Text - HTML Formatted

SELECT PS_NODE_ID
, PS_NODE_NAME
, PROPERTY_ID
, PROPERTY_NAME
, DATA_TYPE
, PROPERTY_VALUE
, PROPERTY_NUM_VALUE
, ITEM_ID
, ITEM_TYPE_ID
, DEFAULT_VALUE
, DEF_NUM_VALUE
, PROP_ATTACHES
, ORIG_SYS_REF
, VALUE_ORIG_SYS_REF
, PROPERTY_ORIG_SYS_REF
, (SELECT TEXT_STR
FROM CZ_INTL_TEXTS
WHERE DELETED_FLAG = '0'
AND CZ_PSNODE_PROPVAL_V.DATA_TYPE = 8
AND INTL_TEXT_ID=CZ_PSNODE_PROPVAL_V.PROPERTY_NUM_VALUE) AS TRANSLATED_TEXT
, (SELECT TEXT_STR
FROM CZ_INTL_TEXTS
WHERE DELETED_FLAG = '0'
AND CZ_PSNODE_PROPVAL_V.DATA_TYPE = 8
AND INTL_TEXT_ID=CZ_PSNODE_PROPVAL_V.DEF_NUM_VALUE) AS DEF_TRANSLATED_TEXT
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_PSNODE_PROPVAL_V.PS_NODE_TYPE AS PS_NODE_TYPE
, CZ_PSNODE_PROPVAL_V.INHERITED_FLAG
, CZ_PSNODE_PROPVAL_V.SRC_APPLICATION_ID
FROM CZ_PSNODE_PROPVAL_V
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'PRP'
AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1'
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID=0
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30