[Home] [Help] [Dependency Information]
Object Name: | CZ_PSNODE_DIRECTPROP_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_PSNODE_DIRECTPROP_INFO_V |
Subobject Name: | |
Status: | VALID |
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 |
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;
|
|
|