SELECT mi.inventory_item_id, mi.item_name, srh.level2_sr_pk, srh.level2, srh.sdate, srh.ebs_ret_qty FROM msd_dem_srp_return_history srh,msc_items mi WHERE mi.item_name = srh.level1
View Text - HTML Formatted
SELECT MI.INVENTORY_ITEM_ID , MI.ITEM_NAME , SRH.LEVEL2_SR_PK , SRH.LEVEL2 , SRH.SDATE , SRH.EBS_RET_QTY FROM MSD_DEM_SRP_RETURN_HISTORY SRH , MSC_ITEMS MI WHERE MI.ITEM_NAME = SRH.LEVEL1