VIEW: WMS.WMS_RULE_TRACE_LINES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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