Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_RULE_TRACE_LINES

Object Details
Object Name: WMS_RULE_TRACE_LINES
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_RULE_TRACE_LINES
Subobject Name:
Status: VALID


WMS Rule Trace Lines stores multiple records for each rule processed for the strategy_id stored in WMS Rule Trace Headers. The number of records for each processed rule depend upon the number of suggested locators returned by the rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_RULE_TRACE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Identifier for this record along with line id.
LINE_ID NUMBER
Yes Identifier for this record along with header id.
RULE_ID NUMBER

Rule identifier
QUANTITY NUMBER

On Hand Quantity
REVISION VARCHAR2 (3)
Revision
LOT_NUMBER VARCHAR2 (80)
The lot number if the item is under lot control
LOT_EXPIRATION_DATE DATE

Lot expiration date
SERIAL_NUMBER VARCHAR2 (30)
The serial number if the item is under serial control
SUBINVENTORY_CODE VARCHAR2 (10)
Current subinventory code
LOCATOR_ID NUMBER

Locator of the item for the suggested Subinventory code by the rules engine.
COST_GROUP_ID NUMBER

Cost Group of the Item
UOM_CODE VARCHAR2 (3)
Picking Unit of Measure
REMAINING_QTY NUMBER

The remaining quantity to be suggested.
ATT_QTY NUMBER

Available Quantity to Transact.
SUGGESTED_QTY NUMBER

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)
Consistency Validation flag.
ORDER_STRING_FLAG VARCHAR2 (1)
Sort Criteria Validattion flag.
MATERIAL_STATUS_FLAG VARCHAR2 (1)
Material Status Validation flag.
PICK_UOM_FLAG VARCHAR2 (1)
Pick UOM Validation flag.
PARTIAL_PICK_FLAG VARCHAR2 (1)
Partial Pick validation flag
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
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LPN_ID NUMBER

License Plate Number identifier
ENTIRE_LPN_FLAG VARCHAR2 (1)
Entire LPN flag
RULE_START_TIME DATE

Rule Start Time
RULE_END_TIME DATE

Rule End time
SECONDARY_SUGGESTED_QTY NUMBER

Suggested quantity in secondary UOM
SECONDARY_ATT_QTY NUMBER

Available to transact quantity in secondary UOM
SECONDARY_QUANTITY NUMBER

Quantity in secondary UOM
GRADE_CODE VARCHAR2 (150)
Lot Grade code
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary UOM Code
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HEADER_ID
,      LINE_ID
,      RULE_ID
,      QUANTITY
,      REVISION
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      COST_GROUP_ID
,      UOM_CODE
,      REMAINING_QTY
,      ATT_QTY
,      SUGGESTED_QTY
,      SAME_SUBINV_LOC_FLAG
,      ATT_QTY_FLAG
,      CONSIST_STRING_FLAG
,      ORDER_STRING_FLAG
,      MATERIAL_STATUS_FLAG
,      PICK_UOM_FLAG
,      PARTIAL_PICK_FLAG
,      SERIAL_NUMBER_USED_FLAG
,      CG_COMINGLE_FLAG
,      COMMENTS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LPN_ID
,      ENTIRE_LPN_FLAG
,      RULE_START_TIME
,      RULE_END_TIME
,      SECONDARY_SUGGESTED_QTY
,      SECONDARY_ATT_QTY
,      SECONDARY_QUANTITY
,      GRADE_CODE
,      SECONDARY_UOM_CODE
FROM WMS.WMS_RULE_TRACE_LINES;

Dependencies

[top of page]

WMS.WMS_RULE_TRACE_LINES does not reference any database object

WMS.WMS_RULE_TRACE_LINES is referenced by following:

SchemaWMS
ViewWMS_RULE_TRACE_LINES#