eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WMS_COST_GROUPS_INPUT_V

Product:	WMS - Warehouse Management
Description:	This view joins MTL_TXN_REQUEST_LINES with MTL_MATERIAL_TRANSACTIONS_TEMP. A record from WMS_COST_GROUP_INPUT_V serves as the input for the WMS cost group rules engine.
Implementation/DBA Data:	APPS.WMS_COST_GROUPS_INPUT_V

View Text

SELECT MTRL.LINE_ID LINE_ID
, MTRL.HEADER_ID HEADER_ID
, MTRL.LINE_NUMBER LINE_NUMBER
, MTRL.ORGANIZATION_ID ORGANIZATION_ID
, MTRL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTRL.REVISION REVISION
, MTRL.FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID
, MTRL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTRL.FROM_LOCATOR_ID FROM_LOCATOR_ID
, MTRL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, MTRL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, MTRL.TO_LOCATOR_ID TO_LOCATOR_ID
, MTRL.TO_ACCOUNT_ID TO_ACCOUNT_ID
, MTRL.LOT_NUMBER LOT_NUMBER
, MTRL.SERIAL_NUMBER_START SERIAL_NUMBER_START
, MTRL.SERIAL_NUMBER_END SERIAL_NUMBER_END
, MTRL.UOM_CODE UOM_CODE
, MTRL.QUANTITY QUANTITY
, MTRL.QUANTITY_DELIVERED QUANTITY_DELIVERED
, MTRL.QUANTITY_DETAILED QUANTITY_DETAILED
, MTRL.DATE_REQUIRED DATE_REQUIRED
, MTRL.REASON_ID REASON_ID
, MTRL.REFERENCE REFERENCE
, MTRL.REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE
, MTRL.REFERENCE_ID REFERENCE_ID
, MTRL.PROJECT_ID PROJECT_ID
, MTRL.TASK_ID TASK_ID
, MTRL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MTRL.LINE_STATUS LINE_STATUS
, MTRL.STATUS_DATE STATUS_DATE
, MTRL.LAST_UPDATED_BY LAST_UPDATED_BY
, MTRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MTRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MTRL.CREATED_BY CREATED_BY
, MTRL.CREATION_DATE CREATION_DATE
, MTRL.REQUEST_ID REQUEST_ID
, MTRL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MTRL.PROGRAM_ID PROGRAM_ID
, MTRL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MTRL.ATTRIBUTE1 ATTRIBUTE1
, MTRL.ATTRIBUTE2 ATTRIBUTE2
, MTRL.ATTRIBUTE3 ATTRIBUTE3
, MTRL.ATTRIBUTE4 ATTRIBUTE4
, MTRL.ATTRIBUTE5 ATTRIBUTE5
, MTRL.ATTRIBUTE6 ATTRIBUTE6
, MTRL.ATTRIBUTE7 ATTRIBUTE7
, MTRL.ATTRIBUTE8 ATTRIBUTE8
, MTRL.ATTRIBUTE9 ATTRIBUTE9
, MTRL.ATTRIBUTE10 ATTRIBUTE10
, MTRL.ATTRIBUTE11 ATTRIBUTE11
, MTRL.ATTRIBUTE12 ATTRIBUTE12
, MTRL.ATTRIBUTE13 ATTRIBUTE13
, MTRL.ATTRIBUTE14 ATTRIBUTE14
, MTRL.ATTRIBUTE15 ATTRIBUTE15
, MTRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MTRL.TXN_SOURCE_ID TXN_SOURCE_ID
, MTRL.TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID
, MTRL.TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID
, MTRL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, MTRL.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, MTRL.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MTRL.ORGANIZATION_ID TO_ORGANIZATION_ID
, MTRL.PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, MTRL.PICK_STRATEGY_ID PICK_STRATEGY_ID
, MTRL.UNIT_NUMBER UNIT_NUMBER
, MTRL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, MTRL.FROM_COST_GROUP_ID FROM_COST_GROUP_ID
, MTRL.TO_COST_GROUP_ID TO_COST_GROUP_ID
, MTRL.LPN_ID LPN_ID
, MTRL.TO_LPN_ID TO_LPN_ID
, NULL SOURCE_CODE
, TO_NUMBER(NULL) SOURCE_LINE_ID
, TO_NUMBER(NULL) TRANSACTION_MODE
, NULL LOCK_FLAG
, TO_NUMBER(NULL) TRANSACTION_COST
, TO_NUMBER(NULL) TRANSACTION_ACTION_ID
, TO_NUMBER(NULL) TRANSACTION_SOURCE_ID
, NULL TRANSACTION_SOURCE_NAME
, TO_DATE(NULL) TRANSACTION_DATE
, TO_NUMBER(NULL) ACCT_PERIOD_ID
, TO_NUMBER(NULL) DISTRIBUTION_ACCOUNT_ID
, TO_NUMBER(NULL) REQUISITION_LINE_ID
, TO_NUMBER(NULL) REQUISITION_DISTRIBUTION_ID
, TO_DATE(NULL) LOT_EXPIRATION_DATE
, NULL SERIAL_NUMBER
, NULL RECEIVING_DOCUMENT
, TO_NUMBER(NULL) DEMAND_ID
, TO_NUMBER(NULL) RCV_TRANSACTION_ID
, TO_NUMBER(NULL) MOVE_TRANSACTION_ID
, TO_NUMBER(NULL) COMPLETION_TRANSACTION_ID
, TO_NUMBER(NULL) WIP_ENTITY_TYPE
, TO_NUMBER(NULL) SCHEDULE_ID
, TO_NUMBER(NULL) REPETITIVE_LINE_ID
, NULL EMPLOYEE_CODE
, TO_NUMBER(NULL) PRIMARY_SWITCH
, TO_NUMBER(NULL) SCHEDULE_UPDATE_CODE
, TO_NUMBER(NULL) SETUP_TEARDOWN_CODE
, TO_NUMBER(NULL) ITEM_ORDERING
, TO_NUMBER(NULL) NEGATIVE_REQ_FLAG
, TO_NUMBER(NULL) OPERATION_SEQ_NUM
, TO_NUMBER(NULL) PICKING_LINE_ID
, TO_NUMBER(NULL) TRX_SOURCE_DELIVERY_ID
, TO_NUMBER(NULL) PHYSICAL_ADJUSTMENT_ID
, TO_NUMBER(NULL) CYCLE_COUNT_ID
, TO_NUMBER(NULL) RMA_LINE_ID
, TO_NUMBER(NULL) CUSTOMER_SHIP_ID
, NULL CURRENCY_CODE
, TO_NUMBER(NULL) CURRENCY_CONVERSION_RATE
, NULL CURRENCY_CONVERSION_TYPE
, TO_DATE(NULL) CURRENCY_CONVERSION_DATE
, NULL USSGL_TRANSACTION_CODE
, NULL VENDOR_LOT_NUMBER
, TO_NUMBER(NULL) ENCUMBRANCE_ACCOUNT
, TO_NUMBER(NULL) ENCUMBRANCE_AMOUNT
, NULL SHIPMENT_NUMBER
, TO_NUMBER(NULL) TRANSFER_COST
, TO_NUMBER(NULL) TRANSPORTATION_COST
, TO_NUMBER(NULL) TRANSPORTATION_ACCOUNT
, NULL FREIGHT_CODE
, TO_NUMBER(NULL) CONTAINERS
, NULL WAYBILL_AIRBILL
, TO_DATE(NULL) EXPECTED_ARRIVAL_DATE
, TO_NUMBER(NULL) NEW_AVERAGE_COST
, TO_NUMBER(NULL) VALUE_CHANGE
, TO_NUMBER(NULL) PERCENTAGE_CHANGE
, TO_NUMBER(NULL) MATERIAL_ALLOCATION_TEMP_ID
, TO_NUMBER(NULL) DEMAND_SOURCE_HEADER_ID
, NULL DEMAND_SOURCE_LINE
, NULL DEMAND_SOURCE_DELIVERY
, NULL ITEM_SEGMENTS
, NULL ITEM_DESCRIPTION
, NULL ITEM_TRX_ENABLED_FLAG
, TO_NUMBER(NULL) ITEM_LOCATION_CONTROL_CODE
, TO_NUMBER(NULL) ITEM_RESTRICT_SUBINV_CODE
, TO_NUMBER(NULL) ITEM_RESTRICT_LOCATORS_CODE
, TO_NUMBER(NULL) ITEM_REVISION_QTY_CONTROL_CODE
, NULL ITEM_PRIMARY_UOM_CODE
, NULL ITEM_UOM_CLASS
, TO_NUMBER(NULL) ITEM_SHELF_LIFE_CODE
, TO_NUMBER(NULL) ITEM_SHELF_LIFE_DAYS
, TO_NUMBER(NULL) ITEM_LOT_CONTROL_CODE
, TO_NUMBER(NULL) ITEM_SERIAL_CONTROL_CODE
, NULL ITEM_INVENTORY_ASSET_FLAG
, TO_NUMBER(NULL) ALLOWED_UNITS_LOOKUP_CODE
, TO_NUMBER( NULL) DEPARTMENT_ID
, NULL DEPARTMENT_CODE
, TO_NUMBER(NULL) WIP_SUPPLY_TYPE
, NULL SUPPLY_SUBINVENTORY
, TO_NUMBER(NULL) SUPPLY_LOCATOR_ID
, NULL VALID_SUBINVENTORY_FLAG
, NULL VALID_LOCATOR_FLAG
, NULL LOCATOR_SEGMENTS
, TO_NUMBER(NULL) CURRENT_LOCATOR_CONTROL_CODE
, TO_NUMBER(NULL) NUMBER_OF_LOTS_ENTERED
, NULL WIP_COMMIT_FLAG
, NULL NEXT_LOT_NUMBER
, NULL LOT_ALPHA_PREFIX
, NULL NEXT_SERIAL_NUMBER
, NULL SERIAL_ALPHA_PREFIX
, NULL SHIPPABLE_FLAG
, NULL POSTING_FLAG
, NULL REQUIRED_FLAG
, NULL PROCESS_FLAG
, NULL ERROR_CODE
, NULL ERROR_EXPLANATION
, TO_NUMBER(NULL) MOVEMENT_ID
, TO_NUMBER(NULL) RESERVATION_QUANTITY
, TO_NUMBER(NULL) SHIPPED_QUANTITY
, TO_NUMBER(NULL) TRANSACTION_LINE_NUMBER
, TO_NUMBER(NULL) TO_TASK_ID
, TO_NUMBER(NULL) SOURCE_TASK_ID
, TO_NUMBER(NULL) SOURCE_PROJECT_ID
, TO_NUMBER(NULL) PA_EXPENDITURE_ORG_ID
, TO_NUMBER(NULL) TO_PROJECT_ID
, NULL EXPENDITURE_TYPE
, NULL FINAL_COMPLETION_FLAG
, TO_NUMBER(NULL) TRANSFER_PERCENTAGE
, TO_NUMBER(NULL) TRANSACTION_SEQUENCE_ID
, TO_NUMBER(NULL) MATERIAL_ACCOUNT
, TO_NUMBER(NULL) MATERIAL_OVERHEAD_ACCOUNT
, TO_NUMBER(NULL) RESOURCE_ACCOUNT
, TO_NUMBER(NULL) OUTSIDE_PROCESSING_ACCOUNT
, TO_NUMBER(NULL) OVERHEAD_ACCOUNT
, NULL FLOW_SCHEDULE
, NULL DEMAND_CLASS
, TO_NUMBER(NULL) QA_COLLECTION_ID
, TO_NUMBER(NULL) KANBAN_CARD_ID
, TO_NUMBER(NULL) OVERCOMPLETION_TRANSACTION_ID
, TO_NUMBER(NULL) OVERCOMPLETION_PRIMARY_QTY
, TO_NUMBER(NULL) OVERCOMPLETION_TRANSACTION_QTY
, TO_DATE(NULL) SCHEDULED_PAYBACK_DATE
, TO_NUMBER(NULL) LINE_TYPE_CODE
, TO_NUMBER(NULL) PARENT_TRANSACTION_TEMP_ID
, TO_NUMBER(NULL) PUT_AWAY_RULE_ID
, TO_NUMBER(NULL) PICK_RULE_ID
, TO_NUMBER(NULL) COMMON_BOM_SEQ_ID
, TO_NUMBER(NULL) COMMON_ROUTING_SEQ_ID
, TO_NUMBER(NULL) COST_TYPE_ID
, TO_NUMBER(NULL) ORG_COST_GROUP_ID
, TO_NUMBER(NULL) MOVE_ORDER_LINE_ID
, TO_NUMBER(NULL) TASK_GROUP_ID
, TO_NUMBER(NULL) PICK_SLIP_NUMBER
, TO_NUMBER(NULL) RESERVATION_ID
, TO_NUMBER(NULL) TRANSACTION_STATUS
, TO_NUMBER(NULL) STANDARD_OPERATION_ID
, TO_NUMBER(NULL) TASK_PRIORITY
, TO_NUMBER(NULL) WMS_TASK_TYPE
, TO_NUMBER(NULL) PARENT_LINE_ID
, MTRL.INSPECTION_STATUS INSPECTION_STATUS
, DECODE(MTT.TRANSACTION_ACTION_ID
, 12
, MTRL.TO_ORGANIZATION_ID
, MTRL.ORGANIZATION_ID) SOURCE_ORGANIZATION_ID
FROM MTL_TXN_REQUEST_LINES MTRL
, MTL_TRANSACTION_TYPES MTT
WHERE WMS_COSTGROUPENGINE_PVT.GETCURRENTINPUTTYPE = 2
AND MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID UNION ALL SELECT MMTT.TRANSACTION_TEMP_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 3
, MMTT.TRANSFER_ORGANIZATION
, 21
, DECODE(MIP.FOB_POINT
, 1
, TRANSFER_ORGANIZATION
, ORGANIZATION_ID)
, ORGANIZATION_ID)
, MMTT.INVENTORY_ITEM_ID
, MMTT.REVISION
, TO_NUMBER(NULL)
, DECODE(TRANSACTION_ACTION_ID
, 1
, SUBINVENTORY_CODE
, 2
, SUBINVENTORY_CODE
, 3
, SUBINVENTORY_CODE
, 21
, SUBINVENTORY_CODE
, 28
, SUBINVENTORY_CODE
, 29
, SUBINVENTORY_CODE
, 32
, SUBINVENTORY_CODE
, 34
, SUBINVENTORY_CODE
, NULL) FROM_SUBINVENTORY_CODE
, DECODE(TRANSACTION_ACTION_ID
, 1
, LOCATOR_ID
, 2
, LOCATOR_ID
, 3
, LOCATOR_ID
, 21
, LOCATOR_ID
, 28
, LOCATOR_ID
, 29
, LOCATOR_ID
, 32
, LOCATOR_ID
, 34
, LOCATOR_ID
, TO_NUMBER(NULL)) FROM_LOCATOR_ID
, DECODE(TRANSACTION_ACTION_ID
, 1
, NULL
, 2
, TRANSFER_SUBINVENTORY
, 3
, TRANSFER_SUBINVENTORY
, 21
, NULL
, 28
, TRANSFER_SUBINVENTORY
, 29
, NULL
, 32
, NULL
, 34
, NULL
, SUBINVENTORY_CODE) TO_SUBINVENTORY_CODE
, TO_NUMBER(NULL)
, DECODE(TRANSACTION_ACTION_ID
, 1
, TO_NUMBER(NULL)
, 2
, TRANSFER_TO_LOCATION
, 3
, TRANSFER_TO_LOCATION
, 21
, TO_NUMBER(NULL)
, 28
, TRANSFER_TO_LOCATION
, 29
, TO_NUMBER(NULL)
, 32
, TO_NUMBER(NULL)
, 34
, TO_NUMBER(NULL)
, LOCATOR_ID) TO_LOCATOR_ID
, TO_NUMBER(NULL)
, NVL(MMTT.LOT_NUMBER
, MTLT.LOT_NUMBER)
, NULL
, NULL
, MMTT.TRANSACTION_UOM
, MMTT.TRANSACTION_QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, MMTT.REASON_ID
, MMTT.TRANSACTION_REFERENCE
, TO_NUMBER(NULL)
, DECODE(SOURCE_CODE
, 'RCV'
, RCV_TRANSACTION_ID
, TO_NUMBER(NULL))
, MMTT.PROJECT_ID
, MMTT.TASK_ID
, MMTT.TRANSACTION_HEADER_ID
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, MMTT.LAST_UPDATED_BY
, MMTT.LAST_UPDATE_LOGIN
, MMTT.LAST_UPDATE_DATE
, MMTT.CREATED_BY
, MMTT.CREATION_DATE
, MMTT.REQUEST_ID
, MMTT.PROGRAM_APPLICATION_ID
, MMTT.PROGRAM_ID
, MMTT.PROGRAM_UPDATE_DATE
, MMTT.ATTRIBUTE1
, MMTT.ATTRIBUTE2
, MMTT.ATTRIBUTE3
, MMTT.ATTRIBUTE4
, MMTT.ATTRIBUTE5
, MMTT.ATTRIBUTE6
, MMTT.ATTRIBUTE7
, MMTT.ATTRIBUTE8
, MMTT.ATTRIBUTE9
, MMTT.ATTRIBUTE10
, MMTT.ATTRIBUTE11
, MMTT.ATTRIBUTE12
, MMTT.ATTRIBUTE13
, MMTT. ATTRIBUTE14
, MMTT.ATTRIBUTE15
, MMTT.ATTRIBUTE_CATEGORY
, TO_NUMBER(NULL)
, MMTT.TRX_SOURCE_LINE_ID
, TO_NUMBER(NULL)
, MMTT.TRANSACTION_TYPE_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.PRIMARY_QUANTITY
, DECODE(TRANSACTION_ACTION_ID
, 3
, TRANSFER_ORGANIZATION
, 21
, TRANSFER_ORGANIZATION
, ORGANIZATION_ID)
, MMTT.PUT_AWAY_STRATEGY_ID
, MMTT.PICK_STRATEGY_ID
, MMTT.END_ITEM_UNIT_NUMBER
, MMTT.SHIP_TO_LOCATION
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 1
, MMTT.COST_GROUP_ID
, 2
, MMTT.COST_GROUP_ID
, 3
, MMTT.COST_GROUP_ID
, 21
, MMTT.COST_GROUP_ID
, 28
, MMTT.COST_GROUP_ID
, 29
, MMTT.COST_GROUP_ID
, 32
, MMTT.COST_GROUP_ID
, 34
, MMTT.COST_GROUP_ID
, TO_NUMBER(NULL)) FROM_COST_GROUP_ID
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 1
, TO_NUMBER(NULL)
, 2
, MMTT.TRANSFER_COST_GROUP_ID
, 3
, MMTT.TRANSFER_COST_GROUP_ID
, 21
, TO_NUMBER(NULL)
, 28
, MMTT.TRANSFER_COST_GROUP_ID
, 29
, TO_NUMBER(NULL)
, 32
, TO_NUMBER(NULL)
, 34
, TO_NUMBER(NULL)
, MMTT.COST_GROUP_ID) TO_COST_GROUP_ID
, MMTT.LPN_ID
, MMTT.TRANSFER_LPN_ID
, MMTT.SOURCE_CODE
, MMTT.SOURCE_LINE_ID
, MMTT.TRANSACTION_MODE
, MMTT.LOCK_FLAG
, MMTT.TRANSACTION_COST
, MMTT.TRANSACTION_ACTION_ID
, MMTT.TRANSACTION_SOURCE_ID
, MMTT.TRANSACTION_SOURCE_NAME
, MMTT.TRANSACTION_DATE
, MMTT.ACCT_PERIOD_ID
, MMTT.DISTRIBUTION_ACCOUNT_ID
, MMTT.REQUISITION_LINE_ID
, MMTT.REQUISITION_DISTRIBUTION_ID
, NVL(MMTT. LOT_EXPIRATION_DATE
, MTLT.LOT_EXPIRATION_DATE)
, NVL(MMTT.SERIAL_NUMBER
, MSN.SERIAL_NUMBER)
, MMTT.RECEIVING_DOCUMENT
, MMTT.DEMAND_ID
, MMTT.RCV_TRANSACTION_ID
, MMTT.MOVE_TRANSACTION_ID
, MMTT.COMPLETION_TRANSACTION_ID
, MMTT.WIP_ENTITY_TYPE
, MMTT.SCHEDULE_ID
, MMTT.REPETITIVE_LINE_ID
, MMTT.EMPLOYEE_CODE
, MMTT.PRIMARY_SWITCH
, MMTT.SCHEDULE_UPDATE_CODE
, MMTT.SETUP_TEARDOWN_CODE
, MMTT.ITEM_ORDERING
, MMTT.NEGATIVE_REQ_FLAG
, MMTT.OPERATION_SEQ_NUM
, MMTT.PICKING_LINE_ID
, MMTT.TRX_SOURCE_DELIVERY_ID
, MMTT.PHYSICAL_ADJUSTMENT_ID
, MMTT.CYCLE_COUNT_ID
, MMTT.RMA_LINE_ID
, MMTT.CUSTOMER_SHIP_ID
, MMTT.CURRENCY_CODE
, MMTT.CURRENCY_CONVERSION_RATE
, MMTT.CURRENCY_CONVERSION_TYPE
, MMTT.CURRENCY_CONVERSION_DATE
, MMTT.USSGL_TRANSACTION_CODE
, MMTT.VENDOR_LOT_NUMBER
, MMTT.ENCUMBRANCE_ACCOUNT
, MMTT.ENCUMBRANCE_AMOUNT
, MMTT.SHIPMENT_NUMBER
, MMTT.TRANSFER_COST
, MMTT.TRANSPORTATION_COST
, MMTT.TRANSPORTATION_ACCOUNT
, MMTT.FREIGHT_CODE
, MMTT.CONTAINERS
, MMTT.WAYBILL_AIRBILL
, MMTT.EXPECTED_ARRIVAL_DATE
, MMTT.NEW_AVERAGE_COST
, MMTT.VALUE_CHANGE
, MMTT.PERCENTAGE_CHANGE
, MMTT.MATERIAL_ALLOCATION_TEMP_ID
, MMTT.DEMAND_SOURCE_HEADER_ID
, MMTT.DEMAND_SOURCE_LINE
, MMTT.DEMAND_SOURCE_DELIVERY
, MMTT.ITEM_SEGMENTS
, MMTT.ITEM_DESCRIPTION
, MMTT.ITEM_TRX_ENABLED_FLAG
, MMTT.ITEM_LOCATION_CONTROL_CODE
, MMTT.ITEM_RESTRICT_SUBINV_CODE
, MMTT.ITEM_RESTRICT_LOCATORS_CODE
, MMTT.ITEM_REVISION_QTY_CONTROL_CODE
, MMTT.ITEM_PRIMARY_UOM_CODE
, MMTT.ITEM_UOM_CLASS
, MMTT.ITEM_SHELF_LIFE_CODE
, MMTT.ITEM_SHELF_LIFE_DAYS
, MMTT.ITEM_LOT_CONTROL_CODE
, MMTT.ITEM_SERIAL_CONTROL_CODE
, MMTT.ITEM_INVENTORY_ASSET_FLAG
, MMTT.ALLOWED_UNITS_LOOKUP_CODE
, MMTT.DEPARTMENT_ID
, MMTT.DEPARTMENT_CODE
, MMTT.WIP_SUPPLY_TYPE
, MMTT.SUPPLY_SUBINVENTORY
, MMTT.SUPPLY_LOCATOR_ID
, MMTT.VALID_SUBINVENTORY_FLAG
, MMTT.VALID_LOCATOR_FLAG
, MMTT.LOCATOR_SEGMENTS
, MMTT.CURRENT_LOCATOR_CONTROL_CODE
, MMTT.NUMBER_OF_LOTS_ENTERED
, MMTT.WIP_COMMIT_FLAG
, MMTT.NEXT_LOT_NUMBER
, MMTT.LOT_ALPHA_PREFIX
, MMTT.NEXT_SERIAL_NUMBER
, MMTT.SERIAL_ALPHA_PREFIX
, MMTT.SHIPPABLE_FLAG
, MMTT.POSTING_FLAG
, MMTT.REQUIRED_FLAG
, MMTT.PROCESS_FLAG
, MMTT.ERROR_CODE
, MMTT.ERROR_EXPLANATION
, MMTT.MOVEMENT_ID
, MMTT.RESERVATION_QUANTITY
, MMTT.SHIPPED_QUANTITY
, MMTT.TRANSACTION_LINE_NUMBER
, MMTT.TO_TASK_ID
, MMTT.SOURCE_TASK_ID
, MMTT.SOURCE_PROJECT_ID
, MMTT.PA_EXPENDITURE_ORG_ID
, MMTT.TO_PROJECT_ID
, MMTT.EXPENDITURE_TYPE
, MMTT.FINAL_COMPLETION_FLAG
, MMTT.TRANSFER_PERCENTAGE
, MMTT.TRANSACTION_SEQUENCE_ID
, MMTT.MATERIAL_ACCOUNT
, MMTT.MATERIAL_OVERHEAD_ACCOUNT
, MMTT.RESOURCE_ACCOUNT
, MMTT.OUTSIDE_PROCESSING_ACCOUNT
, MMTT.OVERHEAD_ACCOUNT
, MMTT.FLOW_SCHEDULE
, MMTT.DEMAND_CLASS
, MMTT.QA_COLLECTION_ID
, MMTT.KANBAN_CARD_ID
, MMTT.OVERCOMPLETION_TRANSACTION_ID
, MMTT.OVERCOMPLETION_PRIMARY_QTY
, MMTT.OVERCOMPLETION_TRANSACTION_QTY
, MMTT.SCHEDULED_PAYBACK_DATE
, MMTT.LINE_TYPE_CODE
, MMTT.PARENT_TRANSACTION_TEMP_ID
, MMTT.PUT_AWAY_RULE_ID
, MMTT.PICK_RULE_ID
, MMTT.COMMON_BOM_SEQ_ID
, MMTT.COMMON_ROUTING_SEQ_ID
, MMTT.COST_TYPE_ID
, MMTT.ORG_COST_GROUP_ID
, MMTT.MOVE_ORDER_LINE_ID
, MMTT.TASK_GROUP_ID
, MMTT.PICK_SLIP_NUMBER
, MMTT.RESERVATION_ID
, MMTT.TRANSACTION_STATUS
, MMTT.STANDARD_OPERATION_ID
, MMTT.TASK_PRIORITY
, MMTT.WMS_TASK_TYPE
, MMTT.PARENT_LINE_ID
, TO_NUMBER(NULL) INSPECTION_STATUS
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 12
, MMTT.TRANSFER_ORGANIZATION
, MMTT.ORGANIZATION_ID)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_SERIAL_NUMBERS MSN
, MTL_SERIAL_NUMBERS_TEMP MSNT
, MTL_INTERORG_PARAMETERS MIP
WHERE WMS_COSTGROUPENGINE_PVT.GETCURRENTINPUTTYPE = 1
AND MMTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID (+)
AND MSNT.TRANSACTION_TEMP_ID = NVL (MTLT.SERIAL_TRANSACTION_TEMP_ID
, MMTT.TRANSACTION_TEMP_ID )
AND MSNT.FM_SERIAL_NUMBER <= MSN.SERIAL_NUMBER
AND MSNT.TO_SERIAL_NUMBER >= MSN.SERIAL_NUMBER
AND MMTT.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND NVL(MTLT.LOT_NUMBER
, NVL(MMTT.LOT_NUMBER
, '9999')) = NVL(MSN.LOT_NUMBER
, '9999')
AND NVL(MMTT.REVISION
, '9999') = NVL(MSN.REVISION
, '9999')
AND MIP.FROM_ORGANIZATION_ID (+) = MMTT.ORGANIZATION_ID
AND MIP.TO_ORGANIZATION_ID (+) = MMTT. TRANSFER_ORGANIZATION
AND MMTT.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID UNION SELECT MMTT.TRANSACTION_TEMP_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 3
, MMTT.ORGANIZATION_ID
, 21
, DECODE(MIP.FOB_POINT
, 1
, TRANSFER_ORGANIZATION
, ORGANIZATION_ID)
, ORGANIZATION_ID)
, MMTT.INVENTORY_ITEM_ID
, MMTT.REVISION
, TO_NUMBER(NULL)
, DECODE(TRANSACTION_ACTION_ID
, 1
, SUBINVENTORY_CODE
, 2
, SUBINVENTORY_CODE
, 3
, SUBINVENTORY_CODE
, 21
, SUBINVENTORY_CODE
, 28
, SUBINVENTORY_CODE
, 29
, SUBINVENTORY_CODE
, 32
, SUBINVENTORY_CODE
, 34
, SUBINVENTORY_CODE
, NULL) FROM_SUBINVENTORY_CODE
, DECODE(TRANSACTION_ACTION_ID
, 1
, LOCATOR_ID
, 2
, LOCATOR_ID
, 3
, LOCATOR_ID
, 21
, LOCATOR_ID
, 28
, LOCATOR_ID
, 29
, LOCATOR_ID
, 32
, LOCATOR_ID
, 34
, LOCATOR_ID
, TO_NUMBER(NULL)) FROM_LOCATOR_ID
, DECODE(TRANSACTION_ACTION_ID
, 1
, NULL
, 2
, TRANSFER_SUBINVENTORY
, 3
, TRANSFER_SUBINVENTORY
, 21
, NULL
, 28
, TRANSFER_SUBINVENTORY
, 29
, SUBINVENTORY_CODE
, 32
, NULL
, 34
, NULL
, SUBINVENTORY_CODE) TO_SUBINVENTORY_CODE
, TO_NUMBER(NULL)
, DECODE(TRANSACTION_ACTION_ID
, 1
, TO_NUMBER(NULL)
, 2
, TRANSFER_TO_LOCATION
, 3
, TRANSFER_TO_LOCATION
, 21
, TO_NUMBER(NULL)
, 28
, TRANSFER_TO_LOCATION
, 29
, TO_NUMBER(NULL)
, 32
, TO_NUMBER(NULL)
, 34
, TO_NUMBER(NULL)
, LOCATOR_ID) TO_LOCATOR_ID
, TO_NUMBER(NULL)
, NVL(MMTT.LOT_NUMBER
, MTLT.LOT_NUMBER)
, NULL
, NULL
, MMTT.TRANSACTION_UOM
, MMTT.TRANSACTION_QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, MMTT.REASON_ID
, MMTT.TRANSACTION_REFERENCE
, TO_NUMBER(NULL)
, DECODE(SOURCE_CODE
, 'RCV'
, RCV_TRANSACTION_ID
, TO_NUMBER(NULL))
, MMTT.PROJECT_ID
, MMTT.TASK_ID
, MMTT.TRANSACTION_HEADER_ID
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, MMTT.LAST_UPDATED_BY
, MMTT.LAST_UPDATE_LOGIN
, MMTT.LAST_UPDATE_DATE
, MMTT.CREATED_BY
, MMTT.CREATION_DATE
, MMTT.REQUEST_ID
, MMTT.PROGRAM_APPLICATION_ID
, MMTT.PROGRAM_ID
, MMTT.PROGRAM_UPDATE_DATE
, MMTT.ATTRIBUTE1
, MMTT.ATTRIBUTE2
, MMTT.ATTRIBUTE3
, MMTT.ATTRIBUTE4
, MMTT.ATTRIBUTE5
, MMTT.ATTRIBUTE6
, MMTT.ATTRIBUTE7
, MMTT.ATTRIBUTE8
, MMTT.ATTRIBUTE9
, MMTT.ATTRIBUTE10
, MMTT.ATTRIBUTE11
, MMTT.ATTRIBUTE12
, MMTT.ATTRIBUTE13
, MMTT. ATTRIBUTE14
, MMTT.ATTRIBUTE15
, MMTT.ATTRIBUTE_CATEGORY
, TO_NUMBER(NULL)
, MMTT.TRX_SOURCE_LINE_ID
, TO_NUMBER(NULL)
, MMTT.TRANSACTION_TYPE_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.PRIMARY_QUANTITY
, DECODE(TRANSACTION_ACTION_ID
, 3
, TRANSFER_ORGANIZATION
, 21
, TRANSFER_ORGANIZATION
, ORGANIZATION_ID)
, MMTT.PUT_AWAY_STRATEGY_ID
, MMTT.PICK_STRATEGY_ID
, MMTT.END_ITEM_UNIT_NUMBER
, MMTT.SHIP_TO_LOCATION
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 1
, MMTT.COST_GROUP_ID
, 2
, MMTT.COST_GROUP_ID
, 3
, MMTT.COST_GROUP_ID
, 21
, MMTT.COST_GROUP_ID
, 28
, MMTT.COST_GROUP_ID
, 29
, MMTT.COST_GROUP_ID
, 32
, MMTT.COST_GROUP_ID
, 34
, MMTT.COST_GROUP_ID
, TO_NUMBER(NULL)) FROM_COST_GROUP_ID
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 1
, TO_NUMBER(NULL)
, 2
, MMTT.TRANSFER_COST_GROUP_ID
, 3
, MMTT.TRANSFER_COST_GROUP_ID
, 21
, TO_NUMBER(NULL)
, 28
, MMTT.TRANSFER_COST_GROUP_ID
, 29
, TO_NUMBER(NULL)
, 32
, TO_NUMBER(NULL)
, 34
, TO_NUMBER(NULL)
, MMTT.COST_GROUP_ID) TO_COST_GROUP_ID
, MMTT.LPN_ID
, MMTT.TRANSFER_LPN_ID
, MMTT.SOURCE_CODE
, MMTT.SOURCE_LINE_ID
, MMTT.TRANSACTION_MODE
, MMTT.LOCK_FLAG
, MMTT.TRANSACTION_COST
, MMTT.TRANSACTION_ACTION_ID
, MMTT.TRANSACTION_SOURCE_ID
, MMTT.TRANSACTION_SOURCE_NAME
, MMTT.TRANSACTION_DATE
, MMTT.ACCT_PERIOD_ID
, MMTT.DISTRIBUTION_ACCOUNT_ID
, MMTT.REQUISITION_LINE_ID
, MMTT.REQUISITION_DISTRIBUTION_ID
, NVL(MMTT. LOT_EXPIRATION_DATE
, MTLT.LOT_EXPIRATION_DATE)
, MMTT.SERIAL_NUMBER
, MMTT.RECEIVING_DOCUMENT
, MMTT.DEMAND_ID
, MMTT.RCV_TRANSACTION_ID
, MMTT.MOVE_TRANSACTION_ID
, MMTT.COMPLETION_TRANSACTION_ID
, MMTT.WIP_ENTITY_TYPE
, MMTT.SCHEDULE_ID
, MMTT.REPETITIVE_LINE_ID
, MMTT.EMPLOYEE_CODE
, MMTT.PRIMARY_SWITCH
, MMTT.SCHEDULE_UPDATE_CODE
, MMTT.SETUP_TEARDOWN_CODE
, MMTT.ITEM_ORDERING
, MMTT.NEGATIVE_REQ_FLAG
, MMTT.OPERATION_SEQ_NUM
, MMTT.PICKING_LINE_ID
, MMTT.TRX_SOURCE_DELIVERY_ID
, MMTT.PHYSICAL_ADJUSTMENT_ID
, MMTT.CYCLE_COUNT_ID
, MMTT.RMA_LINE_ID
, MMTT.CUSTOMER_SHIP_ID
, MMTT.CURRENCY_CODE
, MMTT.CURRENCY_CONVERSION_RATE
, MMTT.CURRENCY_CONVERSION_TYPE
, MMTT.CURRENCY_CONVERSION_DATE
, MMTT.USSGL_TRANSACTION_CODE
, MMTT.VENDOR_LOT_NUMBER
, MMTT.ENCUMBRANCE_ACCOUNT
, MMTT.ENCUMBRANCE_AMOUNT
, MMTT.SHIPMENT_NUMBER
, MMTT.TRANSFER_COST
, MMTT.TRANSPORTATION_COST
, MMTT.TRANSPORTATION_ACCOUNT
, MMTT.FREIGHT_CODE
, MMTT.CONTAINERS
, MMTT.WAYBILL_AIRBILL
, MMTT.EXPECTED_ARRIVAL_DATE
, MMTT.NEW_AVERAGE_COST
, MMTT.VALUE_CHANGE
, MMTT.PERCENTAGE_CHANGE
, MMTT.MATERIAL_ALLOCATION_TEMP_ID
, MMTT.DEMAND_SOURCE_HEADER_ID
, MMTT.DEMAND_SOURCE_LINE
, MMTT.DEMAND_SOURCE_DELIVERY
, MMTT.ITEM_SEGMENTS
, MMTT.ITEM_DESCRIPTION
, MMTT.ITEM_TRX_ENABLED_FLAG
, MMTT.ITEM_LOCATION_CONTROL_CODE
, MMTT.ITEM_RESTRICT_SUBINV_CODE
, MMTT.ITEM_RESTRICT_LOCATORS_CODE
, MMTT.ITEM_REVISION_QTY_CONTROL_CODE
, MMTT.ITEM_PRIMARY_UOM_CODE
, MMTT.ITEM_UOM_CLASS
, MMTT.ITEM_SHELF_LIFE_CODE
, MMTT.ITEM_SHELF_LIFE_DAYS
, MMTT.ITEM_LOT_CONTROL_CODE
, MMTT.ITEM_SERIAL_CONTROL_CODE
, MMTT.ITEM_INVENTORY_ASSET_FLAG
, MMTT.ALLOWED_UNITS_LOOKUP_CODE
, MMTT.DEPARTMENT_ID
, MMTT.DEPARTMENT_CODE
, MMTT.WIP_SUPPLY_TYPE
, MMTT.SUPPLY_SUBINVENTORY
, MMTT.SUPPLY_LOCATOR_ID
, MMTT.VALID_SUBINVENTORY_FLAG
, MMTT.VALID_LOCATOR_FLAG
, MMTT.LOCATOR_SEGMENTS
, MMTT.CURRENT_LOCATOR_CONTROL_CODE
, MMTT.NUMBER_OF_LOTS_ENTERED
, MMTT.WIP_COMMIT_FLAG
, MMTT.NEXT_LOT_NUMBER
, MMTT.LOT_ALPHA_PREFIX
, MMTT.NEXT_SERIAL_NUMBER
, MMTT.SERIAL_ALPHA_PREFIX
, MMTT.SHIPPABLE_FLAG
, MMTT.POSTING_FLAG
, MMTT.REQUIRED_FLAG
, MMTT.PROCESS_FLAG
, MMTT.ERROR_CODE
, MMTT.ERROR_EXPLANATION
, MMTT.MOVEMENT_ID
, MMTT.RESERVATION_QUANTITY
, MMTT.SHIPPED_QUANTITY
, MMTT.TRANSACTION_LINE_NUMBER
, MMTT.TO_TASK_ID
, MMTT.SOURCE_TASK_ID
, MMTT.SOURCE_PROJECT_ID
, MMTT.PA_EXPENDITURE_ORG_ID
, MMTT.TO_PROJECT_ID
, MMTT.EXPENDITURE_TYPE
, MMTT.FINAL_COMPLETION_FLAG
, MMTT.TRANSFER_PERCENTAGE
, MMTT.TRANSACTION_SEQUENCE_ID
, MMTT.MATERIAL_ACCOUNT
, MMTT.MATERIAL_OVERHEAD_ACCOUNT
, MMTT.RESOURCE_ACCOUNT
, MMTT.OUTSIDE_PROCESSING_ACCOUNT
, MMTT.OVERHEAD_ACCOUNT
, MMTT.FLOW_SCHEDULE
, MMTT.DEMAND_CLASS
, MMTT.QA_COLLECTION_ID
, MMTT.KANBAN_CARD_ID
, MMTT.OVERCOMPLETION_TRANSACTION_ID
, MMTT.OVERCOMPLETION_PRIMARY_QTY
, MMTT.OVERCOMPLETION_TRANSACTION_QTY
, MMTT.SCHEDULED_PAYBACK_DATE
, MMTT.LINE_TYPE_CODE
, MMTT.PARENT_TRANSACTION_TEMP_ID
, MMTT.PUT_AWAY_RULE_ID
, MMTT.PICK_RULE_ID
, MMTT.COMMON_BOM_SEQ_ID
, MMTT.COMMON_ROUTING_SEQ_ID
, MMTT.COST_TYPE_ID
, MMTT.ORG_COST_GROUP_ID
, MMTT.MOVE_ORDER_LINE_ID
, MMTT.TASK_GROUP_ID
, MMTT.PICK_SLIP_NUMBER
, MMTT.RESERVATION_ID
, MMTT.TRANSACTION_STATUS
, MMTT.STANDARD_OPERATION_ID
, MMTT.TASK_PRIORITY
, MMTT.WMS_TASK_TYPE
, MMTT.PARENT_LINE_ID
, TO_NUMBER(NULL) INSPECTION_STATUS
, DECODE(MMTT.TRANSACTION_ACTION_ID
, 12
, MMTT.TRANSFER_ORGANIZATION
, MMTT.ORGANIZATION_ID)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_INTERORG_PARAMETERS MIP
WHERE WMS_COSTGROUPENGINE_PVT.GETCURRENTINPUTTYPE = 1
AND MMTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID (+)
AND MIP.FROM_ORGANIZATION_ID (+) = MMTT.ORGANIZATION_ID
AND MIP.TO_ORGANIZATION_ID (+) = MMTT.TRANSFER_ORGANIZATION

Columns

Name
LINE_ID
HEADER_ID
LINE_NUMBER
ORGANIZATION_ID
INVENTORY_ITEM_ID
REVISION
FROM_SUBINVENTORY_ID
FROM_SUBINVENTORY_CODE
FROM_LOCATOR_ID
TO_SUBINVENTORY_CODE
TO_SUBINVENTORY_ID
TO_LOCATOR_ID
TO_ACCOUNT_ID
LOT_NUMBER
SERIAL_NUMBER_START
SERIAL_NUMBER_END
UOM_CODE
QUANTITY
QUANTITY_DELIVERED
QUANTITY_DETAILED
DATE_REQUIRED
REASON_ID
REFERENCE
REFERENCE_TYPE_CODE
REFERENCE_ID
PROJECT_ID
TASK_ID
TRANSACTION_HEADER_ID
LINE_STATUS
STATUS_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE_CATEGORY
TXN_SOURCE_ID
TXN_SOURCE_LINE_ID
TXN_SOURCE_LINE_DETAIL_ID
TRANSACTION_TYPE_ID
TRANSACTION_SOURCE_TYPE_ID
PRIMARY_QUANTITY
TO_ORGANIZATION_ID
PUT_AWAY_STRATEGY_ID
PICK_STRATEGY_ID
UNIT_NUMBER
SHIP_TO_LOCATION_ID
FROM_COST_GROUP_ID
TO_COST_GROUP_ID
LPN_ID
TO_LPN_ID
SOURCE_CODE
SOURCE_LINE_ID
TRANSACTION_MODE
LOCK_FLAG
TRANSACTION_COST
TRANSACTION_ACTION_ID
TRANSACTION_SOURCE_ID
TRANSACTION_SOURCE_NAME
TRANSACTION_DATE
ACCT_PERIOD_ID
DISTRIBUTION_ACCOUNT_ID
REQUISITION_LINE_ID
REQUISITION_DISTRIBUTION_ID
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_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
SHIPMENT_NUMBER
TRANSFER_COST
TRANSPORTATION_COST
TRANSPORTATION_ACCOUNT
FREIGHT_CODE
CONTAINERS
WAYBILL_AIRBILL
EXPECTED_ARRIVAL_DATE
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
MOVEMENT_ID
RESERVATION_QUANTITY
SHIPPED_QUANTITY
TRANSACTION_LINE_NUMBER
TO_TASK_ID
SOURCE_TASK_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
DEMAND_CLASS
QA_COLLECTION_ID
KANBAN_CARD_ID
OVERCOMPLETION_TRANSACTION_ID
OVERCOMPLETION_PRIMARY_QTY
OVERCOMPLETION_TRANSACTION_QTY
SCHEDULED_PAYBACK_DATE
LINE_TYPE_CODE
PARENT_TRANSACTION_TEMP_ID
PUT_AWAY_RULE_ID
PICK_RULE_ID
COMMON_BOM_SEQ_ID
COMMON_ROUTING_SEQ_ID
COST_TYPE_ID
ORG_COST_GROUP_ID
MOVE_ORDER_LINE_ID
TASK_GROUP_ID
PICK_SLIP_NUMBER
RESERVATION_ID
TRANSACTION_STATUS
STANDARD_OPERATION_ID
TASK_PRIORITY
WMS_TASK_TYPE
PARENT_LINE_ID
INSPECTION_STATUS
SOURCE_ORGANIZATION_ID