354: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
355: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,
356: SRC_SYS_DT,'I','N', TRANS_DT,
357: RTL_ORG_CD, SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_CD, SHIP_COST
358: FROM DDR_I_RTL_SHIP_ITEM
359: WHERE
360: (GLBL_ITEM_ID,
361: RTL_BSNS_UNIT_CD,
362: RTL_SKU_ITEM_NBR,
370: RTL_SKU_ITEM_NBR,
371: GLBL_ITEM_ID_TYP,
372: TRANS_DT, RTL_ORG_CD,
373: SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_CD
374: FROM DDR_I_RTL_SHIP_ITEM
375: GROUP BY
376: GLBL_ITEM_ID,
377: RTL_BSNS_UNIT_CD,
378: RTL_SKU_ITEM_NBR,
386:
387: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
388:
389:
390: DELETE FROM DDR_I_RTL_SHIP_ITEM
391: WHERE
392: (GLBL_ITEM_ID,
393: RTL_BSNS_UNIT_CD,
394: RTL_SKU_ITEM_NBR,