DBA Data[Home] [Help]

VIEW: APPS.MSD_SRP_RETURN_HISTORY_V

Source

View Text - Preformatted

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