DBA Data[Home] [Help]

VIEW: APPS.MSD_INSTALL_BASE_HISTORY_V

Source

View Text - Preformatted

SELECT mi.inventory_item_id, mi.item_name, ibh.sdate1, ibh.sdate2, ibh.ebs_ins_qty FROM msd_dem_ins_base_history ibh, msc_items mi WHERE mi.item_name = ibh.level1
View Text - HTML Formatted

SELECT MI.INVENTORY_ITEM_ID
, MI.ITEM_NAME
, IBH.SDATE1
, IBH.SDATE2
, IBH.EBS_INS_QTY
FROM MSD_DEM_INS_BASE_HISTORY IBH
, MSC_ITEMS MI
WHERE MI.ITEM_NAME = IBH.LEVEL1