[Home] [Help] [Dependency Information]
Object Name: | WMS_RULE_TRACE_LINES |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_RULE_TRACE_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
HEADER_ID
LINE_ID |
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 |
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;
WMS.WMS_RULE_TRACE_LINES does not reference any database object
WMS.WMS_RULE_TRACE_LINES is referenced by following:
|
|
|