DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_SL_RTN_ITEM

Line 369: INSERT INTO DDR_E_RTL_SL_RTN_ITEM

365:
366: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
367:
368:
369: INSERT INTO DDR_E_RTL_SL_RTN_ITEM
370: (REC_ID, LOAD_ID, ERR_REASON,
371: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
372: GLBL_ITEM_ID_TYP, UOM, SLS_QTY,
373: SLS_AMT, SLS_COST_AMT,RTRN_QTY,

Line 426: FROM DDR_E_RTL_SL_RTN_ITEM

422: LOC_IDNT_CD, GLBL_ITEM_ID,
423: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
424: TRANS_DT, PERIOD_TYP_FLAG,
425: LOC_IDNT_FLAG, ORG_LVL_CD
426: FROM DDR_E_RTL_SL_RTN_ITEM
427: GROUP BY
428: LOC_IDNT_CD, GLBL_ITEM_ID,
429: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
430: TRANS_DT, PERIOD_TYP_FLAG,