[Home] [Help] [Dependency Information]
Object Name: | CZ_IM_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_IM_ITEMS_V |
Subobject Name: | |
Status: | VALID |
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) |
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;
APPS.CZ_IM_ITEMS_V is not referenced by any database object
|
|
|