VIEW: INV.MTL_MATERIAL_TRANSACTIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_DATE TRANSACTION_DATE, VARIANCE_AMOUNT VARIANCE_AMOUNT, ACCT_PERIOD_ID ACCT_PERIOD_ID, TRANSACTION_REFERENCE TRANSACTION_REFERENCE, REASON_ID REASON_ID, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, COST_UPDATE_ID COST_UPDATE_ID, COSTED_FLAG COSTED_FLAG, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID, INVOICED_FLAG INVOICED_FLAG, ACTUAL_COST ACTUAL_COST, TRANSACTION_COST TRANSACTION_COST, PRIOR_COST PRIOR_COST, NEW_COST NEW_COST, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, QUANTITY_ADJUSTED QUANTITY_ADJUSTED, EMPLOYEE_CODE EMPLOYEE_CODE, DEPARTMENT_ID DEPARTMENT_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, MASTER_SCHEDULE_UPDATE_CODE MASTER_SCHEDULE_UPDATE_CODE, RECEIVING_DOCUMENT RECEIVING_DOCUMENT, PICKING_LINE_ID PICKING_LINE_ID, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID, REPETITIVE_LINE_ID REPETITIVE_LINE_ID, PHYSICAL_ADJUSTMENT_ID PHYSICAL_ADJUSTMENT_ID, CYCLE_COUNT_ID CYCLE_COUNT_ID, RMA_LINE_ID RMA_LINE_ID, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID, TRANSACTION_SET_ID TRANSACTION_SET_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, SHORTAGE_PROCESS_CODE SHORTAGE_PROCESS_CODE, SOURCE_CODE SOURCE_CODE, SOURCE_LINE_ID SOURCE_LINE_ID, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID, SHIPMENT_NUMBER SHIPMENT_NUMBER, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_DIST_ACCOUNT TRANSPORTATION_DIST_ACCOUNT, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSFER_COST_DIST_ACCOUNT TRANSFER_COST_DIST_ACCOUNT, WAYBILL_AIRBILL WAYBILL_AIRBILL, FREIGHT_CODE FREIGHT_CODE, NUMBER_OF_CONTAINERS NUMBER_OF_CONTAINERS, VALUE_CHANGE VALUE_CHANGE, PERCENTAGE_CHANGE PERCENTAGE_CHANGE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, MOVEMENT_ID MOVEMENT_ID, TASK_ID TASK_ID, TO_TASK_ID TO_TASK_ID, PROJECT_ID PROJECT_ID, TO_PROJECT_ID TO_PROJECT_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, PA_EXPENDITURE_ORG_ID PA_EXPENDITURE_ORG_ID, SOURCE_TASK_ID SOURCE_TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, ERROR_CODE ERROR_CODE, ERROR_EXPLANATION ERROR_EXPLANATION, PRIOR_COSTED_QUANTITY PRIOR_COSTED_QUANTITY, TRANSFER_PRIOR_COSTED_QUANTITY TRANSFER_PRIOR_COSTED_QUANTITY, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG, PM_COST_COLLECTED PM_COST_COLLECTED, PM_COST_COLLECTOR_GROUP_ID PM_COST_COLLECTOR_GROUP_ID, SHIPMENT_COSTED SHIPMENT_COSTED, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT, COST_GROUP_ID COST_GROUP_ID, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID, FLOW_SCHEDULE FLOW_SCHEDULE, QA_COLLECTION_ID QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID OVERCOMPLETION_TRANSACTION_ID, MVT_STAT_STATUS MVT_STAT_STATUS, COMMON_BOM_SEQ_ID COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID COMMON_ROUTING_SEQ_ID, ORG_COST_GROUP_ID ORG_COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, PERIODIC_PRIMARY_QUANTITY PERIODIC_PRIMARY_QUANTITY, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID, TASK_GROUP_ID TASK_GROUP_ID, PICK_SLIP_NUMBER PICK_SLIP_NUMBER, LPN_ID LPN_ID, TRANSFER_LPN_ID TRANSFER_LPN_ID, PICK_STRATEGY_ID PICK_STRATEGY_ID, PICK_RULE_ID PICK_RULE_ID, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID, CONTENT_LPN_ID CONTENT_LPN_ID, PICK_SLIP_DATE PICK_SLIP_DATE, COST_CATEGORY_ID COST_CATEGORY_ID, ORGANIZATION_TYPE ORGANIZATION_TYPE, TRANSFER_ORGANIZATION_TYPE TRANSFER_ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, OWNING_TP_TYPE OWNING_TP_TYPE, XFR_OWNING_ORGANIZATION_ID XFR_OWNING_ORGANIZATION_ID, TRANSFER_OWNING_TP_TYPE TRANSFER_OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, XFR_PLANNING_ORGANIZATION_ID XFR_PLANNING_ORGANIZATION_ID, TRANSFER_PLANNING_TP_TYPE TRANSFER_PLANNING_TP_TYPE, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY, TRANSACTION_GROUP_SEQ TRANSACTION_GROUP_SEQ, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, RESERVATION_ID RESERVATION_ID, TRANSACTION_MODE TRANSACTION_MODE, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ, INTRANSIT_ACCOUNT INTRANSIT_ACCOUNT, FOB_POINT FOB_POINT, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, LOGICAL_TRX_TYPE_CODE LOGICAL_TRX_TYPE_CODE, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID, LOGICAL_TRANSACTIONS_CREATED LOGICAL_TRANSACTIONS_CREATED, LOGICAL_TRANSACTION LOGICAL_TRANSACTION, INTERCOMPANY_COST INTERCOMPANY_COST, INTERCOMPANY_PRICING_OPTION INTERCOMPANY_PRICING_OPTION, INTERCOMPANY_CURRENCY_CODE INTERCOMPANY_CURRENCY_CODE, ORIGINAL_TRANSACTION_TEMP_ID ORIGINAL_TRANSACTION_TEMP_ID, TRANSFER_PRICE TRANSFER_PRICE, EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID, COGS_RECOGNITION_PERCENT COGS_RECOGNITION_PERCENT, SO_ISSUE_ACCOUNT_TYPE SO_ISSUE_ACCOUNT_TYPE, OPM_COSTED_FLAG OPM_COSTED_FLAG, MATERIAL_EXPENSE_ACCOUNT MATERIAL_EXPENSE_ACCOUNT, TRANSACTION_EXTRACTED TRANSACTION_EXTRACTED, XML_DOCUMENT_ID XML_DOCUMENT_ID from "INV"."MTL_MATERIAL_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_DATE TRANSACTION_DATE
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, TRANSACTION_REFERENCE TRANSACTION_REFERENCE
, REASON_ID REASON_ID
, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, COST_UPDATE_ID COST_UPDATE_ID
, COSTED_FLAG COSTED_FLAG
, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
, INVOICED_FLAG INVOICED_FLAG
, ACTUAL_COST ACTUAL_COST
, TRANSACTION_COST TRANSACTION_COST
, PRIOR_COST PRIOR_COST
, NEW_COST NEW_COST
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, QUANTITY_ADJUSTED QUANTITY_ADJUSTED
, EMPLOYEE_CODE EMPLOYEE_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, MASTER_SCHEDULE_UPDATE_CODE MASTER_SCHEDULE_UPDATE_CODE
, RECEIVING_DOCUMENT RECEIVING_DOCUMENT
, PICKING_LINE_ID PICKING_LINE_ID
, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID
, REPETITIVE_LINE_ID REPETITIVE_LINE_ID
, PHYSICAL_ADJUSTMENT_ID PHYSICAL_ADJUSTMENT_ID
, CYCLE_COUNT_ID CYCLE_COUNT_ID
, RMA_LINE_ID RMA_LINE_ID
, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID
, TRANSACTION_SET_ID TRANSACTION_SET_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, SHORTAGE_PROCESS_CODE SHORTAGE_PROCESS_CODE
, SOURCE_CODE SOURCE_CODE
, SOURCE_LINE_ID SOURCE_LINE_ID
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_DIST_ACCOUNT TRANSPORTATION_DIST_ACCOUNT
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSFER_COST_DIST_ACCOUNT TRANSFER_COST_DIST_ACCOUNT
, WAYBILL_AIRBILL WAYBILL_AIRBILL
, FREIGHT_CODE FREIGHT_CODE
, NUMBER_OF_CONTAINERS NUMBER_OF_CONTAINERS
, VALUE_CHANGE VALUE_CHANGE
, PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, MOVEMENT_ID MOVEMENT_ID
, TASK_ID TASK_ID
, TO_TASK_ID TO_TASK_ID
, PROJECT_ID PROJECT_ID
, TO_PROJECT_ID TO_PROJECT_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID PA_EXPENDITURE_ORG_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, ERROR_CODE ERROR_CODE
, ERROR_EXPLANATION ERROR_EXPLANATION
, PRIOR_COSTED_QUANTITY PRIOR_COSTED_QUANTITY
, TRANSFER_PRIOR_COSTED_QUANTITY TRANSFER_PRIOR_COSTED_QUANTITY
, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG
, PM_COST_COLLECTED PM_COST_COLLECTED
, PM_COST_COLLECTOR_GROUP_ID PM_COST_COLLECTOR_GROUP_ID
, SHIPMENT_COSTED SHIPMENT_COSTED
, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, COST_GROUP_ID COST_GROUP_ID
, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID
, FLOW_SCHEDULE FLOW_SCHEDULE
, QA_COLLECTION_ID QA_COLLECTION_ID
, OVERCOMPLETION_TRANSACTION_QTY OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_ID OVERCOMPLETION_TRANSACTION_ID
, MVT_STAT_STATUS MVT_STAT_STATUS
, COMMON_BOM_SEQ_ID COMMON_BOM_SEQ_ID
, COMMON_ROUTING_SEQ_ID COMMON_ROUTING_SEQ_ID
, ORG_COST_GROUP_ID ORG_COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, PERIODIC_PRIMARY_QUANTITY PERIODIC_PRIMARY_QUANTITY
, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, TASK_GROUP_ID TASK_GROUP_ID
, PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, LPN_ID LPN_ID
, TRANSFER_LPN_ID TRANSFER_LPN_ID
, PICK_STRATEGY_ID PICK_STRATEGY_ID
, PICK_RULE_ID PICK_RULE_ID
, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID
, CONTENT_LPN_ID CONTENT_LPN_ID
, PICK_SLIP_DATE PICK_SLIP_DATE
, COST_CATEGORY_ID COST_CATEGORY_ID
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, TRANSFER_ORGANIZATION_TYPE TRANSFER_ORGANIZATION_TYPE
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE OWNING_TP_TYPE
, XFR_OWNING_ORGANIZATION_ID XFR_OWNING_ORGANIZATION_ID
, TRANSFER_OWNING_TP_TYPE TRANSFER_OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE PLANNING_TP_TYPE
, XFR_PLANNING_ORGANIZATION_ID XFR_PLANNING_ORGANIZATION_ID
, TRANSFER_PLANNING_TP_TYPE TRANSFER_PLANNING_TP_TYPE
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY
, TRANSACTION_GROUP_SEQ TRANSACTION_GROUP_SEQ
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, RESERVATION_ID RESERVATION_ID
, TRANSACTION_MODE TRANSACTION_MODE
, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID
, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ
, INTRANSIT_ACCOUNT INTRANSIT_ACCOUNT
, FOB_POINT FOB_POINT
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, LOGICAL_TRX_TYPE_CODE LOGICAL_TRX_TYPE_CODE
, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID
, LOGICAL_TRANSACTIONS_CREATED LOGICAL_TRANSACTIONS_CREATED
, LOGICAL_TRANSACTION LOGICAL_TRANSACTION
, INTERCOMPANY_COST INTERCOMPANY_COST
, INTERCOMPANY_PRICING_OPTION INTERCOMPANY_PRICING_OPTION
, INTERCOMPANY_CURRENCY_CODE INTERCOMPANY_CURRENCY_CODE
, ORIGINAL_TRANSACTION_TEMP_ID ORIGINAL_TRANSACTION_TEMP_ID
, TRANSFER_PRICE TRANSFER_PRICE
, EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID
, COGS_RECOGNITION_PERCENT COGS_RECOGNITION_PERCENT
, SO_ISSUE_ACCOUNT_TYPE SO_ISSUE_ACCOUNT_TYPE
, OPM_COSTED_FLAG OPM_COSTED_FLAG
, MATERIAL_EXPENSE_ACCOUNT MATERIAL_EXPENSE_ACCOUNT
, TRANSACTION_EXTRACTED TRANSACTION_EXTRACTED
, XML_DOCUMENT_ID XML_DOCUMENT_ID
FROM "INV"."MTL_MATERIAL_TRANSACTIONS"