[Home] [Help] [Dependency Information]
Object Name: | WMS_RULE_TRACE_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_RULE_TRACE_HEADERS |
Subobject Name: | |
Status: | VALID |
WMS Rule Trace Header is Used for storing Move order and Strategy search order information for
each move order line processed by the Rules Engine. One record is stored for Pick or Putaway type of Processing. For Transfers, two records are stored. In case of transfers the putaway record contains Pick_header_id to link back to the Picking record.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_RULE_TRACE_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | HEADER_ID |
WMS_RULE_TRACE_HEADERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MOVE_ORDER_LINE_ID |
WMS_RULE_TRACE_HEADERS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CREATION_DATE |
WMS_RULE_TRACE_HEADERS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SID
SIMULATION_MODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Identifier for this record | |
PICK_HEADER_ID | NUMBER | Identifier of the Picking Record in case of Transfer | ||
MOVE_ORDER_LINE_ID | NUMBER | Identifier of the Move order line Record | ||
TOTAL_QTY | NUMBER | Total Quantity | ||
TYPE_CODE | NUMBER | Rule type code | ||
BUSINESS_OBJECT_ID | NUMBER | Identifier for Business Object. | ||
OBJECT_ID | NUMBER | Identifier for a specific instances of the Business Object. | ||
STRATEGY_ID | NUMBER | Identifier for selected Strategy | ||
SID | NUMBER | session Identifier. | ||
SERIAL_NUMBER | NUMBER | Session User Identifier - Serial Number | ||
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 | ||
OBJECT_NAME | VARCHAR2 | (80) | Object Name | |
SIMULATION_MODE | VARCHAR2 | (1) | Simulation mode identifier | |
SO_START_TIME | DATE | Standard Who column | ||
SO_END_TIME | DATE | Search order end time | ||
SECONDARY_TOTAL_QTY | NUMBER | Total suggested quantity in secondary UOM |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, PICK_HEADER_ID
, MOVE_ORDER_LINE_ID
, TOTAL_QTY
, TYPE_CODE
, BUSINESS_OBJECT_ID
, OBJECT_ID
, STRATEGY_ID
, SID
, SERIAL_NUMBER
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, OBJECT_NAME
, SIMULATION_MODE
, SO_START_TIME
, SO_END_TIME
, SECONDARY_TOTAL_QTY
FROM WMS.WMS_RULE_TRACE_HEADERS;
WMS.WMS_RULE_TRACE_HEADERS does not reference any database object
WMS.WMS_RULE_TRACE_HEADERS is referenced by following:
|
|
|