APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_SL_RTN_ITEM

Line 432: INSERT INTO DDR_E_RTL_SL_RTN_ITEM

428:
429: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
430:
431:
432: INSERT INTO DDR_E_RTL_SL_RTN_ITEM
433: (REC_ID, LOAD_ID, ERR_REASON,
434: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
435: GLBL_ITEM_ID_TYP, UOM, SLS_QTY,
436: SLS_AMT, SLS_COST_AMT,RTRN_QTY,

Line 489: FROM DDR_E_RTL_SL_RTN_ITEM

485: LOC_IDNT_CD, GLBL_ITEM_ID,
486: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
487: TRANS_DT, PERIOD_TYP_FLAG,
488: LOC_IDNT_FLAG, ORG_LVL_CD, RTL_ORG_CD
489: FROM DDR_E_RTL_SL_RTN_ITEM
490: GROUP BY
491: LOC_IDNT_CD, GLBL_ITEM_ID,
492: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
493: TRANS_DT, PERIOD_TYP_FLAG,

Line 695: INSERT INTO ddr_e_rtl_sl_rtn_item

691:
692: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
693:
694: FOR rec IN c1 LOOP --{
695: INSERT INTO ddr_e_rtl_sl_rtn_item
696: (crncy_cd
697: ,day_cd
698: ,eff_from_dt
699: ,eff_to_dt