INV_ATTR_CONTROLS
This table stores the rules for tracking inventory attributes for an item or category. Records in this table control whether the inventory attributes scuh as Country of Origin will be tracked in on-hand or not.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ATTR_CONTROLS_PK |
INV_ATTR_CONTROLS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INV_ATTR_CONTROLS_ID | NUMBER | 18 | Yes | Inventory Attribute Control unique identifier. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. The value of this column is NULL if the attribute control is defined for an item category. | ||
| ITEM_CATALOG_ID | NUMBER | 18 | This identifies the inventory item catalog. The value of this column is NULL if the attribute contorl is defined for an item. | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | This identifies the inventory item category. The value of this column is NULL if the attribute control is defined for an item. | ||
| TRACKING_ENABLED_FLAG | VARCHAR2 | 1 | This indicates whether the capturing of the inventory attribute is enabled or disabled. | ||
| INV_CONTROL_TYPE | VARCHAR2 | 30 | This indicates whether the control is defined for the item or the item category. A value of I indicates that the control is defined at item level. A value of C indicates that the control is defined at item category level. | ||
| INV_ATTR_CODE | VARCHAR2 | 30 | This indicates the name of the inventory attribute for which the control is defined. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ATTR_CONTROLS_N1 | Non Unique | Default | INV_CONTROL_TYPE, INV_ATTR_CODE, ITEM_CATALOG_ID, ITEM_CATEGORY_ID, ORGANIZATION_ID |
| INV_ATTR_CONTROLS_U1 | Unique | Default | INV_ATTR_CONTROLS_ID |
| INV_ATTR_CONTROLS_U2 | Unique | Default | INV_CONTROL_TYPE, INV_ATTR_CODE, INVENTORY_ITEM_ID, ORGANIZATION_ID, ITEM_CATALOG_ID, ITEM_CATEGORY_ID |