eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_SLS_FRCST_ITEM

Line 531: FROM DDR_I_SLS_FRCST_ITEM

527: SRC_SYS_IDNT, SRC_SYS_DT,
528: PERIOD_TYP_FLAG, LOC_IDNT_CD,
529: LOC_IDNT_FLAG, ORG_LVL_CD,
530: 'I','N', TRANS_DT, RTL_ORG_CD,FRCST_PURP
531: FROM DDR_I_SLS_FRCST_ITEM
532: WHERE
533: (TRANS_DT, FRCST_NBR,
534: FRCST_TYP, LOC_IDNT_CD,
535: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,

Line 545: FROM DDR_I_SLS_FRCST_ITEM

541: FRCST_TYP, LOC_IDNT_CD,
542: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
543: GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,
544: LOC_IDNT_FLAG, ORG_LVL_CD, SRC_SYS_DT, RTL_ORG_CD,FRCST_PURP
545: FROM DDR_I_SLS_FRCST_ITEM
546: GROUP BY
547: TRANS_DT, FRCST_NBR,
548: FRCST_TYP, LOC_IDNT_CD,
549: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,

Line 560: DELETE FROM DDR_I_SLS_FRCST_ITEM

556:
557: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
558:
559:
560: DELETE FROM DDR_I_SLS_FRCST_ITEM
561: WHERE
562: (TRANS_DT, FRCST_NBR,
563: FRCST_TYP, LOC_IDNT_CD,
564: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,