VIEW: APPS.MSD_SHIPMENT_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, sh.sales_date, sh.ebs_ship_hist_ship_qty_sd FROM t_src_sales_tmpl sh, msc_items mi, msc_trading_partners mtp WHERE mi.item_name = sh.dm_item_code and mtp.organization_code= sh.dm_org_code 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
, SH.SALES_DATE
, SH.EBS_SHIP_HIST_SHIP_QTY_SD
FROM T_SRC_SALES_TMPL SH
, MSC_ITEMS MI
, MSC_TRADING_PARTNERS MTP
WHERE MI.ITEM_NAME = SH.DM_ITEM_CODE
AND MTP.ORGANIZATION_CODE= SH.DM_ORG_CODE
AND MTP.PARTNER_TYPE = 3
AND NVL(MTP.COMPANY_ID
, -1) = -1