[Home] [Help] [Dependency Information]
Object Name: | WMS_MATERIAL_TXN_TRACE |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_MATERIAL_TXN_TRACE |
Subobject Name: | |
Status: | VALID |
This is history table for mtl_material_transaction_temp used for run time trace purpose. - This for WMS internal Use only.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_MATERIAL_TXN_TRACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MOVE_ORDER_LINE_ID |
WMS_MATERIAL_TXN_TRACE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_TEMP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | Yes | Transaction Header identifier - This for WMS internal Use only. | |
TRANSACTION_TEMP_ID | NUMBER | Transaction Temp identifier - This for WMS internal Use only. | ||
SOURCE_CODE | VARCHAR2 | (30) | Source code | |
SOURCE_LINE_ID | NUMBER | Source line ID | ||
TRANSACTION_MODE | NUMBER | Transaction Mode | ||
LOCK_FLAG | VARCHAR2 | (1) | LOCk Flag | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
REQUEST_ID | NUMBER | Standard WHO Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard WHO Column | ||
PROGRAM_ID | NUMBER | Standard WHO Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard WHO Column | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
REVISION | VARCHAR2 | (3) | Revision | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory Code | |
LOCATOR_ID | NUMBER | Locator Id | ||
TRANSACTION_QUANTITY | NUMBER | Yes | Transaction Quantity | |
PRIMARY_QUANTITY | NUMBER | Yes | Primary Quantity | |
TRANSACTION_UOM | VARCHAR2 | (3) | Yes | Transaction UOM |
TRANSACTION_COST | NUMBER | Transaction Cost | ||
TRANSACTION_TYPE_ID | NUMBER | Yes | Transaction Type Identifier | |
TRANSACTION_ACTION_ID | NUMBER | Yes | Transaction Action Identifier | |
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | Transaction Source Type Id | |
TRANSACTION_SOURCE_ID | NUMBER | Transaction Source Identifier | ||
TRANSACTION_SOURCE_NAME | VARCHAR2 | (30) | Transaction Source name | |
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
ACCT_PERIOD_ID | NUMBER | Yes | Accounting Period Identifier | |
DISTRIBUTION_ACCOUNT_ID | NUMBER | Distribution Account identifier | ||
TRANSACTION_REFERENCE | VARCHAR2 | (240) | Transaction Reference | |
REQUISITION_LINE_ID | NUMBER | Requisition Identifier | ||
REQUISITION_DISTRIBUTION_ID | NUMBER | Requisition Distribution Identifier | ||
REASON_ID | NUMBER | Resion Identifier | ||
LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
LOT_EXPIRATION_DATE | DATE | Lot Expiration Date | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
RECEIVING_DOCUMENT | VARCHAR2 | (10) | Receiving Document | |
DEMAND_ID | NUMBER | Deman Identifier | ||
RCV_TRANSACTION_ID | NUMBER | Receiving Transaction Identifier | ||
MOVE_TRANSACTION_ID | NUMBER | Move Transaction Identifier | ||
COMPLETION_TRANSACTION_ID | NUMBER | Completion Transaction Identifier | ||
WIP_ENTITY_TYPE | NUMBER | WIP Entity Type | ||
SCHEDULE_ID | NUMBER | Schedule Identifier | ||
REPETITIVE_LINE_ID | NUMBER | Repetitive line Identifier | ||
EMPLOYEE_CODE | VARCHAR2 | (10) | Employee Code | |
PRIMARY_SWITCH | NUMBER | Primary Switch | ||
SCHEDULE_UPDATE_CODE | NUMBER | Schedule update code | ||
SETUP_TEARDOWN_CODE | NUMBER | Setup Teardown code | ||
ITEM_ORDERING | NUMBER | Item Ordering | ||
NEGATIVE_REQ_FLAG | NUMBER | Negative Req Flag | ||
OPERATION_SEQ_NUM | NUMBER | OPERATION Sequence Number | ||
PICKING_LINE_ID | NUMBER | Picking Line Identifier | ||
TRX_SOURCE_LINE_ID | NUMBER | Transaction Source line Identifier | ||
TRX_SOURCE_DELIVERY_ID | NUMBER | Transaction Source Delivery Identifier | ||
PHYSICAL_ADJUSTMENT_ID | NUMBER | Physical Adjustment Identifier | ||
CYCLE_COUNT_ID | NUMBER | Cycle Count Identifier | ||
RMA_LINE_ID | NUMBER | RMA line Identifier | ||
CUSTOMER_SHIP_ID | NUMBER | Customer Ship Identifier | ||
CURRENCY_CODE | VARCHAR2 | (10) | Currency code | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGl Transaction Code | |
VENDOR_LOT_NUMBER | VARCHAR2 | (30) | Vendor Lot Number | |
ENCUMBRANCE_ACCOUNT | NUMBER | Encumberance Account | ||
ENCUMBRANCE_AMOUNT | NUMBER | Encumberance Amount | ||
SHIP_TO_LOCATION | NUMBER | Ship to Location | ||
SHIPMENT_NUMBER | VARCHAR2 | (30) | Shipment Number | |
TRANSFER_COST | NUMBER | Transfer Cost | ||
TRANSPORTATION_COST | NUMBER | Transportation Cost | ||
TRANSPORTATION_ACCOUNT | NUMBER | Transportation Account | ||
FREIGHT_CODE | VARCHAR2 | (25) | Freight code | |
CONTAINERS | NUMBER | Containers | ||
WAYBILL_AIRBILL | VARCHAR2 | (20) | WayBill Airbill | |
EXPECTED_ARRIVAL_DATE | DATE | Expected Arrival Date | ||
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Transfer subinventory | |
TRANSFER_ORGANIZATION | NUMBER | Transfer Organization | ||
TRANSFER_TO_LOCATION | NUMBER | Transfer to location | ||
NEW_AVERAGE_COST | NUMBER | Ner Average cost | ||
VALUE_CHANGE | NUMBER | Value Change | ||
PERCENTAGE_CHANGE | NUMBER | Percentage Change | ||
MATERIAL_ALLOCATION_TEMP_ID | NUMBER | Material allocation temp identifier | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | Demand Source header identifier | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand Source line | |
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Demand Source Delivery | |
ITEM_SEGMENTS | VARCHAR2 | (240) | Item Segments | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Descriptions | |
ITEM_TRX_ENABLED_FLAG | VARCHAR2 | (1) | Item Txn Enabled flag | |
ITEM_LOCATION_CONTROL_CODE | NUMBER | Item location control code | ||
ITEM_RESTRICT_SUBINV_CODE | NUMBER | Item restrict subinventory code | ||
ITEM_RESTRICT_LOCATORS_CODE | NUMBER | Item restrict locators code | ||
ITEM_REVISION_QTY_CONTROL_CODE | NUMBER | Item revision qty control code | ||
ITEM_PRIMARY_UOM_CODE | VARCHAR2 | (3) | Item primary UOM code | |
ITEM_UOM_CLASS | VARCHAR2 | (10) | Item UOM Class | |
ITEM_SHELF_LIFE_CODE | NUMBER | Item Shelf Life Code | ||
ITEM_SHELF_LIFE_DAYS | NUMBER | Item shelf life days | ||
ITEM_LOT_CONTROL_CODE | NUMBER | Item Lot control code | ||
ITEM_SERIAL_CONTROL_CODE | NUMBER | Item serial control code | ||
ITEM_INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Item Inventory Asset flag | |
ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Allowed units lookup code | ||
DEPARTMENT_ID | NUMBER | Deparment identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
WIP_SUPPLY_TYPE | NUMBER | WIP Supply Type | ||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply Subinventory | |
SUPPLY_LOCATOR_ID | NUMBER | Supply locator Identifier | ||
VALID_SUBINVENTORY_FLAG | VARCHAR2 | (1) | Valid Subinventory Flag | |
VALID_LOCATOR_FLAG | VARCHAR2 | (1) | Valid Locator Flag | |
LOCATOR_SEGMENTS | VARCHAR2 | (240) | Locator Segments | |
CURRENT_LOCATOR_CONTROL_CODE | NUMBER | Current Locator Control Code | ||
NUMBER_OF_LOTS_ENTERED | NUMBER | Number of Lots Entered | ||
WIP_COMMIT_FLAG | VARCHAR2 | (1) | WIP Commit Flag | |
NEXT_LOT_NUMBER | VARCHAR2 | (80) | Next Lot Number | |
LOT_ALPHA_PREFIX | VARCHAR2 | (30) | LOT ALPHA Prefix | |
NEXT_SERIAL_NUMBER | VARCHAR2 | (30) | Next Serial NUmber | |
SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | Serial ALPHA Prefix | |
SHIPPABLE_FLAG | VARCHAR2 | (1) | Shippable Flag | |
POSTING_FLAG | VARCHAR2 | (1) | Post Flag | |
REQUIRED_FLAG | VARCHAR2 | (1) | Required Flag | |
PROCESS_FLAG | VARCHAR2 | (1) | Process Flag | |
ERROR_CODE | VARCHAR2 | (240) | Error Flag | |
ERROR_EXPLANATION | VARCHAR2 | (240) | Error Explanation | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
MOVEMENT_ID | NUMBER | Movent Identifier | ||
RESERVATION_QUANTITY | NUMBER | Reservation Quantity | ||
SHIPPED_QUANTITY | NUMBER | Shipped Quantity | ||
TRANSACTION_LINE_NUMBER | NUMBER | Transaction Line Number | ||
TASK_ID | NUMBER | (15) | Task Identifier | |
TO_TASK_ID | NUMBER | (15) | TO Task Identifier | |
SOURCE_TASK_ID | NUMBER | Source Task Identifier | ||
PROJECT_ID | NUMBER | (15) | Project identifier | |
SOURCE_PROJECT_ID | NUMBER | Source Project Identifier | ||
PA_EXPENDITURE_ORG_ID | NUMBER | PA Expenditure Org Udentifier | ||
TO_PROJECT_ID | NUMBER | (15) | To Project Identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure Type | |
FINAL_COMPLETION_FLAG | VARCHAR2 | (1) | Final Completion Flag | |
TRANSFER_PERCENTAGE | NUMBER | Transfer Percentage | ||
TRANSACTION_SEQUENCE_ID | NUMBER | Transaction Sequence Identifier | ||
MATERIAL_ACCOUNT | NUMBER | Material Account | ||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Material Overhead Account | ||
RESOURCE_ACCOUNT | NUMBER | REsource Account | ||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Outside Processing Account | ||
OVERHEAD_ACCOUNT | NUMBER | Overhead Account | ||
FLOW_SCHEDULE | VARCHAR2 | (1) | Flow Schedule | |
COST_GROUP_ID | NUMBER | Cost Group Identifier | ||
DEMAND_CLASS | VARCHAR2 | (30) | Demand Class | |
QA_COLLECTION_ID | NUMBER | QA Collection Identifier | ||
KANBAN_CARD_ID | NUMBER | KANBAN CARD Identifier | ||
OVERCOMPLETION_TRANSACTION_QTY | NUMBER | Overcompletion Transaction Quantity | ||
OVERCOMPLETION_PRIMARY_QTY | NUMBER | Overcompletion Primary Quantity | ||
OVERCOMPLETION_TRANSACTION_ID | NUMBER | Overcompletion Transaction Identifier | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (60) | END Item Unit Number | |
SCHEDULED_PAYBACK_DATE | DATE | Schedule Payback Date | ||
LINE_TYPE_CODE | NUMBER | Line Type Code | ||
PARENT_TRANSACTION_TEMP_ID | NUMBER | Parent Transaction Temp Identifier | ||
PUT_AWAY_STRATEGY_ID | NUMBER | Put Away Strategy Identifier | ||
PUT_AWAY_RULE_ID | NUMBER | Put Away Rule Identifier | ||
PICK_STRATEGY_ID | NUMBER | Pick Strategy Identifier | ||
PICK_RULE_ID | NUMBER | Pick Rule Identifier | ||
MOVE_ORDER_LINE_ID | NUMBER | Move Order Line Identifier | ||
TASK_GROUP_ID | NUMBER | Task Group Identifier | ||
PICK_SLIP_NUMBER | NUMBER | Pick Slip Number | ||
RESERVATION_ID | NUMBER | Reservation Identifier | ||
COMMON_BOM_SEQ_ID | NUMBER | Common BOM Seq Identifier | ||
COMMON_ROUTING_SEQ_ID | NUMBER | Common Routing Seq Identifier | ||
ORG_COST_GROUP_ID | NUMBER | Org Cost Group Identifier | ||
COST_TYPE_ID | NUMBER | Cost Type Identifier | ||
TRANSACTION_STATUS | NUMBER | Transaction Status | ||
STANDARD_OPERATION_ID | NUMBER | Standard Operation Identifier | ||
TASK_PRIORITY | NUMBER | Task Priority | ||
WMS_TASK_TYPE | NUMBER | WMS Task Type | ||
PARENT_LINE_ID | NUMBER | Parent Line Identifier | ||
SOURCE_LOT_NUMBER | VARCHAR2 | (80) | Source Lot Number | |
TRANSFER_COST_GROUP_ID | NUMBER | Transafer Cost Group Identifier | ||
LPN_ID | NUMBER | LPN Identifier | ||
TRANSFER_LPN_ID | NUMBER | Transfer LPN Identifier | ||
WMS_TASK_STATUS | NUMBER | WMS Task Status | ||
CONTENT_LPN_ID | NUMBER | Content LPN Identifier | ||
CONTAINER_ITEM_ID | NUMBER | Container Item Identifier | ||
CARTONIZATION_ID | NUMBER | Cartonization Identifier | ||
PICK_SLIP_DATE | DATE | Pick Slip Date | ||
REBUILD_ITEM_ID | NUMBER | Rebuild Item Identifier | ||
REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | Rebuild Serial Number | |
REBUILD_ACTIVITY_ID | NUMBER | Rebuild Activity Identifier | ||
REBUILD_JOB_NAME | VARCHAR2 | (240) | Rebuild JOb Name | |
ORGANIZATION_TYPE | NUMBER | Organization Type | ||
TRANSFER_ORGANIZATION_TYPE | NUMBER | Transfer Organization Type | ||
OWNING_ORGANIZATION_ID | NUMBER | Owning Organization Identifier | ||
OWNING_TP_TYPE | NUMBER | OWNING TP Type | ||
XFR_OWNING_ORGANIZATION_ID | NUMBER | Transfer Owning Organization Identifier | ||
TRANSFER_OWNING_TP_TYPE | NUMBER | Transfer Owning TP Type | ||
PLANNING_ORGANIZATION_ID | NUMBER | Planning Organization Identifier | ||
PLANNING_TP_TYPE | NUMBER | Planning TP Type | ||
XFR_PLANNING_ORGANIZATION_ID | NUMBER | Transfer Planning Organization Identifier | ||
TRANSFER_PLANNING_TP_TYPE | NUMBER | Transfer Planning TP Type | ||
SECONDARY_UOM_CODE | VARCHAR2 | (240) | Secondary UOM Code | |
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary Transaction Quantity | ||
TRANSACTION_GROUP_ID | NUMBER | Transaction Group Identifier | ||
TRANSACTION_GROUP_SEQ | NUMBER | Transaction Group Sequence | ||
ALLOCATED_LPN_ID | NUMBER | Allocated LPN Identifier | ||
SCHEDULE_NUMBER | VARCHAR2 | (30) | Schedule Number | |
SCHEDULED_FLAG | NUMBER | Schedule Flag | ||
CLASS_CODE | VARCHAR2 | (10) | Class Code | |
SCHEDULE_GROUP | NUMBER | Schedule Group | ||
BUILD_SEQUENCE | NUMBER | Build Sequence | ||
BOM_REVISION | VARCHAR2 | (3) | BOM Revision | |
ROUTING_REVISION | VARCHAR2 | (3) | Routing Revision | |
BOM_REVISION_DATE | DATE | BOM Revision Date | ||
ROUTING_REVISION_DATE | DATE | Routing Revision Date | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate BOM Designator | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate Routing Designator |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID
, SOURCE_CODE
, SOURCE_LINE_ID
, TRANSACTION_MODE
, LOCK_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, REVISION
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_COST
, TRANSACTION_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_NAME
, TRANSACTION_DATE
, ACCT_PERIOD_ID
, DISTRIBUTION_ACCOUNT_ID
, TRANSACTION_REFERENCE
, REQUISITION_LINE_ID
, REQUISITION_DISTRIBUTION_ID
, REASON_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, RECEIVING_DOCUMENT
, DEMAND_ID
, RCV_TRANSACTION_ID
, MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID
, WIP_ENTITY_TYPE
, SCHEDULE_ID
, REPETITIVE_LINE_ID
, EMPLOYEE_CODE
, PRIMARY_SWITCH
, SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE
, ITEM_ORDERING
, NEGATIVE_REQ_FLAG
, OPERATION_SEQ_NUM
, PICKING_LINE_ID
, TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID
, PHYSICAL_ADJUSTMENT_ID
, CYCLE_COUNT_ID
, RMA_LINE_ID
, CUSTOMER_SHIP_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, USSGL_TRANSACTION_CODE
, VENDOR_LOT_NUMBER
, ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT
, SHIP_TO_LOCATION
, SHIPMENT_NUMBER
, TRANSFER_COST
, TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT
, FREIGHT_CODE
, CONTAINERS
, WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE
, TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION
, TRANSFER_TO_LOCATION
, NEW_AVERAGE_COST
, VALUE_CHANGE
, PERCENTAGE_CHANGE
, MATERIAL_ALLOCATION_TEMP_ID
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, ITEM_SEGMENTS
, ITEM_DESCRIPTION
, ITEM_TRX_ENABLED_FLAG
, ITEM_LOCATION_CONTROL_CODE
, ITEM_RESTRICT_SUBINV_CODE
, ITEM_RESTRICT_LOCATORS_CODE
, ITEM_REVISION_QTY_CONTROL_CODE
, ITEM_PRIMARY_UOM_CODE
, ITEM_UOM_CLASS
, ITEM_SHELF_LIFE_CODE
, ITEM_SHELF_LIFE_DAYS
, ITEM_LOT_CONTROL_CODE
, ITEM_SERIAL_CONTROL_CODE
, ITEM_INVENTORY_ASSET_FLAG
, ALLOWED_UNITS_LOOKUP_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, VALID_SUBINVENTORY_FLAG
, VALID_LOCATOR_FLAG
, LOCATOR_SEGMENTS
, CURRENT_LOCATOR_CONTROL_CODE
, NUMBER_OF_LOTS_ENTERED
, WIP_COMMIT_FLAG
, NEXT_LOT_NUMBER
, LOT_ALPHA_PREFIX
, NEXT_SERIAL_NUMBER
, SERIAL_ALPHA_PREFIX
, SHIPPABLE_FLAG
, POSTING_FLAG
, REQUIRED_FLAG
, PROCESS_FLAG
, ERROR_CODE
, ERROR_EXPLANATION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MOVEMENT_ID
, RESERVATION_QUANTITY
, SHIPPED_QUANTITY
, TRANSACTION_LINE_NUMBER
, TASK_ID
, TO_TASK_ID
, SOURCE_TASK_ID
, PROJECT_ID
, SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID
, TO_PROJECT_ID
, EXPENDITURE_TYPE
, FINAL_COMPLETION_FLAG
, TRANSFER_PERCENTAGE
, TRANSACTION_SEQUENCE_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT
, FLOW_SCHEDULE
, COST_GROUP_ID
, DEMAND_CLASS
, QA_COLLECTION_ID
, KANBAN_CARD_ID
, OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_ID
, END_ITEM_UNIT_NUMBER
, SCHEDULED_PAYBACK_DATE
, LINE_TYPE_CODE
, PARENT_TRANSACTION_TEMP_ID
, PUT_AWAY_STRATEGY_ID
, PUT_AWAY_RULE_ID
, PICK_STRATEGY_ID
, PICK_RULE_ID
, MOVE_ORDER_LINE_ID
, TASK_GROUP_ID
, PICK_SLIP_NUMBER
, RESERVATION_ID
, COMMON_BOM_SEQ_ID
, COMMON_ROUTING_SEQ_ID
, ORG_COST_GROUP_ID
, COST_TYPE_ID
, TRANSACTION_STATUS
, STANDARD_OPERATION_ID
, TASK_PRIORITY
, WMS_TASK_TYPE
, PARENT_LINE_ID
, SOURCE_LOT_NUMBER
, TRANSFER_COST_GROUP_ID
, LPN_ID
, TRANSFER_LPN_ID
, WMS_TASK_STATUS
, CONTENT_LPN_ID
, CONTAINER_ITEM_ID
, CARTONIZATION_ID
, PICK_SLIP_DATE
, REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER
, REBUILD_ACTIVITY_ID
, REBUILD_JOB_NAME
, ORGANIZATION_TYPE
, TRANSFER_ORGANIZATION_TYPE
, OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE
, XFR_OWNING_ORGANIZATION_ID
, TRANSFER_OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE
, XFR_PLANNING_ORGANIZATION_ID
, TRANSFER_PLANNING_TP_TYPE
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, TRANSACTION_GROUP_ID
, TRANSACTION_GROUP_SEQ
, ALLOCATED_LPN_ID
, SCHEDULE_NUMBER
, SCHEDULED_FLAG
, CLASS_CODE
, SCHEDULE_GROUP
, BUILD_SEQUENCE
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
FROM WMS.WMS_MATERIAL_TXN_TRACE;
WMS.WMS_MATERIAL_TXN_TRACE does not reference any database object
WMS.WMS_MATERIAL_TXN_TRACE is referenced by following:
|
|
|