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_trading_partners mtp, msc_system_items mi WHERE mtp.organization_code = sh.dm_org_code AND mtp.partner_type = 3 AND NVL(mtp.company_id,-1) = -1 AND mi.plan_id = -1 AND mi.sr_instance_id = mtp.sr_instance_id AND mi.organization_id = mtp.sr_tp_id AND mi.sr_inventory_item_id = sh.ebs_item_sr_pk

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_TRADING_PARTNERS MTP
, MSC_SYSTEM_ITEMS MI
WHERE MTP.ORGANIZATION_CODE = SH.DM_ORG_CODE
AND MTP.PARTNER_TYPE = 3
AND NVL(MTP.COMPANY_ID
, -1) = -1
AND MI.PLAN_ID = -1
AND MI.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MI.ORGANIZATION_ID = MTP.SR_TP_ID
AND MI.SR_INVENTORY_ITEM_ID = SH.EBS_ITEM_SR_PK