APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_SLS_FRCST_ITEM

Line 469: FROM DDR_I_SLS_FRCST_ITEM

465: SRC_SYS_IDNT, SRC_SYS_DT,
466: PERIOD_TYP_FLAG, LOC_IDNT_CD,
467: LOC_IDNT_FLAG, ORG_LVL_CD,
468: 'I','N', TRANS_DT
469: FROM DDR_I_SLS_FRCST_ITEM
470: WHERE
471: (TRANS_DT, FRCST_NBR,
472: FRCST_TYP, LOC_IDNT_CD,
473: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,

Line 483: FROM DDR_I_SLS_FRCST_ITEM

479: FRCST_TYP, LOC_IDNT_CD,
480: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
481: GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,
482: LOC_IDNT_FLAG, ORG_LVL_CD, SRC_SYS_DT
483: FROM DDR_I_SLS_FRCST_ITEM
484: GROUP BY
485: TRANS_DT, FRCST_NBR,
486: FRCST_TYP, LOC_IDNT_CD,
487: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,

Line 498: DELETE FROM DDR_I_SLS_FRCST_ITEM

494:
495: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
496:
497:
498: DELETE FROM DDR_I_SLS_FRCST_ITEM
499: WHERE
500: (TRANS_DT, FRCST_NBR,
501: FRCST_TYP, LOC_IDNT_CD,
502: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,