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

VIEW: APPS.CZ_ITEM_ITEMPROPVALS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE_ID NUMBER (9)
ID of the item type associated with this record
ITEM_TYPE_DESC_TEXT VARCHAR2 (2000)
Description for this item type
ITEM_TYPE_NAME VARCHAR2 (255)
Name of the item type associated with this record
PROPERTY_ID NUMBER (9) Yes Associates this record with a Property
PROPERTY_UNIT VARCHAR2 (8)
Provides quantity units for the associated Property
PROPERTY_DESC_TEXT VARCHAR2 (2000)
Description text for the associated property
PROPERTY_NAME VARCHAR2 (4000) Yes Name of the associated Property
DATA_TYPE NUMBER (9) Yes Data type of the associated value. 1 - number, 2 - yes/no, 4 - string
PROPERTY_VALUE VARCHAR2 (4000)
Specifies a value for the Property associated with this record
PROPERTY_NUM_VALUE NUMBER

ITEM_ID NUMBER (9) Yes Associates an Item Master record with this record
Query Text

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


SELECT ITEM_TYPE_ID
,      ITEM_TYPE_DESC_TEXT
,      ITEM_TYPE_NAME
,      PROPERTY_ID
,      PROPERTY_UNIT
,      PROPERTY_DESC_TEXT
,      PROPERTY_NAME
,      DATA_TYPE
,      PROPERTY_VALUE
,      PROPERTY_NUM_VALUE
,      ITEM_ID
FROM APPS.CZ_ITEM_ITEMPROPVALS_V;

Dependencies

[top of page]

APPS.CZ_ITEM_ITEMPROPVALS_V references the following:

SchemaAPPS
SynonymCZ_ITEM_MASTERS
SynonymCZ_ITEM_PROPERTY_VALUES
SynonymCZ_ITEM_TYPES
SynonymCZ_PROPERTIES
APPS.CZ_ITEM_ITEMPROPVALS_V is referenced by following:

SchemaAPPS
ViewCZ_ITEM_ITEMVAL_POP_V