[Home] [Help] [Dependency Information]
Object Name: | WMS_RULE_TRACE_LINES# |
---|---|
Object Type: | VIEW |
Owner: | WMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | ||
LINE_ID | NUMBER | Yes | ||
RULE_ID | NUMBER | |||
QUANTITY | NUMBER | |||
REVISION | VARCHAR2 | (3) | ||
LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_EXPIRATION_DATE | DATE | |||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
COST_GROUP_ID | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
REMAINING_QTY | NUMBER | |||
ATT_QTY | NUMBER | |||
SUGGESTED_QTY | NUMBER | |||
SAME_SUBINV_LOC_FLAG | VARCHAR2 | (1) | ||
ATT_QTY_FLAG | VARCHAR2 | (1) | ||
CONSIST_STRING_FLAG | VARCHAR2 | (1) | ||
ORDER_STRING_FLAG | VARCHAR2 | (1) | ||
MATERIAL_STATUS_FLAG | VARCHAR2 | (1) | ||
PICK_UOM_FLAG | VARCHAR2 | (1) | ||
PARTIAL_PICK_FLAG | VARCHAR2 | (1) | ||
SERIAL_NUMBER_USED_FLAG | VARCHAR2 | (1) | ||
CG_COMINGLE_FLAG | VARCHAR2 | (1) | ||
COMMENTS | VARCHAR2 | (2000) | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LPN_ID | NUMBER | |||
ENTIRE_LPN_FLAG | VARCHAR2 | (1) | ||
RULE_START_TIME | DATE | |||
RULE_END_TIME | DATE | |||
SECONDARY_SUGGESTED_QTY | NUMBER | |||
SECONDARY_ATT_QTY | NUMBER | |||
SECONDARY_QUANTITY | NUMBER | |||
GRADE_CODE | VARCHAR2 | (150) | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) |
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#;
|
|
|