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

VIEW: APPS.CZ_PSNODE_DIRECTPROP_INFO_V

Object Details
Object Name: CZ_PSNODE_DIRECTPROP_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_PSNODE_DIRECTPROP_INFO_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PS_NODE_ID NUMBER (15)
PS_NODE_NAME VARCHAR2 (1000)
PROPERTY_ID NUMBER (9)
PROPERTY_NAME VARCHAR2 (4000)
DATA_TYPE NUMBER (9)
PROPERTY_VALUE VARCHAR2 (4000)
PROPERTY_NUM_VALUE NUMBER

ITEM_ID NUMBER (9)
ITEM_TYPE_ID NUMBER (9)
DEFAULT_VALUE VARCHAR2 (4000)
DEF_NUM_VALUE NUMBER

PROP_ATTACHES VARCHAR2 (10)
ORIG_SYS_REF VARCHAR2 (2000)
VALUE_ORIG_SYS_REF VARCHAR2 (2000)
PROPERTY_ORIG_SYS_REF VARCHAR2 (255)
TRANSLATED_TEXT VARCHAR2 (2000)
DEF_TRANSLATED_TEXT VARCHAR2 (2000)
IMAGE_FILE VARCHAR2 (4000)
FULL_IMAGE_PATH VARCHAR2 (4000)
ALT_TEXT VARCHAR2 (4000)
PS_NODE_TYPE NUMBER (9)
INHERITED_FLAG VARCHAR2 (1)
SRC_APPLICATION_ID NUMBER

Query Text

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


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 APPS.CZ_PSNODE_DIRECTPROP_INFO_V;

Dependencies

[top of page]

APPS.CZ_PSNODE_DIRECTPROP_INFO_V references the following:

SchemaAPPS
SynonymCZ_INTL_TEXTS
ViewCZ_PSNODE_PROPVAL_V
ViewCZ_RPOBJECTTYPES_LKV
ViewCZ_UI_PATHED_IMAGES_V
APPS.CZ_PSNODE_DIRECTPROP_INFO_V is referenced by following:

SchemaAPPS
ViewCZ_PSNODE_PROPERTY_DETAILS_V