DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_MATERIAL_TXN_TRACE

Object Details
Object Name: WMS_MATERIAL_TXN_TRACE
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_MATERIAL_TXN_TRACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMOVE_ORDER_LINE_ID
WMS_MATERIAL_TXN_TRACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_TEMP_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

WMS.WMS_MATERIAL_TXN_TRACE does not reference any database object

WMS.WMS_MATERIAL_TXN_TRACE is referenced by following:

SchemaAPPS
SynonymWMS_MATERIAL_TXN_TRACE