VIEW: INV.MTL_MATERIAL_TRANSACTIONS_TEM#

Source

View Text - Preformatted

select TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID, SOURCE_CODE SOURCE_CODE, SOURCE_LINE_ID SOURCE_LINE_ID, 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, REVISION REVISION, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_COST TRANSACTION_COST, 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_DATE TRANSACTION_DATE, ACCT_PERIOD_ID ACCT_PERIOD_ID, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID, TRANSACTION_REFERENCE TRANSACTION_REFERENCE, REQUISITION_LINE_ID REQUISITION_LINE_ID, REQUISITION_DISTRIBUTION_ID REQUISITION_DISTRIBUTION_ID, REASON_ID REASON_ID, LOT_NUMBER LOT_NUMBER, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE, SERIAL_NUMBER SERIAL_NUMBER, RECEIVING_DOCUMENT RECEIVING_DOCUMENT, DEMAND_ID DEMAND_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, WIP_ENTITY_TYPE WIP_ENTITY_TYPE, SCHEDULE_ID SCHEDULE_ID, REPETITIVE_LINE_ID REPETITIVE_LINE_ID, EMPLOYEE_CODE EMPLOYEE_CODE, PRIMARY_SWITCH PRIMARY_SWITCH, SCHEDULE_UPDATE_CODE SCHEDULE_UPDATE_CODE, SETUP_TEARDOWN_CODE SETUP_TEARDOWN_CODE, ITEM_ORDERING ITEM_ORDERING, NEGATIVE_REQ_FLAG NEGATIVE_REQ_FLAG, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, PICKING_LINE_ID PICKING_LINE_ID, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID, PHYSICAL_ADJUSTMENT_ID PHYSICAL_ADJUSTMENT_ID, CYCLE_COUNT_ID CYCLE_COUNT_ID, RMA_LINE_ID RMA_LINE_ID, CUSTOMER_SHIP_ID CUSTOMER_SHIP_ID, 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, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, SHIP_TO_LOCATION SHIP_TO_LOCATION, SHIPMENT_NUMBER SHIPMENT_NUMBER, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSPORTATION_ACCOUNT TRANSPORTATION_ACCOUNT, FREIGHT_CODE FREIGHT_CODE, CONTAINERS CONTAINERS, WAYBILL_AIRBILL WAYBILL_AIRBILL, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION TRANSFER_ORGANIZATION, TRANSFER_TO_LOCATION TRANSFER_TO_LOCATION, NEW_AVERAGE_COST NEW_AVERAGE_COST, VALUE_CHANGE VALUE_CHANGE, PERCENTAGE_CHANGE PERCENTAGE_CHANGE, MATERIAL_ALLOCATION_TEMP_ID MATERIAL_ALLOCATION_TEMP_ID, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, ITEM_SEGMENTS ITEM_SEGMENTS, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_TRX_ENABLED_FLAG ITEM_TRX_ENABLED_FLAG, ITEM_LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE, ITEM_RESTRICT_SUBINV_CODE ITEM_RESTRICT_SUBINV_CODE, ITEM_RESTRICT_LOCATORS_CODE ITEM_RESTRICT_LOCATORS_CODE, ITEM_REVISION_QTY_CONTROL_CODE ITEM_REVISION_QTY_CONTROL_CODE, ITEM_PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE, ITEM_UOM_CLASS ITEM_UOM_CLASS, ITEM_SHELF_LIFE_CODE ITEM_SHELF_LIFE_CODE, ITEM_SHELF_LIFE_DAYS ITEM_SHELF_LIFE_DAYS, ITEM_LOT_CONTROL_CODE ITEM_LOT_CONTROL_CODE, ITEM_SERIAL_CONTROL_CODE ITEM_SERIAL_CONTROL_CODE, ITEM_INVENTORY_ASSET_FLAG ITEM_INVENTORY_ASSET_FLAG, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, VALID_SUBINVENTORY_FLAG VALID_SUBINVENTORY_FLAG, VALID_LOCATOR_FLAG VALID_LOCATOR_FLAG, LOCATOR_SEGMENTS LOCATOR_SEGMENTS, CURRENT_LOCATOR_CONTROL_CODE CURRENT_LOCATOR_CONTROL_CODE, NUMBER_OF_LOTS_ENTERED NUMBER_OF_LOTS_ENTERED, WIP_COMMIT_FLAG WIP_COMMIT_FLAG, NEXT_LOT_NUMBER NEXT_LOT_NUMBER, LOT_ALPHA_PREFIX LOT_ALPHA_PREFIX, NEXT_SERIAL_NUMBER NEXT_SERIAL_NUMBER, SERIAL_ALPHA_PREFIX SERIAL_ALPHA_PREFIX, SHIPPABLE_FLAG SHIPPABLE_FLAG, POSTING_FLAG POSTING_FLAG, REQUIRED_FLAG REQUIRED_FLAG, PROCESS_FLAG PROCESS_FLAG, ERROR_CODE ERROR_CODE, ERROR_EXPLANATION ERROR_EXPLANATION, 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, RESERVATION_QUANTITY RESERVATION_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, TRANSACTION_LINE_NUMBER TRANSACTION_LINE_NUMBER, TASK_ID TASK_ID, TO_TASK_ID TO_TASK_ID, SOURCE_TASK_ID SOURCE_TASK_ID, PROJECT_ID PROJECT_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, PA_EXPENDITURE_ORG_ID PA_EXPENDITURE_ORG_ID, TO_PROJECT_ID TO_PROJECT_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, FLOW_SCHEDULE FLOW_SCHEDULE, COST_GROUP_ID COST_GROUP_ID, DEMAND_CLASS DEMAND_CLASS, QA_COLLECTION_ID QA_COLLECTION_ID, KANBAN_CARD_ID KANBAN_CARD_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, LINE_TYPE_CODE LINE_TYPE_CODE, PARENT_TRANSACTION_TEMP_ID PARENT_TRANSACTION_TEMP_ID, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID, PICK_STRATEGY_ID PICK_STRATEGY_ID, PICK_RULE_ID PICK_RULE_ID, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID, TASK_GROUP_ID TASK_GROUP_ID, PICK_SLIP_NUMBER PICK_SLIP_NUMBER, RESERVATION_ID RESERVATION_ID, 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, TRANSACTION_STATUS TRANSACTION_STATUS, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, TASK_PRIORITY TASK_PRIORITY, WMS_TASK_TYPE WMS_TASK_TYPE, PARENT_LINE_ID PARENT_LINE_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, WMS_TASK_STATUS WMS_TASK_STATUS, CONTENT_LPN_ID CONTENT_LPN_ID, CONTAINER_ITEM_ID CONTAINER_ITEM_ID, CARTONIZATION_ID CARTONIZATION_ID, PICK_SLIP_DATE PICK_SLIP_DATE, REBUILD_ITEM_ID REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER, REBUILD_ACTIVITY_ID REBUILD_ACTIVITY_ID, REBUILD_JOB_NAME REBUILD_JOB_NAME, 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, ALLOCATED_LPN_ID ALLOCATED_LPN_ID, SCHEDULE_NUMBER SCHEDULE_NUMBER, SCHEDULED_FLAG SCHEDULED_FLAG, CLASS_CODE CLASS_CODE, SCHEDULE_GROUP SCHEDULE_GROUP, BUILD_SEQUENCE BUILD_SEQUENCE, 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, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ, OPERATION_PLAN_ID OPERATION_PLAN_ID, INTRANSIT_ACCOUNT INTRANSIT_ACCOUNT, FOB_POINT FOB_POINT, MOVE_ORDER_HEADER_ID MOVE_ORDER_HEADER_ID, SERIAL_ALLOCATED_FLAG SERIAL_ALLOCATED_FLAG, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID, LOGICAL_TRX_TYPE_CODE LOGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID ORIGINAL_TRANSACTION_TEMP_ID, TRANSFER_SECONDARY_QUANTITY TRANSFER_SECONDARY_QUANTITY, TRANSFER_SECONDARY_UOM TRANSFER_SECONDARY_UOM, 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, FULFILLMENT_BASE FULFILLMENT_BASE from "INV"."MTL_MATERIAL_TRANSACTIONS_TEMP"

View Text - HTML Formatted

SELECT TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_LINE_ID SOURCE_LINE_ID
, 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
, REVISION REVISION
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_COST TRANSACTION_COST
, 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_DATE TRANSACTION_DATE
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID
, TRANSACTION_REFERENCE TRANSACTION_REFERENCE
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQUISITION_DISTRIBUTION_ID REQUISITION_DISTRIBUTION_ID
, REASON_ID REASON_ID
, LOT_NUMBER LOT_NUMBER
, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, RECEIVING_DOCUMENT RECEIVING_DOCUMENT
, DEMAND_ID DEMAND_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, SCHEDULE_ID SCHEDULE_ID
, REPETITIVE_LINE_ID REPETITIVE_LINE_ID
, EMPLOYEE_CODE EMPLOYEE_CODE
, PRIMARY_SWITCH PRIMARY_SWITCH
, SCHEDULE_UPDATE_CODE SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE SETUP_TEARDOWN_CODE
, ITEM_ORDERING ITEM_ORDERING
, NEGATIVE_REQ_FLAG NEGATIVE_REQ_FLAG
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, PICKING_LINE_ID PICKING_LINE_ID
, TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID
, PHYSICAL_ADJUSTMENT_ID PHYSICAL_ADJUSTMENT_ID
, CYCLE_COUNT_ID CYCLE_COUNT_ID
, RMA_LINE_ID RMA_LINE_ID
, CUSTOMER_SHIP_ID CUSTOMER_SHIP_ID
, 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
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT TRANSPORTATION_ACCOUNT
, FREIGHT_CODE FREIGHT_CODE
, CONTAINERS CONTAINERS
, WAYBILL_AIRBILL WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE
, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION TRANSFER_ORGANIZATION
, TRANSFER_TO_LOCATION TRANSFER_TO_LOCATION
, NEW_AVERAGE_COST NEW_AVERAGE_COST
, VALUE_CHANGE VALUE_CHANGE
, PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, MATERIAL_ALLOCATION_TEMP_ID MATERIAL_ALLOCATION_TEMP_ID
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, ITEM_SEGMENTS ITEM_SEGMENTS
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_TRX_ENABLED_FLAG ITEM_TRX_ENABLED_FLAG
, ITEM_LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE
, ITEM_RESTRICT_SUBINV_CODE ITEM_RESTRICT_SUBINV_CODE
, ITEM_RESTRICT_LOCATORS_CODE ITEM_RESTRICT_LOCATORS_CODE
, ITEM_REVISION_QTY_CONTROL_CODE ITEM_REVISION_QTY_CONTROL_CODE
, ITEM_PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE
, ITEM_UOM_CLASS ITEM_UOM_CLASS
, ITEM_SHELF_LIFE_CODE ITEM_SHELF_LIFE_CODE
, ITEM_SHELF_LIFE_DAYS ITEM_SHELF_LIFE_DAYS
, ITEM_LOT_CONTROL_CODE ITEM_LOT_CONTROL_CODE
, ITEM_SERIAL_CONTROL_CODE ITEM_SERIAL_CONTROL_CODE
, ITEM_INVENTORY_ASSET_FLAG ITEM_INVENTORY_ASSET_FLAG
, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, VALID_SUBINVENTORY_FLAG VALID_SUBINVENTORY_FLAG
, VALID_LOCATOR_FLAG VALID_LOCATOR_FLAG
, LOCATOR_SEGMENTS LOCATOR_SEGMENTS
, CURRENT_LOCATOR_CONTROL_CODE CURRENT_LOCATOR_CONTROL_CODE
, NUMBER_OF_LOTS_ENTERED NUMBER_OF_LOTS_ENTERED
, WIP_COMMIT_FLAG WIP_COMMIT_FLAG
, NEXT_LOT_NUMBER NEXT_LOT_NUMBER
, LOT_ALPHA_PREFIX LOT_ALPHA_PREFIX
, NEXT_SERIAL_NUMBER NEXT_SERIAL_NUMBER
, SERIAL_ALPHA_PREFIX SERIAL_ALPHA_PREFIX
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, POSTING_FLAG POSTING_FLAG
, REQUIRED_FLAG REQUIRED_FLAG
, PROCESS_FLAG PROCESS_FLAG
, ERROR_CODE ERROR_CODE
, ERROR_EXPLANATION ERROR_EXPLANATION
, 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
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, TRANSACTION_LINE_NUMBER TRANSACTION_LINE_NUMBER
, TASK_ID TASK_ID
, TO_TASK_ID TO_TASK_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, PROJECT_ID PROJECT_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID PA_EXPENDITURE_ORG_ID
, TO_PROJECT_ID TO_PROJECT_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
, FLOW_SCHEDULE FLOW_SCHEDULE
, COST_GROUP_ID COST_GROUP_ID
, DEMAND_CLASS DEMAND_CLASS
, QA_COLLECTION_ID QA_COLLECTION_ID
, KANBAN_CARD_ID KANBAN_CARD_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
, LINE_TYPE_CODE LINE_TYPE_CODE
, PARENT_TRANSACTION_TEMP_ID PARENT_TRANSACTION_TEMP_ID
, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID
, PICK_STRATEGY_ID PICK_STRATEGY_ID
, PICK_RULE_ID PICK_RULE_ID
, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, TASK_GROUP_ID TASK_GROUP_ID
, PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, RESERVATION_ID RESERVATION_ID
, 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
, TRANSACTION_STATUS TRANSACTION_STATUS
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, TASK_PRIORITY TASK_PRIORITY
, WMS_TASK_TYPE WMS_TASK_TYPE
, PARENT_LINE_ID PARENT_LINE_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
, WMS_TASK_STATUS WMS_TASK_STATUS
, CONTENT_LPN_ID CONTENT_LPN_ID
, CONTAINER_ITEM_ID CONTAINER_ITEM_ID
, CARTONIZATION_ID CARTONIZATION_ID
, PICK_SLIP_DATE PICK_SLIP_DATE
, REBUILD_ITEM_ID REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER
, REBUILD_ACTIVITY_ID REBUILD_ACTIVITY_ID
, REBUILD_JOB_NAME REBUILD_JOB_NAME
, 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
, ALLOCATED_LPN_ID ALLOCATED_LPN_ID
, SCHEDULE_NUMBER SCHEDULE_NUMBER
, SCHEDULED_FLAG SCHEDULED_FLAG
, CLASS_CODE CLASS_CODE
, SCHEDULE_GROUP SCHEDULE_GROUP
, BUILD_SEQUENCE BUILD_SEQUENCE
, 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
, TRANSACTION_BATCH_ID TRANSACTION_BATCH_ID
, TRANSACTION_BATCH_SEQ TRANSACTION_BATCH_SEQ
, OPERATION_PLAN_ID OPERATION_PLAN_ID
, INTRANSIT_ACCOUNT INTRANSIT_ACCOUNT
, FOB_POINT FOB_POINT
, MOVE_ORDER_HEADER_ID MOVE_ORDER_HEADER_ID
, SERIAL_ALLOCATED_FLAG SERIAL_ALLOCATED_FLAG
, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID
, LOGICAL_TRX_TYPE_CODE LOGICAL_TRX_TYPE_CODE
, ORIGINAL_TRANSACTION_TEMP_ID ORIGINAL_TRANSACTION_TEMP_ID
, TRANSFER_SECONDARY_QUANTITY TRANSFER_SECONDARY_QUANTITY
, TRANSFER_SECONDARY_UOM TRANSFER_SECONDARY_UOM
, 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
, FULFILLMENT_BASE FULFILLMENT_BASE
FROM "INV"."MTL_MATERIAL_TRANSACTIONS_TEMP"