Misc Transaction

INSERT
INTO mtl_transactions_interface(
transaction_interface_id
, Source_code
, source_header_id
, source_line_id
, process_flag
, transaction_mode
, item_segment1
, inventory_item_id
, organization_id
, distribution_account_id
, subinventory_code
, transaction_uom
, transaction_date
, transaction_type_id
, transaction_quantity
, creation_date
, created_by
, last_update_date
, last_updated_by
)
SELECT MTL_MATERIAL_TRANSACTIONS_S.nexval transaction_interface_id
, 'Costing/Non-costing adjustment' Source_code
, 199 source_header_id
, 199 source_line_id
, -9 process_flag
, 3 transaction_mode
, msi.segment1 item_segment1
, msi.inventory_item_id inventory_item_id
--, ood.organization_code
, ood.organization_id
, DECODE(ood.set_of_books_id,1,50066,NULL) distribution_account_id
, moq.subinventory_code
, moq.transaction_uom_code transaction_uom
, TRUNC(SYSDATE) transaction_date
, 32 transaction_type_id -- issue 42--receipt
, SUM(moq.transaction_quantity) transaction_quantity
, SYSDATE
, 17879
, SYSDATE
, 17879
FROM mtl_system_items msi
, mtl_onhand_quantities_detail moq
, org_organization_definitions ood
WHERE msi.organization_id = 2
AND moq.inventory_item_id = msi.inventory_item_id
AND ood.organization_id = moq.organization_id
AND msi.segment1 IN ('TSTITM')
GROUP BY msi.segment1
, msi.inventory_item_id
--, ood.organization_code
, ood.organization_id
, ood.set_of_books_id
, moq.subinventory_code
, moq.transaction_uom_code