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.

VIEW: APPS.WMS_SUGGESTIONS_TEMP_V

Source

View Text - Preformatted


SELECT wtt.rowid row_id, 'WTT' Rec_type, wtt.type_code, wtt.TRANSACTION_TEMP_ID move_order_line_id , wtt.TRANSACTION_TEMP_ID , mol.ORGANIZATION_ID, mol.INVENTORY_ITEM_ID, wtt.TRANSACTION_QUANTITY quantity, wtt.REVISION , wtt.LOT_NUMBER , wtt.LOT_EXPIRATION_DATE , '' LOT_ATTRIBUTE_CATEGORY , wtt.SERIAL_NUMBER, '' SERIAL_ATTRIBUTE_CATEGORY , wtt.FROM_ORGANIZATION_ID , wtt.FROM_SUBINVENTORY_CODE , wtt.FROM_LOCATOR_ID , wtt.FROM_COST_GROUP_ID, 0 pick_strategy_id, decode(wtt.type_code, 2, wtt.RULE_ID , NULL) pick_rule_id, wtt.TO_ORGANIZATION_ID , wtt.TO_SUBINVENTORY_CODE , wtt.TO_LOCATOR_ID , wtt.TO_COST_GROUP_ID, 0 putaway_strategy_id, decode(wtt.type_code, 1, wtt.RULE_ID , NULL) putaway_rule_id, wtt.lpn_id lpn_id, wtt.secondary_QUANTITY secondary_quantity, mol.secondary_uom_code Secondary_uom FROM WMS_TRANSACTIONS_TEMP wtt, MTL_TXN_REQUEST_LINES MOL WHERE wtt.TRANSACTION_TEMP_ID = MOL.LINE_ID AND wtt.line_type_code = 2 AND wtt.type_code in (1, 2) union SELECT mtt.rowid row_id, 'MTT' Rec_type, 0 type_code, mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID, mtt.INVENTORY_ITEM_ID, mtt.TRANSACTION_QUANTITY quantity, mtt.REVISION , mtt.LOT_NUMBER , mtt.LOT_EXPIRATION_DATE , '' LOT_ATTRIBUTE_CATEGORY , mtt.SERIAL_NUMBER, '' SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID, mtt.pick_strategy_id, mtt.pick_rule_id, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID, mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE, mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID, mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID, mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID, mtt.put_away_strategy_id putaway_strategy_id, mtt.put_away_rule_id putaway_rule_id, mtt.allocated_lpn_id lpn_id, mtt.secondary_transaction_QUANTITY secondary_quantity, mtt.secondary_uom_code secondary_uom FROM MTL_MATERIAL_TRANSACTIONS_TEMP mtt where mtt.move_order_line_id is not null and ( ( mtt.transaction_temp_id not in ( select mtlt.transaction_temp_id from mtl_transaction_lots_temp mtlt )) and (mtt.transaction_temp_id not in ( select msnt.transaction_temp_id from mtl_serial_numbers_temp msnt )) ) union SELECT mtt.rowid row_id, 'MTT' Rec_type, 0 type_code, mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID, mtt.INVENTORY_ITEM_ID, mtlt.TRANSACTION_QUANTITY quantity, mtt.REVISION , mtlt.LOT_NUMBER , mtlt.LOT_EXPIRATION_DATE , mtlt.LOT_ATTRIBUTE_CATEGORY , mtt.SERIAL_NUMBER, '' SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID, mtt.pick_strategy_id, mtt.pick_rule_id, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID, mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE, mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID, mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 ,mtt.COST_GROUP_ID, mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID, mtt.put_away_strategy_id putaway_strategy_id, mtt.put_away_rule_id putaway_rule_id, mtt.allocated_lpn_id lpn_id, mtlt.secondary_QUANTITY secondary_quantity, mtt.secondary_uom_code secondary_uom FROM MTL_MATERIAL_TRANSACTIONS_TEMP mtt , mtl_transaction_lots_temp mtlt where mtt.move_order_line_id is not null and mtt.transaction_temp_id = mtlt.transaction_temp_id and mtlt.serial_transaction_temp_id is null union SELECT mtt.rowid row_id, 'MTT' Rec_type, 0 type_code, mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID, mtt.INVENTORY_ITEM_ID, mtt.TRANSACTION_QUANTITY quantity, mtt.REVISION , mtt.LOT_NUMBER , mtt.LOT_EXPIRATION_DATE , '' LOT_ATTRIBUTE_CATEGORY , msnt.FM_SERIAL_NUMBER SERIAL_NUMBER, msnt.SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID, mtt.pick_strategy_id, mtt.pick_rule_id, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID, mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE, mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID, mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID, mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID, mtt.put_away_strategy_id putaway_strategy_id, mtt.put_away_rule_id putaway_rule_id, mtt.allocated_lpn_id lpn_id, mtt.secondary_transaction_QUANTITY secondary_quantity, mtt.secondary_uom_code secondary_uom FROM MTL_MATERIAL_TRANSACTIONS_TEMP mtt , mtl_serial_numbers_temp msnt where mtt.move_order_line_id is not null and mtt.transaction_temp_id = msnt.transaction_temp_id union SELECT mtt.rowid row_id, 'MTT' Rec_type, 0 type_code, mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID, mtt.INVENTORY_ITEM_ID, mtt.TRANSACTION_QUANTITY quantity, mtt.REVISION , mtlt.LOT_NUMBER , mtlt.LOT_EXPIRATION_DATE , mtlt.LOT_ATTRIBUTE_CATEGORY , msnt.fm_SERIAL_NUMBER SERIAL_NUMBER, msnt.SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID, mtt.pick_strategy_id, mtt.pick_rule_id, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID, mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE, mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID, mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID, mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID, mtt.put_away_strategy_id putaway_strategy_id, mtt.put_away_rule_id putaway_rule_id, mtt.allocated_lpn_id lpn_id, mtt.secondary_transaction_QUANTITY secondary_quantity, mtt.secondary_uom_code secondary_uom FROM MTL_MATERIAL_TRANSACTIONS_TEMP mtt ,mtl_transaction_lots_temp mtlt ,mtl_serial_numbers_temp msnt WHERE mtt.move_order_line_id is not null and mtt.transaction_temp_id = mtlt.transaction_temp_id and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id

View Text - HTML Formatted

SELECT WTT.ROWID ROW_ID
, 'WTT' REC_TYPE
, WTT.TYPE_CODE
, WTT.TRANSACTION_TEMP_ID MOVE_ORDER_LINE_ID
, WTT.TRANSACTION_TEMP_ID
, MOL.ORGANIZATION_ID
, MOL.INVENTORY_ITEM_ID
, WTT.TRANSACTION_QUANTITY QUANTITY
, WTT.REVISION
, WTT.LOT_NUMBER
, WTT.LOT_EXPIRATION_DATE
, '' LOT_ATTRIBUTE_CATEGORY
, WTT.SERIAL_NUMBER
, '' SERIAL_ATTRIBUTE_CATEGORY
, WTT.FROM_ORGANIZATION_ID
, WTT.FROM_SUBINVENTORY_CODE
, WTT.FROM_LOCATOR_ID
, WTT.FROM_COST_GROUP_ID
, 0 PICK_STRATEGY_ID
, DECODE(WTT.TYPE_CODE
, 2
, WTT.RULE_ID
, NULL) PICK_RULE_ID
, WTT.TO_ORGANIZATION_ID
, WTT.TO_SUBINVENTORY_CODE
, WTT.TO_LOCATOR_ID
, WTT.TO_COST_GROUP_ID
, 0 PUTAWAY_STRATEGY_ID
, DECODE(WTT.TYPE_CODE
, 1
, WTT.RULE_ID
, NULL) PUTAWAY_RULE_ID
, WTT.LPN_ID LPN_ID
, WTT.SECONDARY_QUANTITY SECONDARY_QUANTITY
, MOL.SECONDARY_UOM_CODE SECONDARY_UOM
FROM WMS_TRANSACTIONS_TEMP WTT
, MTL_TXN_REQUEST_LINES MOL
WHERE WTT.TRANSACTION_TEMP_ID = MOL.LINE_ID
AND WTT.LINE_TYPE_CODE = 2
AND WTT.TYPE_CODE IN (1
, 2) UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTT.TRANSACTION_QUANTITY QUANTITY
, MTT.REVISION
, MTT.LOT_NUMBER
, MTT.LOT_EXPIRATION_DATE
, '' LOT_ATTRIBUTE_CATEGORY
, MTT.SERIAL_NUMBER
, '' SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTT.SECONDARY_TRANSACTION_QUANTITY SECONDARY_QUANTITY
, MTT.SECONDARY_UOM_CODE SECONDARY_UOM
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MTT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND ( ( MTT.TRANSACTION_TEMP_ID NOT IN ( SELECT MTLT.TRANSACTION_TEMP_ID
FROM MTL_TRANSACTION_LOTS_TEMP MTLT ))
AND (MTT.TRANSACTION_TEMP_ID NOT IN ( SELECT MSNT.TRANSACTION_TEMP_ID
FROM MTL_SERIAL_NUMBERS_TEMP MSNT )) ) UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTLT.TRANSACTION_QUANTITY QUANTITY
, MTT.REVISION
, MTLT.LOT_NUMBER
, MTLT.LOT_EXPIRATION_DATE
, MTLT.LOT_ATTRIBUTE_CATEGORY
, MTT.SERIAL_NUMBER
, '' SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTLT.SECONDARY_QUANTITY SECONDARY_QUANTITY
, MTT.SECONDARY_UOM_CODE SECONDARY_UOM
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MTT
, MTL_TRANSACTION_LOTS_TEMP MTLT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID
AND MTLT.SERIAL_TRANSACTION_TEMP_ID IS NULL UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTT.TRANSACTION_QUANTITY QUANTITY
, MTT.REVISION
, MTT.LOT_NUMBER
, MTT.LOT_EXPIRATION_DATE
, '' LOT_ATTRIBUTE_CATEGORY
, MSNT.FM_SERIAL_NUMBER SERIAL_NUMBER
, MSNT.SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTT.SECONDARY_TRANSACTION_QUANTITY SECONDARY_QUANTITY
, MTT.SECONDARY_UOM_CODE SECONDARY_UOM
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MTT
, MTL_SERIAL_NUMBERS_TEMP MSNT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTT.TRANSACTION_QUANTITY QUANTITY
, MTT.REVISION
, MTLT.LOT_NUMBER
, MTLT.LOT_EXPIRATION_DATE
, MTLT.LOT_ATTRIBUTE_CATEGORY
, MSNT.FM_SERIAL_NUMBER SERIAL_NUMBER
, MSNT.SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTT.SECONDARY_TRANSACTION_QUANTITY SECONDARY_QUANTITY
, MTT.SECONDARY_UOM_CODE SECONDARY_UOM
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MTT
, MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_SERIAL_NUMBERS_TEMP MSNT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID
AND MTLT.SERIAL_TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID