VIEW: CZ.CZ_PSNODE_PROPCOMPAT_GENS#

Source

View Text - Preformatted

select COMPAT_RUN COMPAT_RUN, COMPAT_FEAT COMPAT_FEAT, PS_NODE_ID PS_NODE_ID, PARENT_ID PARENT_ID, PS_NODE_NAME PS_NODE_NAME, PROPERTY_ID PROPERTY_ID, PROPERTY_NAME PROPERTY_NAME, PROPERTY_VALUE PROPERTY_VALUE, ITEM_ID ITEM_ID, ITEM_TYPE_ID ITEM_TYPE_ID, VALUESOURCE VALUESOURCE, DELETED_FLAG DELETED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EFF_FROM EFF_FROM, EFF_TO EFF_TO, EFF_MASK EFF_MASK, SECURITY_MASK SECURITY_MASK, CHECKOUT_USER CHECKOUT_USER, PROPERTY_VALUE_NUM PROPERTY_VALUE_NUM, PERSISTENT_PS_NODE_ID PERSISTENT_PS_NODE_ID, PERSISTENT_PARENT_ID PERSISTENT_PARENT_ID, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID from "CZ"."CZ_PSNODE_PROPCOMPAT_GENS"

View Text - HTML Formatted

SELECT COMPAT_RUN COMPAT_RUN
, COMPAT_FEAT COMPAT_FEAT
, PS_NODE_ID PS_NODE_ID
, PARENT_ID PARENT_ID
, PS_NODE_NAME PS_NODE_NAME
, PROPERTY_ID PROPERTY_ID
, PROPERTY_NAME PROPERTY_NAME
, PROPERTY_VALUE PROPERTY_VALUE
, ITEM_ID ITEM_ID
, ITEM_TYPE_ID ITEM_TYPE_ID
, VALUESOURCE VALUESOURCE
, DELETED_FLAG DELETED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, EFF_MASK EFF_MASK
, SECURITY_MASK SECURITY_MASK
, CHECKOUT_USER CHECKOUT_USER
, PROPERTY_VALUE_NUM PROPERTY_VALUE_NUM
, PERSISTENT_PS_NODE_ID PERSISTENT_PS_NODE_ID
, PERSISTENT_PARENT_ID PERSISTENT_PARENT_ID
, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID
FROM "CZ"."CZ_PSNODE_PROPCOMPAT_GENS"