Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: CZ.CZ_PSNODE_PROPCOMPAT_GENS#

Object Details
Object Name: CZ_PSNODE_PROPCOMPAT_GENS#
Object Type: VIEW
Owner: CZ
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPAT_RUN NUMBER
Yes
COMPAT_FEAT VARCHAR2 (1) Yes
PS_NODE_ID NUMBER
Yes
PARENT_ID NUMBER
Yes
PS_NODE_NAME VARCHAR2 (255) Yes
PROPERTY_ID NUMBER
Yes
PROPERTY_NAME VARCHAR2 (255) Yes
PROPERTY_VALUE VARCHAR2 (255)
ITEM_ID NUMBER

ITEM_TYPE_ID NUMBER

VALUESOURCE VARCHAR2 (30) Yes
DELETED_FLAG VARCHAR2 (1) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
EFF_FROM DATE

EFF_TO DATE

EFF_MASK VARCHAR2 (40)
SECURITY_MASK VARCHAR2 (40)
CHECKOUT_USER VARCHAR2 (40)
PROPERTY_VALUE_NUM NUMBER (25)
PERSISTENT_PS_NODE_ID NUMBER

PERSISTENT_PARENT_ID NUMBER

MODEL_REF_EXPL_ID NUMBER (9)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

CZ.CZ_PSNODE_PROPCOMPAT_GENS# references the following:

SchemaCZ
TableCZ_PSNODE_PROPCOMPAT_GENS
CZ.CZ_PSNODE_PROPCOMPAT_GENS# is referenced by following:

SchemaAPPS
SynonymCZ_PSNODE_PROPCOMPAT_GENS
TriggerCZ_PSNODE_PROPCOMPAT_GENS_T1