[Home] [Help] [Dependency Information]
Object Name: | CZ_PSNODE_PROPERTY_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_PSNODE_PROPERTY_DETAILS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
PS_NODE_NAME | VARCHAR2 | (1000) | Name of the psnode for which this record reports a property value | |
PROPERTY_ID | NUMBER | (9) | Identifies a Property associated with the given psnode | |
PROPERTY_NAME | VARCHAR2 | (4000) | Name of the associated Property | |
DATA_TYPE | NUMBER | (9) | From CZ_PROPERTIES.DATA_TYPE: 1-integer;2-decimal;3-boolean;4-text | |
PROPERTY_VALUE | VARCHAR2 | (4000) | Specifies a value for the Property associated with this record | |
PROPERTY_NUM_VALUE | NUMBER | |||
ITEM_ID | NUMBER | (9) | Associates an Item Master record with this record if applicable | |
ITEM_TYPE_ID | NUMBER | (9) | ID of the item type associated with this record if applicable | |
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_PROPERTY_DETAILS_V;
APPS.CZ_PSNODE_PROPERTY_DETAILS_V is not referenced by any database object
|
|
|