INV_RULE_TRACE_HEADERS
INV 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.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_RULE_TRACE_HEADERS_PK |
HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HEADER_ID | NUMBER | 18 | Yes | This is the primary key of the inventory rule trace header. | |
| PICK_HEADER_ID | NUMBER | 18 | Identifier of the Picking Record in case of Transfer | ||
| MOVE_ORDER_LINE_ID | NUMBER | 18 | Identifier of the Move order line Record | ||
| TOTAL_QTY | NUMBER | This column has the total quantity. | |||
| TYPE_CODE | NUMBER | 18 | This code indicates the rule type. | ||
| BUSINESS_OBJECT_ID | NUMBER | 18 | Identifier for Business Object. | ||
| OBJECT_ID | NUMBER | 18 | Identifier for a specific instances of the Business Object. | ||
| STRATEGY_ID | NUMBER | 18 | Identifier for selected Strategy | ||
| SID | NUMBER | 18 | This column identifies the session. | ||
| SERIAL_NUMBER | NUMBER | Session User Identifier - Serial Number | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_NAME | VARCHAR2 | 80 | This is the business object name. | ||
| SIMULATION_MODE | VARCHAR2 | 1 | This indicates the simulation mode. | ||
| SO_START_TIME | DATE | This is the start time of search order. | |||
| SO_END_TIME | DATE | This is the end time of search order. | |||
| SECONDARY_TOTAL_QTY | NUMBER | Total suggested quantity in secondary UOM | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| inv_rule_trace_lines | inv_rule_trace_headers | HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_RULE_TRACE_HEADERS_N2 | Non Unique | Default | MOVE_ORDER_LINE_ID |
| INV_RULE_TRACE_HEADERS_N3 | Non Unique | Default | CREATION_DATE |
| INV_RULE_TRACE_HEADERS_N4 | Non Unique | Default | SID, SIMULATION_MODE |
| INV_RULE_TRACE_HEADERS_U1 | Unique | Default | HEADER_ID |