need a query to populate the BIIO table to copy the data from one series to other series??

we want to populate the BIIO table to copy the data from one series to other series??

we have created one series and one import integration interface with that series.

below is the query used to populate the data into BIIO table.

after running the Integration Interface thru workflow , worksheet is displaying incorrect numbers in that series than what i have loaded in the BIIO table. i don't see any errors in in the BIIO error table.

SELECT sd.sales_date,sd.item_id,itm.item,sd.location_id,org.organization,dist.ls1,NVL (pseudo_sale, actual_quantity) hist,                         

                     FROM sales_data sd,