INV_CYCLE_COUNT_CLASSES
INV_CYCLE_COUNT_CLASSES stores information about cycle count classes such as associated cycle count name, approval tolerance limits, and minimum counting frequency. . Oracle Inventory uses Cycle Count Classes as a unit for specifying and defaulting cycle count attributes. The cycle count scheduler uses counting frequency to determine if the class is eligible, and if so, how many and which items are eligible for scheduling. The count entry and approvals form uses tolerance limits to determine if an adjustment needs to be made. .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
INV_CYCLE_COUNT_CLASSES_PK |
CYCLE_COUNT_CLASS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CYCLE_COUNT_CLASS_ID | NUMBER | 18 | Yes | Cycle Count Class Identifier (Primary Key) | |
ABC_CLASS_ID | NUMBER | 18 | Yes | This column identifies the ABC class. | |
CYCLE_COUNT_HEADER_ID | NUMBER | 18 | Yes | Identifies the cycle count header. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory 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. | ||
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. | |
NUM_COUNTS_PER_YEAR | NUMBER | 18 | Number of times an item in this class should be counted per year | ||
APPROVAL_TOLERANCE_POSITIVE | NUMBER | Positive percent tolerance, above which an adjustment transaction 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, below which an adjustment transaction requires explicit approval | |||
HIT_MISS_TOLERANCE_POSITIVE | NUMBER | Positive percent tolerance used for hit/miss analysis | |||
HIT_MISS_TOLERANCE_NEGATIVE | NUMBER | Negative percent tolerance used for hit/miss analysis | |||
ABC_ASSIGNMENT_GROUP_ID | NUMBER | 18 | Identifier of ABC group upon which this class is based | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
INV_CYCLE_COUNT_CLASSES | inv_abc_classes | ABC_CLASS_ID |
INV_CYCLE_COUNT_CLASSES | inv_cycle_count_headers | CYCLE_COUNT_HEADER_ID |
INV_CYCLE_COUNT_CLASSES | inv_org_parameters | ORGANIZATION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_CYCLE_COUNT_CLASSES_U1 | Unique | Default | CYCLE_COUNT_HEADER_ID, ABC_CLASS_ID |
INV_CYCLE_COUNT_CLASSES_U2 | Unique | Default | CYCLE_COUNT_CLASS_ID |