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_RTL_SL_RTN_ITEM

Line 451: FROM DDR_I_RTL_SL_RTN_ITEM

447: RTRN_COST_AMT, SRC_SYS_IDNT,
448: SRC_SYS_DT, PERIOD_TYP_FLAG,
449: LOC_IDNT_CD, LOC_IDNT_FLAG,
450: ORG_LVL_CD,'I','N',TRANS_DT, PRMTN_FLAG, RTL_ORG_CD
451: FROM DDR_I_RTL_SL_RTN_ITEM
452: WHERE
453: (LOC_IDNT_CD, GLBL_ITEM_ID,
454: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
455: TRANS_DT, PERIOD_TYP_FLAG,

Line 463: FROM DDR_I_RTL_SL_RTN_ITEM

459: LOC_IDNT_CD, GLBL_ITEM_ID,
460: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
461: TRANS_DT, PERIOD_TYP_FLAG,
462: LOC_IDNT_FLAG, ORG_LVL_CD, RTL_ORG_CD
463: FROM DDR_I_RTL_SL_RTN_ITEM
464: GROUP BY
465: LOC_IDNT_CD, GLBL_ITEM_ID,
466: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
467: TRANS_DT, PERIOD_TYP_FLAG,

Line 477: DELETE FROM DDR_I_RTL_SL_RTN_ITEM

473:
474: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
475:
476:
477: DELETE FROM DDR_I_RTL_SL_RTN_ITEM
478: WHERE
479: (LOC_IDNT_CD, GLBL_ITEM_ID,
480: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
481: TRANS_DT, PERIOD_TYP_FLAG,