eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CZ_IM_ITEMS_V

Object Details

Object Name:	CZ_IM_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_IM_ITEMS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER	(9)	Yes	Item unique identifier
ITEM_TYPE_ID	NUMBER	(9)		Item type identifier
DESC_TEXT	VARCHAR2	(2000)		Item description
REF_PART_NBR	VARCHAR2	(1000)	Yes	Reference part number. If items are imported from Oracle Inventory, RefPartNbr setting in CZ_DB_SETTINGS table defines which values will be imported.
QUOTEABLE_FLAG	VARCHAR2	(1)		Flag indicating if item will appear in quote.
LEAD_TIME	NUMBER	(9)		Item lead time
ITEM_STATUS	NUMBER	(9)		UNUSED
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure code
ORIG_SYS_REF	VARCHAR2	(255)		Original system reference: MTL_SYSTEM_ITEMS.ORGANIZATION_ID:MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID. Used for imported items only.
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
DELETED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
DECIMAL_QTY_FLAG	VARCHAR2	(1)	Yes	'1' indicates the item described by this record is measured in fractional quantities; '0' indicates quantities must be whole/units
NOTES	CLOB	(4000)		Note Text
SRC_APPLICATION_ID	NUMBER			Contains ID of application from which item was imported.
ALT_TEXT	VARCHAR2	(4000)
OBJECT_TYPE_DESC	VARCHAR2	(4000)
IMAGE_FILE	VARCHAR2	(4000)
FULL_IMAGE_PATH	VARCHAR2	(4000)

Query Text

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


SELECT ITEM_ID
,      ITEM_TYPE_ID
,      DESC_TEXT
,      REF_PART_NBR
,      QUOTEABLE_FLAG
,      LEAD_TIME
,      ITEM_STATUS
,      PRIMARY_UOM_CODE
,      ORIG_SYS_REF
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DECIMAL_QTY_FLAG
,      NOTES
,      SRC_APPLICATION_ID
,      ALT_TEXT
,      OBJECT_TYPE_DESC
,      IMAGE_FILE
,      FULL_IMAGE_PATH
FROM APPS.CZ_IM_ITEMS_V;

Dependencies

[top of page]

APPS.CZ_IM_ITEMS_V references the following:

APPS: CZ_ITEM_MASTERS; CZ_RPOBJECTTYPES_LKV; CZ_UI_PATHED_IMAGES_V

APPS.CZ_IM_ITEMS_V is not referenced by any database object