DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_RTL_SHIP_ITEM

Line 358: FROM DDR_I_RTL_SHIP_ITEM

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,

Line 374: FROM DDR_I_RTL_SHIP_ITEM

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,

Line 390: DELETE FROM DDR_I_RTL_SHIP_ITEM

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,