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