VIEW: INV.MTL_TRANSACTIONS_INTERFACE#

Source

View Text - Preformatted

select TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, SOURCE_CODE SOURCE_CODE, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_HEADER_ID SOURCE_HEADER_ID, PROCESS_FLAG PROCESS_FLAG, VALIDATION_REQUIRED VALIDATION_REQUIRED, TRANSACTION_MODE TRANSACTION_MODE, LOCK_FLAG LOCK_FLAG, 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, ITEM_SEGMENT1 ITEM_SEGMENT1, ITEM_SEGMENT2 ITEM_SEGMENT2, ITEM_SEGMENT3 ITEM_SEGMENT3, ITEM_SEGMENT4 ITEM_SEGMENT4, ITEM_SEGMENT5 ITEM_SEGMENT5, ITEM_SEGMENT6 ITEM_SEGMENT6, ITEM_SEGMENT7 ITEM_SEGMENT7, ITEM_SEGMENT8 ITEM_SEGMENT8, ITEM_SEGMENT9 ITEM_SEGMENT9, ITEM_SEGMENT10 ITEM_SEGMENT10, ITEM_SEGMENT11 ITEM_SEGMENT11, ITEM_SEGMENT12 ITEM_SEGMENT12, ITEM_SEGMENT13 ITEM_SEGMENT13, ITEM_SEGMENT14 ITEM_SEGMENT14, ITEM_SEGMENT15 ITEM_SEGMENT15, ITEM_SEGMENT16 ITEM_SEGMENT16, ITEM_SEGMENT17 ITEM_SEGMENT17, ITEM_SEGMENT18 ITEM_SEGMENT18, ITEM_SEGMENT19 ITEM_SEGMENT19, ITEM_SEGMENT20 ITEM_SEGMENT20, REVISION REVISION, ORGANIZATION_ID ORGANIZATION_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_DATE TRANSACTION_DATE, ACCT_PERIOD_ID ACCT_PERIOD_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, LOC_SEGMENT1 LOC_SEGMENT1, LOC_SEGMENT2 LOC_SEGMENT2, LOC_SEGMENT3 LOC_SEGMENT3, LOC_SEGMENT4 LOC_SEGMENT4, LOC_SEGMENT5 LOC_SEGMENT5, LOC_SEGMENT6 LOC_SEGMENT6, LOC_SEGMENT7 LOC_SEGMENT7, LOC_SEGMENT8 LOC_SEGMENT8, LOC_SEGMENT9 LOC_SEGMENT9, LOC_SEGMENT10 LOC_SEGMENT10, LOC_SEGMENT11 LOC_SEGMENT11, LOC_SEGMENT12 LOC_SEGMENT12, LOC_SEGMENT13 LOC_SEGMENT13, LOC_SEGMENT14 LOC_SEGMENT14, LOC_SEGMENT15 LOC_SEGMENT15, LOC_SEGMENT16 LOC_SEGMENT16, LOC_SEGMENT17 LOC_SEGMENT17, LOC_SEGMENT18 LOC_SEGMENT18, LOC_SEGMENT19 LOC_SEGMENT19, LOC_SEGMENT20 LOC_SEGMENT20, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, DSP_SEGMENT1 DSP_SEGMENT1, DSP_SEGMENT2 DSP_SEGMENT2, DSP_SEGMENT3 DSP_SEGMENT3, DSP_SEGMENT4 DSP_SEGMENT4, DSP_SEGMENT5 DSP_SEGMENT5, DSP_SEGMENT6 DSP_SEGMENT6, DSP_SEGMENT7 DSP_SEGMENT7, DSP_SEGMENT8 DSP_SEGMENT8, DSP_SEGMENT9 DSP_SEGMENT9, DSP_SEGMENT10 DSP_SEGMENT10, DSP_SEGMENT11 DSP_SEGMENT11, DSP_SEGMENT12 DSP_SEGMENT12, DSP_SEGMENT13 DSP_SEGMENT13, DSP_SEGMENT14 DSP_SEGMENT14, DSP_SEGMENT15 DSP_SEGMENT15, DSP_SEGMENT16 DSP_SEGMENT16, DSP_SEGMENT17 DSP_SEGMENT17, DSP_SEGMENT18 DSP_SEGMENT18, DSP_SEGMENT19 DSP_SEGMENT19, DSP_SEGMENT20 DSP_SEGMENT20, DSP_SEGMENT21 DSP_SEGMENT21, DSP_SEGMENT22 DSP_SEGMENT22, DSP_SEGMENT23 DSP_SEGMENT23, DSP_SEGMENT24 DSP_SEGMENT24, DSP_SEGMENT25 DSP_SEGMENT25, DSP_SEGMENT26 DSP_SEGMENT26, DSP_SEGMENT27 DSP_SEGMENT27, DSP_SEGMENT28 DSP_SEGMENT28, DSP_SEGMENT29 DSP_SEGMENT29, DSP_SEGMENT30 DSP_SEGMENT30, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, REASON_ID REASON_ID, TRANSACTION_REFERENCE TRANSACTION_REFERENCE, TRANSACTION_COST TRANSACTION_COST, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID, DST_SEGMENT1 DST_SEGMENT1, DST_SEGMENT2 DST_SEGMENT2, DST_SEGMENT3 DST_SEGMENT3, DST_SEGMENT4 DST_SEGMENT4, DST_SEGMENT5 DST_SEGMENT5, DST_SEGMENT6 DST_SEGMENT6, DST_SEGMENT7 DST_SEGMENT7, DST_SEGMENT8 DST_SEGMENT8, DST_SEGMENT9 DST_SEGMENT9, DST_SEGMENT10 DST_SEGMENT10, DST_SEGMENT11 DST_SEGMENT11, DST_SEGMENT12 DST_SEGMENT12, DST_SEGMENT13 DST_SEGMENT13, DST_SEGMENT14 DST_SEGMENT14, DST_SEGMENT15 DST_SEGMENT15, DST_SEGMENT16 DST_SEGMENT16, DST_SEGMENT17 DST_SEGMENT17, DST_SEGMENT18 DST_SEGMENT18, DST_SEGMENT19 DST_SEGMENT19, DST_SEGMENT20 DST_SEGMENT20, DST_SEGMENT21 DST_SEGMENT21, DST_SEGMENT22 DST_SEGMENT22, DST_SEGMENT23 DST_SEGMENT23, DST_SEGMENT24 DST_SEGMENT24, DST_SEGMENT25 DST_SEGMENT25, DST_SEGMENT26 DST_SEGMENT26, DST_SEGMENT27 DST_SEGMENT27, DST_SEGMENT28 DST_SEGMENT28, DST_SEGMENT29 DST_SEGMENT29, DST_SEGMENT30 DST_SEGMENT30, REQUISITION_LINE_ID REQUISITION_LINE_ID, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, WIP_ENTITY_TYPE WIP_ENTITY_TYPE, SCHEDULE_ID SCHEDULE_ID, EMPLOYEE_CODE EMPLOYEE_CODE, DEPARTMENT_ID DEPARTMENT_ID, SCHEDULE_UPDATE_CODE SCHEDULE_UPDATE_CODE, SETUP_TEARDOWN_CODE SETUP_TEARDOWN_CODE, PRIMARY_SWITCH PRIMARY_SWITCH, MRP_CODE MRP_CODE, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, REPETITIVE_LINE_ID REPETITIVE_LINE_ID, PICKING_LINE_ID PICKING_LINE_ID, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID, DEMAND_ID DEMAND_ID, CUSTOMER_SHIP_ID CUSTOMER_SHIP_ID, LINE_ITEM_NUM LINE_ITEM_NUM, RECEIVING_DOCUMENT RECEIVING_DOCUMENT, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION TRANSFER_ORGANIZATION, TRANSFER_LOCATOR TRANSFER_LOCATOR, XFER_LOC_SEGMENT1 XFER_LOC_SEGMENT1, XFER_LOC_SEGMENT2 XFER_LOC_SEGMENT2, XFER_LOC_SEGMENT3 XFER_LOC_SEGMENT3, XFER_LOC_SEGMENT4 XFER_LOC_SEGMENT4, XFER_LOC_SEGMENT5 XFER_LOC_SEGMENT5, XFER_LOC_SEGMENT6 XFER_LOC_SEGMENT6, XFER_LOC_SEGMENT7 XFER_LOC_SEGMENT7, XFER_LOC_SEGMENT8 XFER_LOC_SEGMENT8, XFER_LOC_SEGMENT9 XFER_LOC_SEGMENT9, XFER_LOC_SEGMENT10 XFER_LOC_SEGMENT10, XFER_LOC_SEGMENT11 XFER_LOC_SEGMENT11, XFER_LOC_SEGMENT12 XFER_LOC_SEGMENT12, XFER_LOC_SEGMENT13 XFER_LOC_SEGMENT13, XFER_LOC_SEGMENT14 XFER_LOC_SEGMENT14, XFER_LOC_SEGMENT15 XFER_LOC_SEGMENT15, XFER_LOC_SEGMENT16 XFER_LOC_SEGMENT16, XFER_LOC_SEGMENT17 XFER_LOC_SEGMENT17, XFER_LOC_SEGMENT18 XFER_LOC_SEGMENT18, XFER_LOC_SEGMENT19 XFER_LOC_SEGMENT19, XFER_LOC_SEGMENT20 XFER_LOC_SEGMENT20, SHIPMENT_NUMBER SHIPMENT_NUMBER, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSPORTATION_ACCOUNT TRANSPORTATION_ACCOUNT, TRANSFER_COST TRANSFER_COST, FREIGHT_CODE FREIGHT_CODE, CONTAINERS CONTAINERS, WAYBILL_AIRBILL WAYBILL_AIRBILL, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE, NEW_AVERAGE_COST NEW_AVERAGE_COST, VALUE_CHANGE VALUE_CHANGE, PERCENTAGE_CHANGE PERCENTAGE_CHANGE, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, NEGATIVE_REQ_FLAG NEGATIVE_REQ_FLAG, ERROR_EXPLANATION ERROR_EXPLANATION, SHIPPABLE_FLAG SHIPPABLE_FLAG, ERROR_CODE ERROR_CODE, REQUIRED_FLAG REQUIRED_FLAG, 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, REQUISITION_DISTRIBUTION_ID REQUISITION_DISTRIBUTION_ID, MOVEMENT_ID MOVEMENT_ID, RESERVATION_QUANTITY RESERVATION_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, INVENTORY_ITEM INVENTORY_ITEM, LOCATOR_NAME LOCATOR_NAME, TASK_ID TASK_ID, TO_TASK_ID TO_TASK_ID, SOURCE_TASK_ID SOURCE_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, EXPENDITURE_TYPE EXPENDITURE_TYPE, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE, TRANSACTION_SEQUENCE_ID TRANSACTION_SEQUENCE_ID, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT, BOM_REVISION BOM_REVISION, ROUTING_REVISION ROUTING_REVISION, BOM_REVISION_DATE BOM_REVISION_DATE, ROUTING_REVISION_DATE ROUTING_REVISION_DATE, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ACCOUNTING_CLASS ACCOUNTING_CLASS, DEMAND_CLASS DEMAND_CLASS, PARENT_ID PARENT_ID, SUBSTITUTION_TYPE_ID SUBSTITUTION_TYPE_ID, SUBSTITUTION_ITEM_ID SUBSTITUTION_ITEM_ID, SCHEDULE_GROUP SCHEDULE_GROUP, BUILD_SEQUENCE BUILD_SEQUENCE, SCHEDULE_NUMBER SCHEDULE_NUMBER, SCHEDULED_FLAG SCHEDULED_FLAG, FLOW_SCHEDULE FLOW_SCHEDULE, COST_GROUP_ID COST_GROUP_ID, KANBAN_CARD_ID KANBAN_CARD_ID, QA_COLLECTION_ID QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID OVERCOMPLETION_TRANSACTION_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, SCHEDULED_PAYBACK_DATE SCHEDULED_PAYBACK_DATE, ORG_COST_GROUP_ID ORG_COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, SOURCE_LOT_NUMBER SOURCE_LOT_NUMBER, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID, LPN_ID LPN_ID, TRANSFER_LPN_ID TRANSFER_LPN_ID, CONTENT_LPN_ID CONTENT_LPN_ID, XML_DOCUMENT_ID XML_DOCUMENT_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_ID TRANSACTION_GROUP_ID, TRANSACTION_GROUP_SEQ TRANSACTION_GROUP_SEQ, REPRESENTATIVE_LOT_NUMBER REPRESENTATIVE_LOT_NUMBER, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ, REBUILD_ITEM_ID REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER, REBUILD_ACTIVITY_ID REBUILD_ACTIVITY_ID, REBUILD_JOB_NAME REBUILD_JOB_NAME, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, RELIEVE_RESERVATIONS_FLAG RELIEVE_RESERVATIONS_FLAG, RELIEVE_HIGH_LEVEL_RSV_FLAG RELIEVE_HIGH_LEVEL_RSV_FLAG, TRANSFER_PRICE TRANSFER_PRICE, MATERIAL_EXPENSE_ACCOUNT MATERIAL_EXPENSE_ACCOUNT from "INV"."MTL_TRANSACTIONS_INTERFACE"

View Text - HTML Formatted

SELECT TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, PROCESS_FLAG PROCESS_FLAG
, VALIDATION_REQUIRED VALIDATION_REQUIRED
, TRANSACTION_MODE TRANSACTION_MODE
, LOCK_FLAG LOCK_FLAG
, 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
, ITEM_SEGMENT1 ITEM_SEGMENT1
, ITEM_SEGMENT2 ITEM_SEGMENT2
, ITEM_SEGMENT3 ITEM_SEGMENT3
, ITEM_SEGMENT4 ITEM_SEGMENT4
, ITEM_SEGMENT5 ITEM_SEGMENT5
, ITEM_SEGMENT6 ITEM_SEGMENT6
, ITEM_SEGMENT7 ITEM_SEGMENT7
, ITEM_SEGMENT8 ITEM_SEGMENT8
, ITEM_SEGMENT9 ITEM_SEGMENT9
, ITEM_SEGMENT10 ITEM_SEGMENT10
, ITEM_SEGMENT11 ITEM_SEGMENT11
, ITEM_SEGMENT12 ITEM_SEGMENT12
, ITEM_SEGMENT13 ITEM_SEGMENT13
, ITEM_SEGMENT14 ITEM_SEGMENT14
, ITEM_SEGMENT15 ITEM_SEGMENT15
, ITEM_SEGMENT16 ITEM_SEGMENT16
, ITEM_SEGMENT17 ITEM_SEGMENT17
, ITEM_SEGMENT18 ITEM_SEGMENT18
, ITEM_SEGMENT19 ITEM_SEGMENT19
, ITEM_SEGMENT20 ITEM_SEGMENT20
, REVISION REVISION
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_DATE TRANSACTION_DATE
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, LOC_SEGMENT1 LOC_SEGMENT1
, LOC_SEGMENT2 LOC_SEGMENT2
, LOC_SEGMENT3 LOC_SEGMENT3
, LOC_SEGMENT4 LOC_SEGMENT4
, LOC_SEGMENT5 LOC_SEGMENT5
, LOC_SEGMENT6 LOC_SEGMENT6
, LOC_SEGMENT7 LOC_SEGMENT7
, LOC_SEGMENT8 LOC_SEGMENT8
, LOC_SEGMENT9 LOC_SEGMENT9
, LOC_SEGMENT10 LOC_SEGMENT10
, LOC_SEGMENT11 LOC_SEGMENT11
, LOC_SEGMENT12 LOC_SEGMENT12
, LOC_SEGMENT13 LOC_SEGMENT13
, LOC_SEGMENT14 LOC_SEGMENT14
, LOC_SEGMENT15 LOC_SEGMENT15
, LOC_SEGMENT16 LOC_SEGMENT16
, LOC_SEGMENT17 LOC_SEGMENT17
, LOC_SEGMENT18 LOC_SEGMENT18
, LOC_SEGMENT19 LOC_SEGMENT19
, LOC_SEGMENT20 LOC_SEGMENT20
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, DSP_SEGMENT1 DSP_SEGMENT1
, DSP_SEGMENT2 DSP_SEGMENT2
, DSP_SEGMENT3 DSP_SEGMENT3
, DSP_SEGMENT4 DSP_SEGMENT4
, DSP_SEGMENT5 DSP_SEGMENT5
, DSP_SEGMENT6 DSP_SEGMENT6
, DSP_SEGMENT7 DSP_SEGMENT7
, DSP_SEGMENT8 DSP_SEGMENT8
, DSP_SEGMENT9 DSP_SEGMENT9
, DSP_SEGMENT10 DSP_SEGMENT10
, DSP_SEGMENT11 DSP_SEGMENT11
, DSP_SEGMENT12 DSP_SEGMENT12
, DSP_SEGMENT13 DSP_SEGMENT13
, DSP_SEGMENT14 DSP_SEGMENT14
, DSP_SEGMENT15 DSP_SEGMENT15
, DSP_SEGMENT16 DSP_SEGMENT16
, DSP_SEGMENT17 DSP_SEGMENT17
, DSP_SEGMENT18 DSP_SEGMENT18
, DSP_SEGMENT19 DSP_SEGMENT19
, DSP_SEGMENT20 DSP_SEGMENT20
, DSP_SEGMENT21 DSP_SEGMENT21
, DSP_SEGMENT22 DSP_SEGMENT22
, DSP_SEGMENT23 DSP_SEGMENT23
, DSP_SEGMENT24 DSP_SEGMENT24
, DSP_SEGMENT25 DSP_SEGMENT25
, DSP_SEGMENT26 DSP_SEGMENT26
, DSP_SEGMENT27 DSP_SEGMENT27
, DSP_SEGMENT28 DSP_SEGMENT28
, DSP_SEGMENT29 DSP_SEGMENT29
, DSP_SEGMENT30 DSP_SEGMENT30
, TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, REASON_ID REASON_ID
, TRANSACTION_REFERENCE TRANSACTION_REFERENCE
, TRANSACTION_COST TRANSACTION_COST
, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID
, DST_SEGMENT1 DST_SEGMENT1
, DST_SEGMENT2 DST_SEGMENT2
, DST_SEGMENT3 DST_SEGMENT3
, DST_SEGMENT4 DST_SEGMENT4
, DST_SEGMENT5 DST_SEGMENT5
, DST_SEGMENT6 DST_SEGMENT6
, DST_SEGMENT7 DST_SEGMENT7
, DST_SEGMENT8 DST_SEGMENT8
, DST_SEGMENT9 DST_SEGMENT9
, DST_SEGMENT10 DST_SEGMENT10
, DST_SEGMENT11 DST_SEGMENT11
, DST_SEGMENT12 DST_SEGMENT12
, DST_SEGMENT13 DST_SEGMENT13
, DST_SEGMENT14 DST_SEGMENT14
, DST_SEGMENT15 DST_SEGMENT15
, DST_SEGMENT16 DST_SEGMENT16
, DST_SEGMENT17 DST_SEGMENT17
, DST_SEGMENT18 DST_SEGMENT18
, DST_SEGMENT19 DST_SEGMENT19
, DST_SEGMENT20 DST_SEGMENT20
, DST_SEGMENT21 DST_SEGMENT21
, DST_SEGMENT22 DST_SEGMENT22
, DST_SEGMENT23 DST_SEGMENT23
, DST_SEGMENT24 DST_SEGMENT24
, DST_SEGMENT25 DST_SEGMENT25
, DST_SEGMENT26 DST_SEGMENT26
, DST_SEGMENT27 DST_SEGMENT27
, DST_SEGMENT28 DST_SEGMENT28
, DST_SEGMENT29 DST_SEGMENT29
, DST_SEGMENT30 DST_SEGMENT30
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, SCHEDULE_ID SCHEDULE_ID
, EMPLOYEE_CODE EMPLOYEE_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, SCHEDULE_UPDATE_CODE SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE SETUP_TEARDOWN_CODE
, PRIMARY_SWITCH PRIMARY_SWITCH
, MRP_CODE MRP_CODE
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, REPETITIVE_LINE_ID REPETITIVE_LINE_ID
, PICKING_LINE_ID PICKING_LINE_ID
, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID
, DEMAND_ID DEMAND_ID
, CUSTOMER_SHIP_ID CUSTOMER_SHIP_ID
, LINE_ITEM_NUM LINE_ITEM_NUM
, RECEIVING_DOCUMENT RECEIVING_DOCUMENT
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION TRANSFER_ORGANIZATION
, TRANSFER_LOCATOR TRANSFER_LOCATOR
, XFER_LOC_SEGMENT1 XFER_LOC_SEGMENT1
, XFER_LOC_SEGMENT2 XFER_LOC_SEGMENT2
, XFER_LOC_SEGMENT3 XFER_LOC_SEGMENT3
, XFER_LOC_SEGMENT4 XFER_LOC_SEGMENT4
, XFER_LOC_SEGMENT5 XFER_LOC_SEGMENT5
, XFER_LOC_SEGMENT6 XFER_LOC_SEGMENT6
, XFER_LOC_SEGMENT7 XFER_LOC_SEGMENT7
, XFER_LOC_SEGMENT8 XFER_LOC_SEGMENT8
, XFER_LOC_SEGMENT9 XFER_LOC_SEGMENT9
, XFER_LOC_SEGMENT10 XFER_LOC_SEGMENT10
, XFER_LOC_SEGMENT11 XFER_LOC_SEGMENT11
, XFER_LOC_SEGMENT12 XFER_LOC_SEGMENT12
, XFER_LOC_SEGMENT13 XFER_LOC_SEGMENT13
, XFER_LOC_SEGMENT14 XFER_LOC_SEGMENT14
, XFER_LOC_SEGMENT15 XFER_LOC_SEGMENT15
, XFER_LOC_SEGMENT16 XFER_LOC_SEGMENT16
, XFER_LOC_SEGMENT17 XFER_LOC_SEGMENT17
, XFER_LOC_SEGMENT18 XFER_LOC_SEGMENT18
, XFER_LOC_SEGMENT19 XFER_LOC_SEGMENT19
, XFER_LOC_SEGMENT20 XFER_LOC_SEGMENT20
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT TRANSPORTATION_ACCOUNT
, TRANSFER_COST TRANSFER_COST
, FREIGHT_CODE FREIGHT_CODE
, CONTAINERS CONTAINERS
, WAYBILL_AIRBILL WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE
, NEW_AVERAGE_COST NEW_AVERAGE_COST
, VALUE_CHANGE VALUE_CHANGE
, PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, NEGATIVE_REQ_FLAG NEGATIVE_REQ_FLAG
, ERROR_EXPLANATION ERROR_EXPLANATION
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, ERROR_CODE ERROR_CODE
, REQUIRED_FLAG REQUIRED_FLAG
, 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
, REQUISITION_DISTRIBUTION_ID REQUISITION_DISTRIBUTION_ID
, MOVEMENT_ID MOVEMENT_ID
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, INVENTORY_ITEM INVENTORY_ITEM
, LOCATOR_NAME LOCATOR_NAME
, TASK_ID TASK_ID
, TO_TASK_ID TO_TASK_ID
, SOURCE_TASK_ID SOURCE_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
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG
, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE
, TRANSACTION_SEQUENCE_ID TRANSACTION_SEQUENCE_ID
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, BOM_REVISION BOM_REVISION
, ROUTING_REVISION ROUTING_REVISION
, BOM_REVISION_DATE BOM_REVISION_DATE
, ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ACCOUNTING_CLASS ACCOUNTING_CLASS
, DEMAND_CLASS DEMAND_CLASS
, PARENT_ID PARENT_ID
, SUBSTITUTION_TYPE_ID SUBSTITUTION_TYPE_ID
, SUBSTITUTION_ITEM_ID SUBSTITUTION_ITEM_ID
, SCHEDULE_GROUP SCHEDULE_GROUP
, BUILD_SEQUENCE BUILD_SEQUENCE
, SCHEDULE_NUMBER SCHEDULE_NUMBER
, SCHEDULED_FLAG SCHEDULED_FLAG
, FLOW_SCHEDULE FLOW_SCHEDULE
, COST_GROUP_ID COST_GROUP_ID
, KANBAN_CARD_ID KANBAN_CARD_ID
, QA_COLLECTION_ID QA_COLLECTION_ID
, OVERCOMPLETION_TRANSACTION_QTY OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_ID OVERCOMPLETION_TRANSACTION_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, SCHEDULED_PAYBACK_DATE SCHEDULED_PAYBACK_DATE
, ORG_COST_GROUP_ID ORG_COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, SOURCE_LOT_NUMBER SOURCE_LOT_NUMBER
, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID
, LPN_ID LPN_ID
, TRANSFER_LPN_ID TRANSFER_LPN_ID
, CONTENT_LPN_ID CONTENT_LPN_ID
, XML_DOCUMENT_ID XML_DOCUMENT_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_ID TRANSACTION_GROUP_ID
, TRANSACTION_GROUP_SEQ TRANSACTION_GROUP_SEQ
, REPRESENTATIVE_LOT_NUMBER REPRESENTATIVE_LOT_NUMBER
, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID
, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ
, REBUILD_ITEM_ID REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER
, REBUILD_ACTIVITY_ID REBUILD_ACTIVITY_ID
, REBUILD_JOB_NAME REBUILD_JOB_NAME
, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, RELIEVE_RESERVATIONS_FLAG RELIEVE_RESERVATIONS_FLAG
, RELIEVE_HIGH_LEVEL_RSV_FLAG RELIEVE_HIGH_LEVEL_RSV_FLAG
, TRANSFER_PRICE TRANSFER_PRICE
, MATERIAL_EXPENSE_ACCOUNT MATERIAL_EXPENSE_ACCOUNT
FROM "INV"."MTL_TRANSACTIONS_INTERFACE"