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 388: FROM DDR_I_RTL_SL_RTN_ITEM

384: RTRN_COST_AMOUNT, SRC_SYS_IDNT,
385: SRC_SYS_DT, PERIOD_TYP_FLAG,
386: LOC_IDNT_CD, LOC_IDNT_FLAG,
387: ORG_LVL_CD,'I','N',TRANS_DT
388: FROM DDR_I_RTL_SL_RTN_ITEM
389: WHERE
390: (LOC_IDNT_CD, GLBL_ITEM_ID,
391: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
392: TRANS_DT, PERIOD_TYP_FLAG,

Line 400: FROM DDR_I_RTL_SL_RTN_ITEM

396: LOC_IDNT_CD, GLBL_ITEM_ID,
397: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
398: TRANS_DT, PERIOD_TYP_FLAG,
399: LOC_IDNT_FLAG, ORG_LVL_CD
400: FROM DDR_I_RTL_SL_RTN_ITEM
401: GROUP BY
402: LOC_IDNT_CD, GLBL_ITEM_ID,
403: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
404: TRANS_DT, PERIOD_TYP_FLAG,

Line 414: DELETE FROM DDR_I_RTL_SL_RTN_ITEM

410:
411: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
412:
413:
414: DELETE FROM DDR_I_RTL_SL_RTN_ITEM
415: WHERE
416: (LOC_IDNT_CD, GLBL_ITEM_ID,
417: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
418: TRANS_DT, PERIOD_TYP_FLAG,