[Home] [Help] [Dependency Information]
Object Name: | CZ_ITEM_MASTERS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_ITEM_MASTERS |
Subobject Name: | |
Status: | VALID |
CZ_ITEM_MASTERS contains information about items data used to structure the product. Data can be imported from Oracle Inventory or a legacy system.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_ITEM_MASTERS_PK | NORMAL | UNIQUE | APPS_TS_SEED | ITEM_ID |
CZ_ITEM_MASTERS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DELETED_FLAG
ITEM_ID ITEM_TYPE_ID |
SYS_IL0000032480C00030$$ | LOB | UNIQUE | APPS_TS_SEED | |
CZ_ITEM_MASTERS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
REF_PART_NBR
ITEM_TYPE_ID |
CZ_ITEM_MASTERS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | ITEM_TYPE_ID |
CZ_ITEM_MASTERS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | ORIG_SYS_REF |
CZ_ITEM_MASTERS_NF1 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_SEED | UPPER("REF_PART_NBR") |
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. | |
USER_NUM01 | NUMBER | (16) | User defined numeric field. Not currently used | |
USER_NUM02 | NUMBER | (16) | User defined numeric field. Not currently used | |
USER_NUM03 | NUMBER | (16) | User defined numeric field. Not currently used | |
USER_NUM04 | NUMBER | (16) | User defined numeric field. Not currently used | |
USER_STR01 | VARCHAR2 | (255) | User defined char field. Not currently used | |
USER_STR02 | VARCHAR2 | (255) | User defined char field. Not currently used | |
USER_STR03 | VARCHAR2 | (255) | User defined char field. Not currently used | |
USER_STR04 | VARCHAR2 | (255) | User defined char field. Not currently used | |
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 |
EFF_FROM | DATE | Not currently used | ||
EFF_TO | DATE | Not currently used | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
EFF_MASK | VARCHAR2 | (40) | UNUSED | |
CHECKOUT_USER | VARCHAR2 | (40) | UNUSED | |
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. | ||
SRC_TYPE_CODE | NUMBER | For BOM items, contains BOM_ITEM_TYPE of item (1 = model, 2 = option class, 4 = standard item) |
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
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, LAST_UPDATE_LOGIN
, DECIMAL_QTY_FLAG
, NOTES
, SRC_APPLICATION_ID
, SRC_TYPE_CODE
FROM CZ.CZ_ITEM_MASTERS;
CZ.CZ_ITEM_MASTERS does not reference any database object
CZ.CZ_ITEM_MASTERS is referenced by following:
|
|
|