We have records in table XX_LTST_DETAIL. The few columns in this table are item,family,type,reserve, fiscal_year,period,transaction_type,quantity,value,transaction_date,subinventory.
Now, we created new table XX_LTST_RESERVE_DETAIL where it will fetch few records based on few conditions from above XX_LTST_DETAIL. Now, I need to fetch all the remaining records from XX_LTST_DETAIL. Can any one let me know how to do that…?
Here, XX_LTST_DETAIL may contain more than one record for a single item.