[Home] [Help] [Dependency Information]
Object Name: | CZ_ITEM_PROPERTIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_ITEM_PROPERTIES_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPERTY_ID | NUMBER | (9) | ||
ITEM_ID | NUMBER | (9) | ||
PROPERTY_VALUE | VARCHAR2 | (4000) | ||
PROPERTY_NUM_VALUE | NUMBER | |||
DELETED_FLAG | VARCHAR2 | (1) | ||
PROPERTY_NAME | VARCHAR2 | (4000) | ||
ITEM_TYPE_ID | NUMBER | (9) | ||
DATA_TYPE | NUMBER | (9) | ||
DESC_TEXT | VARCHAR2 | (2000) | ||
ORIG_SYS_REF | VARCHAR2 | (2000) | ||
DEF_VALUE | VARCHAR2 | (4000) | ||
DEF_NUM_VALUE | NUMBER | |||
DEF_TRANSLATED_TEXT | VARCHAR2 | (2000) | ||
TRANSLATED_TEXT | VARCHAR2 | (2000) | ||
INHERITED_FLAG | NUMBER | |||
SRC_APPLICATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROPERTY_ID
, ITEM_ID
, PROPERTY_VALUE
, PROPERTY_NUM_VALUE
, DELETED_FLAG
, PROPERTY_NAME
, ITEM_TYPE_ID
, DATA_TYPE
, DESC_TEXT
, ORIG_SYS_REF
, DEF_VALUE
, DEF_NUM_VALUE
, DEF_TRANSLATED_TEXT
, TRANSLATED_TEXT
, INHERITED_FLAG
, SRC_APPLICATION_ID
FROM APPS.CZ_ITEM_PROPERTIES_V;
APPS.CZ_ITEM_PROPERTIES_V is not referenced by any database object
|
|
|