INV_CC_SCHEDULE_REQUESTS
INV_CC_SCHEDULE_REQUESTS stores cycle count schedule requests. The SCHEDULE_STATUS column indicates whether the schedule request has been processed, completed, closed without count requests generated, or awaiting processing. . Cycle count schedule requests partially or fully specify the SKU (stock keeping unit) to cycle count. The cycle count generation process explodes each schedule request into count requests that fully specify the SKU against which count entries and adjustments are made. . Oracle Inventory uses this information to feed the count generation process and generate Cycle Count Requests that show up in the Count List Report.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
INV_CC_SCHEDULE_REQUESTS_PK |
CYCLE_COUNT_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CYCLE_COUNT_SCHEDULE_ID | NUMBER | 18 | Yes | Cycle count schedule identifier | |
| CYCLE_COUNT_HEADER_ID | NUMBER | 18 | Yes | Identifies the cycle count header. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier for the Organization | |
| 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. | ||
| REQUEST_SOURCE_TYPE | NUMBER | 18 | Yes | Source of request: auto or manual | |
| INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. | ||
| SUBINVENTORY | VARCHAR2 | 10 | This is name of the subinventory. | ||
| LOCATOR_ID | NUMBER | 18 | This identifies the item locator. | ||
| REVISION | VARCHAR2 | 18 | Revision of item if under revision control. | ||
| LOT_NUMBER | VARCHAR2 | 80 | This number identifies an inventory lot. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | This stores the item unit number. | ||
| SCHEDULE_DATE | DATE | Yes | Date this count should be scheduled | ||
| ZERO_COUNT_FLAG | NUMBER | 18 | Whether or not to count SKU's with no system quantity | ||
| COUNT_DUE_DATE | DATE | Date by which this count should be completed | |||
| COUNT_REQUESTS_GENERATED_FLAG | NUMBER | 18 | Whether or not this schedule-request has been exploded into count-requests | ||
| SCHEDULE_STATUS | NUMBER | 18 | Status of this schedule-request | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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_CC_SCHEDULE_REQUESTS | inv_cycle_count_headers | CYCLE_COUNT_HEADER_ID |
| inv_cc_sched_count_xrefs | inv_cc_schedule_requests | CYCLE_COUNT_SCHEDULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_CC_SCHEDULE_REQUESTS_N1 | Non Unique | Default | CYCLE_COUNT_HEADER_ID, SCHEDULE_DATE, SCHEDULE_STATUS, SUBINVENTORY |
| INV_CC_SCHEDULE_REQUESTS_N2 | Non Unique | Default | CYCLE_COUNT_HEADER_ID, SCHEDULE_STATUS, INVENTORY_ITEM_ID |
| INV_CC_SCHEDULE_REQUESTS_N3 | Non Unique | Default | INVENTORY_ITEM_ID |
| INV_CC_SCHEDULE_REQUESTS_U1 | Unique | Default | CYCLE_COUNT_SCHEDULE_ID |
| INV_CC_SCHEDULE_REQUESTS_U2 | Unique | Default | CYCLE_COUNT_HEADER_ID, CYCLE_COUNT_SCHEDULE_ID |