VIEW: APPS.MSD_DPT_RPR_USG_HISTORY_V

Source

View Text - Preformatted

SELECT mtp.sr_instance_id, mi.inventory_item_id, mi.item_name, mtp.sr_tp_id, mtp.organization_code, druh.sdate, druh.ebs_usg_qty FROM msd_dem_dpt_rep_usg_history druh, msc_items mi, msc_trading_partners mtp WHERE mi.item_name = druh.level1 and mtp.organization_code= druh.level2 and mtp.partner_type = 3 and nvl(mtp.company_id,-1) = -1

View Text - HTML Formatted

SELECT MTP.SR_INSTANCE_ID
, MI.INVENTORY_ITEM_ID
, MI.ITEM_NAME
, MTP.SR_TP_ID
, MTP.ORGANIZATION_CODE
, DRUH.SDATE
, DRUH.EBS_USG_QTY
FROM MSD_DEM_DPT_REP_USG_HISTORY DRUH
, MSC_ITEMS MI
, MSC_TRADING_PARTNERS MTP
WHERE MI.ITEM_NAME = DRUH.LEVEL1
AND MTP.ORGANIZATION_CODE= DRUH.LEVEL2
AND MTP.PARTNER_TYPE = 3
AND NVL(MTP.COMPANY_ID
, -1) = -1