INV_CYCLE_COUNT_ITEMS
INV_CYCLE_COUNT_ITEMS stores information about all the items that are eligible for cycle counting within the scope of a cycle count name. Oracle Inventory uses this information to direct and validate the cycle count scheduling process when entering manual schedule requests. It includes specific information regarding the item, including its class-assignment and the date it was last scheduled to be counted by the cycle count.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_CYCLE_COUNT_ITEMS_PK |
CYCLE_COUNT_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CYCLE_COUNT_ITEM_ID | NUMBER | 18 | Yes | Cycle Count Item Identifier (Primary Key) | |
| CYCLE_COUNT_HEADER_ID | NUMBER | 18 | Yes | Identifies the cycle count header. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| ABC_CLASS_ID | NUMBER | 18 | Yes | This column identifies the ABC class. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | |
| ITEM_LAST_SCHEDULE_DATE | DATE | Date item was last scheduled to be counted | |||
| SCHEDULE_ORDER | NUMBER | 18 | Order in which item will be scheduled, relative to the schedule-order of other items within this cycle count | ||
| APPROVAL_TOLERANCE_POSITIVE | NUMBER | Positive percent tolerance, above which an adjustment transactions requires explicit approval | |||
| APPROVAL_TOLERANCE_NEGATIVE | NUMBER | Negative percent tolerance, below which an adjustment transaction requires explicit approval | |||
| COST_TOLERANCE_POSITIVE | NUMBER | Positive currency tolerance, above which an adjustment transaction requires explicit approval | |||
| COST_TOLERANCE_NEGATIVE | NUMBER | Negative currency tolerance, above which an adjustment transaction requires explicit approval | |||
| INCLUDE_IN_SCHEDULE | NUMBER | 18 | Flag to indicate whether to Include the item while Scheduling for the Cycle Count | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_CYCLE_COUNT_ITEMS | inv_cycle_count_headers | CYCLE_COUNT_HEADER_ID |
| INV_CYCLE_COUNT_ITEMS | inv_abc_classes | ABC_CLASS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_CYCLE_COUNT_ITEMS_N1 | Non Unique | Default | CYCLE_COUNT_HEADER_ID, ABC_CLASS_ID, ORGANIZATION_ID |
| INV_CYCLE_COUNT_ITEMS_U1 | Unique | Default | CYCLE_COUNT_HEADER_ID, INVENTORY_ITEM_ID |
| INV_CYCLE_COUNT_ITEMS_U2 | Unique | Default | CYCLE_COUNT_ITEM_ID |