VIEW: APPS.MSD_FLD_SER_USG_HISTORY_V

Source

View Text - Preformatted

SELECT mi.inventory_item_id, mi.item_name, fsuh.level2_sr_pk, fsuh.level2, fsuh.sdate, fsuh.ebs_usg_qty FROM msd_dem_fld_ser_usg_history fsuh, msc_items mi WHERE mi.item_name = fsuh.level1

View Text - HTML Formatted

SELECT MI.INVENTORY_ITEM_ID
, MI.ITEM_NAME
, FSUH.LEVEL2_SR_PK
, FSUH.LEVEL2
, FSUH.SDATE
, FSUH.EBS_USG_QTY
FROM MSD_DEM_FLD_SER_USG_HISTORY FSUH
, MSC_ITEMS MI
WHERE MI.ITEM_NAME = FSUH.LEVEL1