[Home] [Help]
[Dependency Information]
[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:
CZ
CZ_ITEM_MASTERS#
|
|
|
|