[Home] [Help]
View: CZ_PSNODE_PROPERTY_DETAILS_V
View Text
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
, TRANSLATED_TEXT
, DEF_TRANSLATED_TEXT
, IMAGE_FILE
, FULL_IMAGE_PATH
, ALT_TEXT
, PS_NODE_TYPE
, INHERITED_FLAG
, SRC_APPLICATION_ID
FROM CZ_PSNODE_DIRECTPROP_INFO_V PSNODE_PROP_DETAILS
Columns
Name |
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 |
TRANSLATED_TEXT |
DEF_TRANSLATED_TEXT |
IMAGE_FILE |
FULL_IMAGE_PATH |
ALT_TEXT |
PS_NODE_TYPE |
INHERITED_FLAG |
SRC_APPLICATION_ID |