INV_RULE_TRACE_LINES
INV Rule Trace Lines stores multiple records for each rule processed for the strategy_id stored in INV Rule Trace Headers. The number of records for each processed rule depend upon the number of suggested locators returned by the rule.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
INV_RULE_TRACE_LINES_PK |
HEADER_ID, LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
HEADER_ID | NUMBER | 18 | Yes | Identifier for this record along with line id. | |
LINE_ID | NUMBER | 18 | Yes | Identifier for this record along with header id. | |
RULE_ID | NUMBER | 18 | This column identifies the WMS rule. | ||
QUANTITY | NUMBER | This column stores the onhand quantity. | |||
REVISION | VARCHAR2 | 3 | Revision of item if under revision control. | ||
LOT_NUMBER | VARCHAR2 | 80 | The lot number if the item is under lot control | ||
LOT_EXPIRATION_DATE | DATE | This is the lot expiration date. | |||
SERIAL_NUMBER | VARCHAR2 | 80 | The serial number if the item is under serial control | ||
SUBINVENTORY_CODE | VARCHAR2 | 10 | This is name of the current subinventory. | ||
LOCATOR_ID | NUMBER | 18 | Locator of the item for the suggested Subinventory code by the rules engine. | ||
COST_GROUP_ID | NUMBER | 18 | This identifies the cost group of the item. | ||
UOM_CODE | VARCHAR2 | 3 | Indicates the picking unit of measure. | ||
REMAINING_QTY | NUMBER | The remaining quantity to be suggested. | |||
ATT_QTY | NUMBER | Available Quantity to Transact. | |||
SUGGESTED_QTY | NUMBER | This is the suggested quantity. | |||
SAME_SUBINV_LOC_FLAG | VARCHAR2 | 1 | Same Suninventory and Locator validation flag | ||
ATT_QTY_FLAG | VARCHAR2 | 1 | Available Quantity Validation flag. | ||
CONSIST_STRING_FLAG | VARCHAR2 | 1 | Flag that sets consistency validation. | ||
ORDER_STRING_FLAG | VARCHAR2 | 1 | Sort Criteria Validattion flag. | ||
MATERIAL_STATUS_FLAG | VARCHAR2 | 1 | Material Status Validation flag. | ||
PICK_UOM_FLAG | VARCHAR2 | 1 | This flag enables pick unit of measure validation. | ||
PARTIAL_PICK_FLAG | VARCHAR2 | 1 | This flag enables partial pick validation. | ||
SERIAL_NUMBER_USED_FLAG | VARCHAR2 | 1 | Serial Number used validation flag | ||
CG_COMINGLE_FLAG | VARCHAR2 | 1 | Cost Group Commingle Validation flag. | ||
COMMENTS | VARCHAR2 | 2000 | Comments for the inventory rule trace line. | ||
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. | ||
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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
LPN_ID | NUMBER | 18 | License Plate Number identifier | ||
ENTIRE_LPN_FLAG | VARCHAR2 | 1 | Flag indicates entire packing unit. | ||
RULE_START_TIME | DATE | This is the start time of this rule trace line. | |||
RULE_END_TIME | DATE | This is the end time of this rule trace line. | |||
SECONDARY_SUGGESTED_QTY | NUMBER | Suggested quantity in secondary UOM | |||
SECONDARY_ATT_QTY | NUMBER | Available to transact quantity in secondary UOM | |||
SECONDARY_QUANTITY | NUMBER | This is the secondary quantity. | |||
GRADE_CODE | VARCHAR2 | 150 | This code indicates the lot grade. | ||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Unit of measure for secondary quantity. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
INV_RULE_TRACE_LINES | inv_rule_trace_headers | HEADER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_RULE_TRACE_LINES_U1 | Unique | Default | HEADER_ID, LINE_ID |