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

VIEW: APPS.CZ_IM_ITEM_TYPES_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE_ID NUMBER (9) Yes Unique identifier for this item type
DESC_TEXT VARCHAR2 (2000)
Item type description
NAME VARCHAR2 (255)
Item type name
ORIG_SYS_REF VARCHAR2 (255)
Original system reference: MTL_ITEM_CATALOG_GROUPS.ITEM_CATALOG_GROUP_ID if imported from Oracle Inventory. 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
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_TYPE_ID
,      DESC_TEXT
,      NAME
,      ORIG_SYS_REF
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ALT_TEXT
,      OBJECT_TYPE_DESC
,      IMAGE_FILE
,      FULL_IMAGE_PATH
FROM APPS.CZ_IM_ITEM_TYPES_V;

Dependencies

[top of page]

APPS.CZ_IM_ITEM_TYPES_V references the following:

SchemaAPPS
SynonymCZ_ITEM_TYPES
ViewCZ_RPOBJECTTYPES_LKV
ViewCZ_UI_PATHED_IMAGES_V

APPS.CZ_IM_ITEM_TYPES_V is not referenced by any database object